WFA - How do you filter fields with search string within rows of a Table?

[ninja]

I have a workflow which sets NTFS permissions. I have a datasource which contains all the AD users and groups. 

I need to know what I can put in the sql query to filter the third column in the table for each row. My guess is the index of the field but I don't know if this is possible nor the syntax

SELECT samaccountname AS 'GroupName',addomain AS 'Domain'
FROM company_domain.domain_groups
WHERE domain_groups.samaccountname LIKE '%${SOMETHING}%'

The third column shows the AD groups in a drop down but I need it to be filtered by the first column. I know how to do this from a regular field but not within a table.

[cbauernf]

This is a frequently asked question in this forum, and unfortunately, the frequent answer is: you can't.

The SQL query inside a table does not accept variables, it has to be self contained.

See this thread this thread for a more detailed discu

Best,

Christian