Complex Filter Question

Server-Side Scripting
1

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?

2

Doah! I figured it out. It was that damn pesky variable case sensitivity.:wink:

1 Like