08 Sep

Livelink Database – List full path of nodes under a given Livelink Node

Posted by Hussain, under Database, Livelink

Recently I was working on some SQL for a client who wanted to list the full path information for all items under a given Livelink node. As the customer was using SQL Server rather than Oracle I could not use the Connect By functionality. To begin with I tweaked an SQL Server function that Stephen Fisher had posted on the Knowledge Center which returns the full path, seperated by colon’s, to a given Livelink Node, a new version of the SQL is shown below : Continue reading...

No Comments | Tags: , , , ,
08 Sep

Get Default link for a Node

Posted by Hussain, under Livelink

Sometimes you may have a Livelink Object ID (the value of dataid from dtree) and you need to create a link to that object. Generally you can find most of the components that you need in the request object, such as the complete URL, but the actual Request Handler for that type of Livelink Object is a little more complex. You can follow the function calls used in the Browse pages, but sometimes you do not have enough information, for example when within a function where these objects are not available.
This article looks at an alternative method to get a link to that Livelink Object. For this we will use the Livelink URL that is used by the Notifications system (?func=notify.config). Continue reading...

No Comments | Tags: , , , ,