Clarity

  • 1.  What is the table name storing NSQL of dynamic lookups?

    Posted Mar 25, 2019 06:52 AM

    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.



  • 2.  Re: What is the table name storing NSQL of dynamic lookups?

    Posted Mar 25, 2019 07:57 AM

    The queries for dynamic lookups are also in CMN_NSQL_QUERIES



  • 3.  Re: What is the table name storing NSQL of dynamic lookups?
    Best Answer

    Posted Mar 25, 2019 08:10 AM

    Table cmn_list_of_values has column sql_text_id which get joined with CMN_NSQL_QUERIES



  • 4.  Re: What is the table name storing NSQL of dynamic lookups?

    Posted Mar 25, 2019 11:39 PM

    I use:

    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"
    FROM
    cmn_list_of_values clov, cmn_lookup_types clt, cmn_nsql_queries cnq, srm_resources sr
    WHERE clt.lookup_type=clov.lookup_type_code
    and cnq.id=clov.sql_text_id
    and sr.user_id=cnq.created_by

     

    The last field in the above SQL (aka cnq.nsql_text ) will contain the NSQL.



  • 5.  Re: What is the table name storing NSQL of dynamic lookups?

    Posted Mar 26, 2019 03:39 AM

    Thanks all for answering