Retrieving resultset of a SQL query using LAPI

Meera_Kanekal_(meerakanekal_-_(deleted))

I am kicking off more than one workflow from my Java code thru a UI. I want to retrieve the status of all the workflows --> what status they are in. How do we set the Sql query to run against LL database and retrieve the result using LAPI?

eLink User

Message from Nair, Krishnankutty via eLinkThe way typically reports against workflows are done is againstwebactivework,which is a view of all the associated tables of livelinkworkflow.So typically in my case I came up with a query somethjing likeSelect * from webactivework where work_managerid=1234 and and WORK_WORKID = SUBWORK_SUBWORKID and WORK_STATUS = 2The above query can be understood as give me all data for workflows werethe managerid is a group in livelink(if your master manger is initiator,it is bad practice,you are lookingfor trouble in reporting) and Where the work_status is executing.Search the livereports artea if you are not sure about the livelinkworkflow schema,the different statuses et al.Take also a look at Java/.NET Method Declarationpublic int ListManagedStatus( int flags, String view, String where, LLValue statusList )I belive you can formulate the where like the work_managerid=1234 andspecify the view here alsoAnd that would make your code stay in the lapi realm itself. -----Original Message-----From: eLink Discussion: LAPI Discussion[mailto:lapi@elinkkc.opentext.com] Sent: Tuesday, May 01, 2007 12:42 PMTo: eLink RecipientSubject: Retrieving resultset of a SQL query using LAPIRetrieving resultset of a SQL query using LAPI Posted by Kanekal, Meeraon 05/01/2007 01:38 PMI am kicking off more than one workflow from my Java code thru a UI. Iwant to retrieve the status of all the workflows --> what status theyare in. How do we set the Sql query to run against LL database andretrieve the result using LAPI?[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: LAPI Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/765428Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.lapi@elinkkc.opentext.com.-----------------------------------------*Please note my E-Mail Address has changed. Please update yourcontact list*Anadarko Confidentiality Notice: This electronic transmission and any attached documents or otherwritings are intended only for the person or entity to which it isaddressed and may contain information that is privileged,confidential or otherwise protected from disclosure. If you havereceived this communication in error, please immediately notifysender by return e-mail and destroy the communication. Anydisclosure, copying, distribution or the taking of any actionconcerning the contents of this communication or any attachments byanyone other than the named recipient is strictly prohibited.