Do anyone has any idea, what is the table name, where I can get full NSQL text for dynamic lookup? like their is a table "CMN_NSQL_QUERIES" containing full text of each NSQL query.
The queries for dynamic lookups are also in CMN_NSQL_QUERIES
Table cmn_list_of_values has column sql_text_id which get joined with CMN_NSQL_QUERIES
SELECT clt.lookup_type "Lookup ID",CASE clt.is_active WHEN 1 THEN 'Yes' ELSE 'No' End "Active",cnq.created_date "Created Date",sr.full_name "Created By",cnq.nsql_text "Query NSQL"FROMcmn_list_of_values clov, cmn_lookup_types clt, cmn_nsql_queries cnq, srm_resources srWHERE clt.lookup_type=clov.lookup_type_codeand cnq.id=clov.sql_text_idand sr.user_id=cnq.created_by
The last field in the above SQL (aka cnq.nsql_text ) will contain the NSQL.
Thanks all for answering