Purpose of Query
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.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS | |
Query for CSS
-- From its name SELECT IDKEY FROM KEYS WHERE KEYNAM = '<OBJECT_NAME>' -- From its full-name SELECT IDOBJ FROM OBJFULNAM WHERE FULLNAME = '<OBJECT_FULL_NAME>'
Query result example
1146643
Query result interpretation
The ID of the object in Knowledge Base us 1146643
Query for Oracle
-- From its name SELECT IDKEY FROM KEYS WHERE KEYNAM = '<OBJECT_NAME>' -- From its full-name SELECT IDOBJ FROM OBJFULNAM WHERE FULLNAME = '<OBJECT_FULL_NAME>'
Query result example
1146643
Query result interpretation
The ID of the object in Knowledge Base us 1146643
Query for SQL server
-- From its name SELECT IDKEY FROM KEYS WHERE KEYNAM = '<OBJECT_NAME>' -- From its full-name SELECT IDOBJ FROM OBJFULNAM WHERE FULLNAME = '<OBJECT_FULL_NAME>'
Query result example
1146643
Query result interpretation
The ID of the object in Knowledge Base us 1146643
Notes/comments
Related Pages