Skip to main content

Filtering and Sorting Usage Examples

You can apply filters to any of our index endpoints.

Get all Fuel Entries since January 1, 2016:[created_at_gteq]=2016-01-01

Get all Submitted Inspection Forms from January 1, 2016:[submitted_at_gteq]=2016-01-01&q[submitted_at_lt]=2016-01-02

Get all Meter Entries where the void flag is set to true:[void_true]=1

Get all Work Orders with status names containing the word 'priority':[work_order_status_name_cont]=priority

Get all blue Vehicles with a fuel type of Diesel, sorted by year descending:[color_eq]=blue&q[fuel_type_name_matches]=diesel&q[s]=year+desc

Want to know if the number of Freds you have working in your company is too high?[first_name_eq]=Fred

The possibilities are endless!*

*Possibilities actually finite