Filtering the Content By Query Web Part on a Yes/No Field
Here is a great post on something that I know I'll forget and that isn't that intuitive. When filtering on a Yes/No column, I kept trying to input the value of "True" or "Yes" for the filter value. The technique is as described in this post:
Which is to use the strictest boolean implementation of the column "1" or "0".