get nodeid given object's name?

Dimitar_Belyovski_(NETBRI012_(Delete)_2516594)

Is it possible to get the object's nodeid given object's name?

Find more posts tagged with

Comments

Yes, if you aren't afraid to write a SQL query to ask the database directly, and if the object name is unique. You should be able to just query the dtree table searching the name field with the object name, and get back the dataid.

Kevin_Ward

Message from Kevin Ward <<A HREF="mailto:kward@opentext.com">kward@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

You could also write a LiveReport in Livelink that queries the DTree table based on name and run it from LAPI using RunReport (LAPI 9.1.x).

Kevin

-----Original Message-----
From: eLink Discussion: LAPI Discussion [mailto:lapi@elinkkc.opentext.com]
Sent: May 22, 2003 9:45 AM
To: eLink Recipient
Subject: Yes, if you aren't afraid to write a SQL query to ask the database directly,...

Yes, if you aren't afraid to write a SQL query to ask the database directly,... Posted by AberUser6 (Casser, Theodore) on 05/22/2003 09:42 AM
In reply to: get nodeid given object's name? Posted by NETBRI012 (Belyovski, Dimitar) on 05/21/2003 09:42 PM

Yes, if you aren't afraid to write a SQL query to ask the database directly, and if the object name is unique. You should be able to just query the dtree table searching the name field with the object name, and get back the dataid.

***_****_(citlon01admin_-_(deleted))

The following will use SDK and search the enterprise based on regions: 'Initialize the Livelink API. 'The LL_Initialize call initializes the Livelink API, and, in the process, verifies that the text 'definition files and *.dll files are of compatible versions. If initialization fails, an error message 'is printed and execution terminates. Otherwise, execution continues. lStatus = LL_Initialize(LL_HEADER_VERSION) If (lStatus <> LL_OK) Then End End If 'Allocate value objects. 'The value objects that will be used later in the program are allocated. '(Value objects are used extensively in Livelink to store many kinds of 'information. In this program they store the allocated session and Livelink 'Library object information.) If allocation fails, an error message is printed 'and execution terminates. Otherwise, execution continues. ' grab some value objects lStatus = LL_ValueAlloc(lMessage) If (lStatus <> LL_OK) Then End End If 'Allocate a session and connect to the Livelink server. 'Upon successful initialization, the LL_SessionAllocEx call allocates a session 'and attempts to connect to the Livelink server. If the connection cannot be made '( LL_SessionAllocEx does not return LL_OK), execution skips, 'where the connection error is retrieved by making the LL_SessionStatus call and 'is displayed. Otherwise, execution continues. ' Allocate our session lStatus = LL_SessionAllocEx(lSession, "clnt_lltest", 2099, "livelink", "Admin", "abc123", 0) If (lStatus <> LL_OK) Then lStatus = LL_SessionStatus(lSession, siz, lMessage) If (lStatus <> LL_OK) Then End End If End If ' Use Search Engine to find documents ' create a list of the scopes that are available to use Dim listBrokers As Long lStatus = LL_ValueAlloc(listBrokers) lStatus = LL_ValueSetAssoc(listBrokers) lStatus = LL_ValueSetList(listBrokers) lStatus = LL_GetSearchBrokers(lSession, listBrokers) ' what is the number of brokers found in the list Dim intNumberofBrokers As Long lStatus = LL_ValueGetLength(listBrokers, intNumberofBrokers) Dim lAssoc As Long Dim intNodeID As Long Dim strNodeName As String Dim intLoop As Long lStatus = LL_ValueAlloc(lAssoc) intLoop = 0 Do Until Left(buf, siz) = "Enterprise" ' look for the enterprise scope ' get the association from the list of brokers lStatus = LL_ListGetValue(listBrokers, intLoop, lAssoc) lStatus = LL_AssocGetInteger(lAssoc, "NodeID", intNodeID) lStatus = LL_AssocGetString(lAssoc, "NodeName", buf, 255, siz) intLoop = intLoop + 1 Loop Dim vSelectlist As Long ' //Define value objects lStatus = LL_ValueAlloc(vSelectlist) lStatus = LL_ValueSetList(vSelectlist) ' //Set up the list of fields for ApplyQuery to return lStatus = LL_ValueSetLength(vSelectlist, 4) ' //Note: OTObject must be in this list for ApplyQuery to work lStatus = LL_ListSetString(vSelectlist, 0, "OTDataID") '//The objects ID lStatus = LL_ListSetString(vSelectlist, 1, "OTName") ' //Object Name lStatus = LL_ListSetString(vSelectlist, 2, "OTObject") lStatus = LL_ListSetString(vSelectlist, 3, "OTOwnerID") '//The objects VolumeID Dim Where As String ' same entry enteres in the search criteria Where = "(OTName : "abc123.doc")" Dim queryResults As Long lStatus = LL_ValueAlloc(queryResults) Do ' search Livelink lStatus = LL_ApplyQuery(lSession, intNodeID, vSelectlist, Where, 0, "", 0, 10000, "LivelinkQueryLanguage", queryResults) Dim intNumberofReturns As Long ' the number of documents returned lStatus = LL_ValueGetLength(queryResults, intNumberofReturns) For intLoop = 0 To intNumberofReturns - 1 DoEvents lStatus = LL_ListGetValue(queryResults, intLoop, lAssoc) Dim DocumentID As String ' get the document ID lStatus = LL_AssocGetString(lAssoc, "OTDataID", buf, 255, siz) DocumentID = Val(Left(buf, siz)) Dim DocumentName As String ' get the document name lStatus = LL_AssocGetString(lAssoc, "OTName", buf, 255, siz) DocumentName = Left(buf, siz) msgbox DocumentID & " " & DocumentName