How to check if column in table are true and return a value if all are true

Wappler General How To
#1

I have a table with “checklist” fields. I’d like to be able to query the table and return “yes” or “no” if all fields are equal to a certain value. How is the best way to do this?

Thanks for your help!
Cynthia

#2

It would be good to know your table structure. Are your checklist fields Boolean values or are you storing (yes/no) as a string?

#3

The fields are strings (none, partial, or complete). I would like to set up a query that sets a parameter, say “close”, set equal to 1 or 0 or Y/N, when ALL the fields contain “complete”.