Hi,
I am trying to figure out how to create a list that shows documents that contain a specific string in a keyword field. The list would only show documents if this keyword field contains one row with this string.
For example, if the table contains only ['A'] then the document will show, but if the table contains two rows, ['A','B'] then the rule is false. I've tried using a LIKE statement with the Is (where clause) option, but it doesn't seem to work if there are multiple rows in the table. Setting the WHERE string to '%A%' also doesn't return what I'm looking for.
I think if I could figure out the syntax for a 'doesn't contain' statement then that would solve my issue as well. Although NOT LIKE seems to not work either.
Thanks!
