I have a main table, with many text fields that can be written to the table. I’m attempting to add a filter to the column, I am attempting to achieve this by adding a WHERE tag = {Root Container.Search.search}
The " Search" custom property is to either be null if search = empty , or to write the rest of the where string AND tag = Container.Search.text} .
Two main issues, 1.) I do not know the proper syntax to write the string, it keeps printing the {root container.Search.txt} versus, what is in the text box,
2.) Not even sure if this idea will work for a search bar.
Code of the custom property:
if({Root Container.Search.text}="","",“AND e.tag = {Root Container.Search.text}”)