|
Question
After upgrading my v3.2 installation to v3.3 I want to see the new dynamic columns in my InBox query (locked by icon, status color icon and locked by column)
Resolution
The v3.2 (and before) definitions of the Inbox SQL statement does not contain these columns. Changing your Inbox SQL definition (NamedQuery manager on SCEnt admin screen) to the following SQL statement gives you the new columns:
select o.id, o.type as "Type", o.name as "Name", st.state as "State", o.routeto as "RouteTo", o.slugline as "Snippet", o.comment as "Comment",
ul.fullname as "LockedBy", ol.name as "PlacedOn",
o.filesize as "FileSize", o.lengthwords as "LengthWords", o.lengthchars as "LengthChars", o.lengthlines as "LengthLines",
um.fullname as "Modifier", o.modified as "Modified",
p.publication as "Publication", i.issue as "Issue", s.section as "Section",
p.id as "PublicationId", i.id as "IssueId", s.id as "SectionId", st.id as "StateId"
from smart_objects as o
left join smart_users as um on (o.modifier = um.user)
left join smart_users as uc on (o.creator = uc.user)
left join smart_objectlocks as l on (o.id = l.object)
left join smart_users as ul on (l.usr = ul.user)
left join smart_objectrelations as r on (o.id = r.child)
left join smart_objects as ol on (r.parent = ol.id)
left join smart_publications as p on (o.publication = p.id)
left join smart_publissues as i on (o.issue = i.id)
left join smart_publsections as s on (o.section = s.id)
left join smart_states as st on (o.state = st.id)
left join smart_groups as gr on (o.routeto = gr.name)
left join smart_usrgrp as ug on (gr.id = ug.grpid)
left join smart_users as ur on (ug.usrid = ur.id)
where o.routeto = "$user" or ur.user= "$user"
|
|
Article
|
058
|
|
Created
|
February 1, 2005
|
|
Author
|
WoodWing
|
|
Rating
|
   
|
|