The following report shows the attribute elements filtered by the substring keywords stored in other database table.
Table_1: The column contains the keywords which are part of the element of the attribute. | Table_2: Lookup table of the attribute. |
Table_2: Lookup table of the attribute. | Table_2: Lookup table of the attribute. |
The following example shows the steps to create the report above:
ApplyComparison("exists (select 'a' from Table_1 a2 where #0 like '%' + a2.key1 + '%')",Key2@ID)