Purpose of Query
This page contains a query to be run on Knowledge Database which will help us find if the object property is internal/external/generated. Below is the table showing the object property for
| property | value |
|---|---|
| Internal | 0 |
| External | 1 |
| Generated (artificial) | 2 |
| External Generated (artificial) | 3 |
| Unknown | otherwise |
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS | |
Query for CSS, Oracle, SQL Server
For CAST 8.3.36 and lower:
SELECT cfo.object_fullname,
CASE
WHEN coa.properties = 0 THEN 'Internal'
WHEN coa.properties = 1 THEN 'External'
WHEN coa.properties = 2 THEN 'Generated (artificial)'
ELSE 'Unknown'
END
FROM ctt_object_applications coa
JOIN csv_file_objects cfo
ON cfo.object_id = coa.object_id
AND cfo.object_fullname IN (<'object_fullname1'>,
<'object_fullname2'>,
....,
<'object_fullnameN'>)
For CAST 8.3.37 and higher:
SELECT cfo.object_fullname,
CASE
WHEN coa.properties & 255 = 0 THEN 'Internal'
WHEN coa.properties & 255 = 1 THEN 'External'
WHEN coa.properties & 255 = 2 THEN 'Generated (artificial)'
WHEN coa.properties & 255 = 3 THEN 'External Generated (artificial)'
ELSE 'Unknown'
END
FROM ctt_object_applications coa
JOIN csv_file_objects cfo
ON cfo.object_id = coa.object_id
AND cfo.object_fullname IN (<'object_fullname1'>,
<'object_fullname2'>,
....,
<'object_fullnameN'>)
Query result example
"java.lang.String";"External"
"<Default Package>.SelectQueries.myMethod";"Internal"
"<Default Package>.SelectQueries.SelectQueries";"Generated (artificial)"
Query result interpretation
java.lang.String is External
Default Package>.SelectQueries.myMethod is Internal<Default Package>.SelectQueries.SelectQueries is Generated
Notes/comments
Related Pages