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.