Livereport

[alexsandro9]

Hi genius,

i would like to create a report using Livereport but i have a problem with SQL


i would like to create a report with all document approval. this document will be aproved during the step of workflow.

now where i take the information in the document's table or workflow's table?

and which are this table and field that i must used?

thank in advance

Alessandro

 

[alexsandro9]

Where are all table in livelink? and How can i see this?

 

[ggriffit]

You can get the database schema from your OpenText account team, although you will need to sign an NDA, would need more information on the workflow process and data to help you construct a SQL Statement, although this forum and the KC contain lots of examples of similar events.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[appnair]

http://www.tek-tips.com/faqs.cfm?fid=7675

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in