Hi all,
I'm using Lapi search API to write a module to search into livelink personel workspace. The reult will also be filtered and sorted. But i have a problem. In all the personel workspace, it contains all the shortcut instead of the origin document.
My requirments neeed me to do sort and filter by the metadata of the origin document. Any ideas how i can go about doing it?
My idea: is to write a simple sql statment to query the database into the personel workspace, sql statment allow me to grab the orgindataid from the livelink database. USing this dataid i can pass it into the Lapi search(apply query). But the disadvantage is that if there is 1000 shortcut, i will need to pass these 1000 id into the where clause of the apply query. The time taken for the search to return will take longer time..
