Hi Jen,

It sounds like you expect all vials to be not requestable. (Note available and requestable are different. Vials could be available but because of a requestability rule, not requestable).
What I would suggest to help figure this out is, first, remove the other requestability rules to make sure they are not playing a role. (In 13.2 you can even remove the Locked In Request check, BTW.) All requests should be visible in the Specimen Requests page, even those that are in a final state, but any existing request would only make a vial not requestable.

If you still think it's something with your custom query, run the query independently (from the schema browser) to see the results (whether those 6 are included or not). Perhaps you can debug your query that way.

Thanks.

Dave