google sheets query = true

Question

i'm trying to do a query of baseball play-by-play scoring descriptions. I'm able to get the data of specific columns, but can't filter "isScoringPlay" = true. It's coming up blank in my query. My formula should be:

=QUERY(filteredplaybyplay, "SELECT B, C, D, E, G, H WHERE H = 'true'",1)

Here's my range and then the query

Answer 1

try shorter:

=QUERY(playbyplay, "select B,C,D,E,G,H where H is null", 1)

or proper:

=ARRAYFORMULA(QUERY(""&playbyplay, 
 "select Col2,Col3,Col4,Col5,Col7,Col8 where Col8 = 'true'", 1))