Purpose of Query
This page provides queries to get the object GUID as per object name or object id
Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (tick)
Microsoft SQL Server (tick)
CSS2 (tick)
Query for CSS, Oracle, SQL Server
  1. To search by object name, use the following query by replacing <object name>

    SELECT k.IdKey ,
           k.KeyNam,
           o.IdNam AS GUID
    FROM   Objects o
           JOIN Keys k
           ON     k.IdKey     = o.IdKey
           AND    k.KeyNam LIKE '%<object name>%'
  2. To search by object id, use the following query by replacing <object id>

    SELECT k.IdKey ,
           k.KeyNam,
           o.IdNam AS GUID
    FROM   Objects o
           JOIN Keys k
           ON     k.IdKey     = o.IdKey
           AND    k.IdKey = '%<object id>%'

 

Query result example

methCS_Net?y:\dotnet\project_name\object_name\controls?aspWS_Net?object_name?nmsp_Net?Controls?nmsp_Net?object_name?nmsp_Net?RestaurantListControls?nmsp_Net?MarketCuisinesSet?clsCS_Net?GetCuisineAreaAndPriceText(cls_Net?c:\windows\microsoft.net\framework64\v2.0.50727\mscorlib.dll?asm_Net?System?nmsp_Net?String,out cls_Net?c:\windows\microsoft.net\framework64\v2.0.50727\mscorlib.dll?asm_Net?System?nmsp_Net?String,out cls_Net?c:\windows\microsoft.net\framework64\v2.0.50727\mscorlib.dll?asm_Net?System?nmsp_Net?String)

methCS_Net?y:\dotnet\project_name\object_name\object_name.csproj?proj_Net?object_name?nmsp_Net?Controls?nmsp_Net?object_name?nmsp_Net?RestaurantListControls?nmsp_Net?MarketCuisinesSet?clsCS_Net?GetCuisineAreaAndPriceText(cls_Net?c:\windows\microsoft.net\framework64\v2.0.50727\mscorlib.dll?asm_Net?System?nmsp_Net?String,out cls_Net?c:\windows\microsoft.net\framework64\v2.0.50727\mscorlib.dll?asm_Net?System?nmsp_Net?String,out cls_Net?c:\windows\microsoft.net\framework64\v2.0.50727\mscorlib.dll?asm_Net?System?nmsp_Net?String)

Query result interpretation

The above GUID is the object ID selected while running the query.

Notes/comments
 
Related Pages