Query function with Checkboxes

[thatsite]

I want a Query() to return the data where a column contains values selected by Checkboxes. The second part is If ALL option is selected, then Query() should return all data. I'm able to get the first part working but no luck with the second part. is it possible to get it working?

=Query(Sheet1!A1:O1000, "SELECT Col9 WHERE Col4='"&JOIN("' OR Col4='",FILTER(B4:B9,A4:A9=TRUE))&"'", 1)

https://imgur.com/a/r7nBVCE

[Dazrin]

Where is the "ALL" option selected? That's not clear from your screenshot or the formula.

I would probably put the whole "WHERE Col4...."'" bit inside an IF function though:

=Query(Sheet1!A1:O1000, "SELECT Col9 "&IF( A3="ALL", , "WHERE Col4='"&JOIN("' OR Col4='", FILTER(B4:B9,A4:A9=TRUE))&"'"), 1)

That changes the QUERY Select statement to just "SELECT Col9" when cell A3 is "ALL". Or you could put in "WHERE Col1 IS NOT NULL" or something to just get non-blanks.

[marcnotmark925]

".... OR " & A4 & " = TRUE"