Does Livelink has API's to execute sql Qeuries

[DilipN]

Hi ,

I have a requirement where i have to query the Livelink database and display the results. Are there any Apis which allows to execute the "SELECT" query and return the results, or I will have to use the JDBC calls for this.

I checked the ApplyQuery functions but that is used only for searching the objects

Any help is appreciated.

Thank you in Advance.

 

[ggriffit]

why would you need to use SQL rather than useing the API's ? what are you trying to achieve ?

 

[DilipN]

Thank You very much for your response.

I am doing a workflow related application. where different authors/initiators initiate a workflow and assign a approver and attach a document to this workflow.

This application is integrated with Plumtree portal.

In this application there is a requirement that if the plumtree administrator is logged in then i need to show a portlet where he can see all the workflows initiated till date by all the initiators, and he should be able to check the status of any workflow, whether it is approved or rejected.

Basically Administrator should be able to see all the workflows submitted till date.

I do have a sql ready which returns me all the workflow's with status. now i just need to implement it.

please let me know if this is not clear.

Thank You,

Dilip.

 

[ggriffit]

You may be able to get that via LAPI - someone like appnair would be able to tell you more. The direct SQL may also work, but bear in mind that if you change your Livelink versions, e.g. adding a patch, service release etc may affect the schema of each server.

 

[appnair]

Use native JDBC that will be faster.Alternatively if you wanted to withstand future upgardes/schema changes like
Greg says ,use the
LAPI call
public int ListManagedStatus(
int flags,
String view,
String where,
LLValue statusList

In the call you will call your view ,the standard view is WebActiveWork,which is probably the one that you are calling with SQL.the where could be tricky .You do not use where but say "managerid=1234".The statuslist is your output recarray which you can HTML'ize if you want.


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937