dynamic filter to replace the whole filter expression (batch macro)

[DannisMen]

Hi all, 

i wonder how i can use a text box to replace the whole expression in filter. basically, i can do however i want with the text input and just update the whole expression in filter tool. 

[BrandonB · Accepted solution]

If you have your filter set to "Custom Filter", it allows for you to update the entire expression in the action tool

 

[DannisMen]

Hi, 

it's weird that i did exactly the same as you suggested. but the output was the same regardless what i had in text box. can you plz share your sample?

[BrandonB]

My guess is that you aren't seeing it do anything because you need to render out something from an analytic app to see the results entered from the interface. You can see in the example below that my formula says [Field1] = 1 but when I enter [Field1] = 2 into the text box and run the workflow, it renders the output where the filter is now filtering for the value of 2. 

 

[DannisMen]

it works. just a typo thing. thanks

[Inactive User]

Hi @BrandonB ,

will it work when we use another input with different column names ?