Does anyone know what criteria is needed to filter a Transaction query by Status? I am trying to get all Unapproved Sales Orders, but the following returns no results (the

status = 'A'

filter is not matching any records, even though there are about hundred Sales Orders with that status)