SQL Queries - CAST Knowledge Base - Queries on objects - How to get object details of an Enlighten view

The page explains how to get the object details which are saved in enlighten view.

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

The above query is applicable on database CSS/Oracle/SQL Server.