Page tree
Skip to end of metadata
Go to start of metadata
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
 
  • No labels