Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Which table stores Lookup query

  • 1.  Which table stores Lookup query

    Posted Oct 04, 2016 08:03 AM

    Hello All,
    Which table stores Lookup Query?

    Regards,

    Santosh



  • 2.  Re: Which table stores Lookup query

    Posted Oct 04, 2016 08:50 AM

    This should work.

     

    SELECT

       nsql.nsql_text

    FROM

       cmn_nsql_queries nsql,

       cmn_list_of_values val
    WHERE

       val.lookup_type_code=<provide lookup ID>
       AND val.sql_text_id=nsql.id