I have post script running that is calling a db service to retrieve a single record ID based on a sql like filter.
When I send the filter the API docs below it works fine:
(InternalRole=1) AND (Organization_Id=51) AND (Deactivated=false)
When I try the exact same filter (encoded in the query string below) in my script it return the same ID no matter what Organization_Id I enter:
fields=Id&limit=1&filter=(InternalRole%3D1)%20AND%20(Organization_Id%20%3D51)%20AND%20(Deactivated%3Dfalse)
Any ideas?