Right, so what I think is suggested is to paste it all as text straight into a formula, something like:

CASE WHEN {value} IN (123, 456, 789) THEN 1 ELSE 0 END

@scottvonduhn What's the syntax for a list? If that doesn't work, the other option is one CASE WHEN per search target

https://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions013.htm Basically, the keyword IN following by comma separated values in parentheses:

IN ('A', 'B', 'C')

or

IN (1, 2, 3)

Thanks

if you add a formula column in the results for

{transaction.classnohierarchy}

does it show the values exactly like this?

It was too much work to do this massive set of extracts with saved searches so I switched to ODBC

Yeah, the schema differences are not ideal, but with lots of data, the speed of ODBC / JDBC is simply unbeatable. I have found no other method that can easily extract as much data, or do it as efficiently.