[Arsperl-users] Field id works but field name does not in query

[Franklin L. <ars...@le...>]

Can someone explain why this WHERE clause works

WHERE ('Assignee Login ID' LIKE "%joeuser%") AND ('7' = 1)

but this one does _not_

WHERE ('Assignee Login ID' LIKE "%joeuser%") AND ('Status' = 1)

The error it throws is

Unknown field referenced in query line (position 51   (...) AND 
('Status'^ = 1)))

I double-checked and the field name for field 7 on this table is 'Status'.