I’m hoping someone can help me understand the ‘status’ field on an Invoice I’m trying to filter on in N/query If I run the following query

SELECT type, status, 
CASE WHEN status = 'A' THEN 'yes' ELSE 'no' END
FROM transaction WHERE id = 278635

I get my expected result: type: CustInvc status: A status_is_a: yes however if I do the following, I get no results

SELECT type, status, 
CASE WHEN status = 'A' THEN 'yes' ELSE 'no' END AS status_is_a
FROM transaction WHERE id = 278635 AND status = 'A'

What’s going on here?