LiveReport to list all Form Templates

I would like to run a report on all Form Templates that have been developed in our Livelink instance. What SQL would I need for this? Thank you for your help.

Find more posts tagged with

Comments

Donna Nalls

Hi Mary,You can use the following sql:select * from dtree where %1then select "Filter Form Template" in the "Param %1" drop-down.ORselect * from dtree where subtype = 230Regards,Donna

Walaa_Elshabrawy

Message from Walaa Elshabrawy via eLinkHello Mary,Form templates have the subtype 230 , so doing something like a simpleselect statement(Select * from DTree where subtype=230), should returninfo about all the Form templates created in your Livelink system.ThanksWalaa Elshabrawy Product Support SpecialistCustomer Support -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, February 26, 2008 5:15 PMTo: eLink RecipientSubject: LiveReport to list all Form TemplatesLiveReport to list all Form TemplatesPosted by Corona, Mary on 02/26/2008 05:11 PMI would like to run a report on all Form Templates that have beendeveloped in our Livelink instance. What SQL would I need for this?Thank you for your help.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Mary_Slane_Corona

Thank you both for your responses. The report works fine.