Community maintenance is complete. Thank you for your patience!

Active IQ Unified Manager Discussions

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


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.





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





NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner