This document provides a query to get the ID of an object from its name, and a query to get the ID of an object from its full-name.



Release
Yes/No
8.3.x (tick) 
8.2.x (tick) 




RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (tick) 
CSS (tick) 




--  From its name
SELECT IDKEY
FROM         KEYS
WHERE  KEYNAM = '<OBJECT_NAME>'
 
-- From its full-name
SELECT IDOBJ
FROM               OBJFULNAM
WHERE  FULLNAME = '<OBJECT_FULL_NAME>'


1146643


 The ID of the object in Knowledge Base us 1146643




--  From its name
SELECT IDKEY
FROM         KEYS
WHERE  KEYNAM = '<OBJECT_NAME>'


-- From its full-name
SELECT IDOBJ
FROM               OBJFULNAM
WHERE  FULLNAME = '<OBJECT_FULL_NAME>'


1146643


  The ID of the object in Knowledge Base us 1146643




--  From its name
SELECT IDKEY
FROM         KEYS
WHERE  KEYNAM = '<OBJECT_NAME>'


-- From its full-name
SELECT IDOBJ
FROM               OBJFULNAM
WHERE  FULLNAME = '<OBJECT_FULL_NAME>'


1146643


 The ID of the object in Knowledge Base us 1146643