SQL Queries - CAST Knowledge Base - Queries on objects - How to get object details of an Enlighten view
Purpose
The page explains how to get the object details which are saved in enlighten view.
Applicable in CAST Version
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
| 8.2.x | ✅ |
| 8.1.x | ✅ |
| 8.0.x | ✅ |
| 7.3.x | ✅ |
| 7.2.x | ✅ |
| 7.0.x | ✅ |
Details
During Enlighten validation, If we are saving some object with views, the below query will help to get the saved object list/details-
SELECT *
FROM keys k,
modkey mk
WHERE k.idkey = mk.idkey
Query result example
Query result interpretation
The query output is the combination of data from the Keys table and the Enlighten saved data from modKey table.
Notes / Comments
The above query is applicable on database CSS/Oracle/SQL Server.
Related Pages