IN operator still not working in 7.9.5

[William Faulk]

The article here states that in 7.8 the IN operator does not work. I'm on 7.9.5 and it still doesn't seem to.

https://support.tibco.com/s/article/TIBCO-Scribe-Insight-IN-Operator-Ignores-Or-Concatenates-Values

Any workaround or other ways to try this A sql statement to look up the key to use for the lookup instead of using the other lookup criteria which includes,excludes only certain values Multiple results may be returned without IN or NOT IN criteria.

Thanks!