Support of SELECT EXISTS (subquery) in preConditions

General Discussion
1

I want to write a preCondition with an sqlCheck and the SQL looks like SELECT EXISTS (subquery)
This returns a boolean from the database, but I can’t figure out what expectedResult=“???” should be. I’ve tried “1” or “0”, “t” or “f”, “true” or “false” against a PostgreSQL instance but that didn’t help. So, is it possible to do something like this?

2

Can you just convert the query to a count(*) so it returns an integer? Might be easier.

3

Hello, thank you for chiming in. I am aware of COUNT(*) but for many reasons like performance many of times the correct thing to do is EXISTS.