WW logo WoodWing Knowledge Base Glossary    Contact Us
Search  
   
Browse by Category
WoodWing Knowledge Base .: Smart Connection .: Smart Connection Enterprise .: How can I see the new v3.3 columns in my Inbox query?

How can I see the new v3.3 columns in my Inbox query?

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"

How helpful was this article to you?

Related Articles

article Query doesn't return correct results when using Oracle database
Problem When using an Oracle database and...

(No rating)  May 4, 2005    Views: 2279   
article How to add custom metadata in query results
Versions affected: Smart Connection...

(No rating)  February 1, 2008    Views: 1516   
article Requirements for creating a custom Named Query
Affected versions: 6Affect

(No rating)  September 4, 2009    Views: 646   


.: Powered by Lore 1.5.1
© 2004-2008 WoodWing Software BV - All Rights Reserved.