Ragic Logo
<< Returned data JSON formatTable of ContentsLimiting Entry Number / Paging >>

Filter Conditions

Very often your database contain large amount of entries, so it's better to apply filters when you retrieve data. Ragic Builder API filters are in a special format

You can use the parameter "where" to add a filter condition to a query as below:

curl --get -d 'where=800003,eq,Dwight Schrute' \

-H "Authorization:Basic YOUR_API_KEY_GOES_HERE" \

-d api \

https://www.ragic.com/demo/sales/1

The parameter is a "," comma delimited format, with at least 3 arguments.

You can supply a query with multiple filter conditions as below:

curl --get -d 'where=800003,eq,Dwight Schrute' \

-d 'where=800007,eq,Reseller' \

-H "Authorization:Basic YOUR_API_KEY_GOES_HERE" \

-d api \

https://www.ragic.com/demo/sales/1

Here's the list of operands that you can use:

Operand Name Operand Value
Equals eq
Regular Expression regex
Greater or equals gte
Less or equals lte
Greater gt
Less lt
Contains like
Equals a node id eqeq

Please note that when you filter by date or date time, they will need to be in the following format: yyyy/MM/dd or yyyy/MM/dd HH:mm:ss

You can also use a full text search as a query filter. Just provide your query term in the parameter fts and the matched result will be returned.

curl --get -d 'fts=Dwight' \

-H "Authorization:Basic YOUR_API_KEY_GOES_HERE" \

-d api \

https://www.ragic.com/demo/sales/1

You can also apply Shared View. Just set the id as below.

curl --get -d 'filterId=THE_ID_OF _YOUR_SHARED_VIEW' \

-H "Authorization:Basic YOUR_API_KEY_GOES_HERE" \

-d api \

https://www.ragic.com/demo/sales/1

You could get the id by clicking the Shared View URL.

Top of Page
<< Returned data JSON formatTable of ContentsLimiting Entry Number / Paging >>
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Keep in touch:
Blog
Email
Facebook
Twitter
Ragic, Inc.
1-888-666-8037
Terms
Privacy