Clarity

I am running a query against CMN_NSQL_QUERIES to search for certain values in the NSQL_TEXT field. This is the one that contains the query. I get results back but there is no field to tell me what the query name or id is. 

I read some other posts that had a join to cmn_gg_nsql_queries but that brings back results when the nsql is part of a query rather than a lookup. 

Does anybody know how to get the lookup name or id in my results?

Hi Colum

To check Lookup NSQL Code:

select a.id
,a.name
,a.lookup_type
,q.nsql_text
from cmn_lookup_types_v a
left join cmn_list_of_values b on a.lookup_type = b.lookup_type_code
left join cmn_nsql_queries q on q.id=b.sql_text_id
where a.language_code = 'en'
and b.lookup_source_code='LOOKUP_SOURCE_DYNAMIC'

I blog post I wrote may be of interest to you: Locating the portlet or lookup behind problematic NSQL

Thanks all. That is exactly what I was looking for.