Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
worklist list (sql)
camomile
Worklist is the pre-coded view folder. Can someone suggest which sql tables are queried to get this view?
TIA
Julius
Find more posts tagged with
Comments
jny
The recommended way to get this documents collection is via the COM API. There is a Worklist Property off of the database object that returns the worklist items. You may get a handle to this database object after you have established a connected NRTDMS object which is the root object.
For further clarification, see the COM Reference Manual for WorkSite 8.0.pdf (or iManCOMManual.pdf) in the Worksite iToolkit.
Database access is carefully tuned to insure scalability and concurrent access. If you access the database directly, you throw out all of this carefully tuning and run a high risk of your system being unavailable. In all, it goes against the core of Interwoven's 3-tier architecture design.
hope this helps.
Migrateduser
The table that holds that information is 'Quick_Retrieve'
jny
If you're developing customization, use the COM API that is distributed with the SDK. Please do not access the SQL table directly. This is not supported by the SDK.
camomile
Thanks for "QR" table.
Regarding SDK - if I would like to rewrite FileSite, probably I would use it. Right now I have a problem of bad migration from Hummingbird and very historic data as current WorkList - it will clear itself up with time, but users are not happy.
Thanks for help