Reports that query labels of keys

Hi All - i think i have logic-ed myself into a swirl and might be confusing super basic concepts…

I am trying to make a PDF report that queries the label of a key.

Table 1:
Key: Item_ID
Label: Item_name (examples: Internal, External, Inside, Outside)

Table 2:
Key: Event_ID
Label: Event_Name
Items: Item_ID (enumlist reference)

I want to run a report on Table 2, but limit the output where the label of Table 1 contains Internal .

Anyone have any guides that could help?


You can do a de-reference inside of a SELECT/FILTER.

Something like :

<<START: FILTER( Table , [ref-col].[label] = "X" )>>
1 Like