If you created the confirmed field after adding entities to your content-type, then the confirmed value may not exist(mongo) or may be empty(sql), even if you selected default value true. As the default value doesn’t modify the existing data in db. So if you search for confirmed=true it will not find any results.
Can you check directly in mongodb what values you have for some entities at confirmed field?