Get all filter helpers

GET {{baseUrl}}/filters/helpers

Returns all supported filter helpers. It helps to know what conditions and helpers are available when you want to add or update filters. For more information, see the tutorial for adding a filter.

HEADERS

RESPONSES

status: OK

{"success":true,"data":{"operators":{"int":{"=":"is","!=":"is not","\u003e":"is more than","\u003c":"is less than","\u003e=":"is more or equal to","\u003c=":"is less or equal to","IS NULL":"is empty","IS NOT NULL":"is not empty"},"double":{"=":"is","!=":"is not","\u003e":"is more than","\u003c":"is less than","\u003e=":"is more or equal to","\u003c=":"is less or equal to","IS NULL":"is empty","IS NOT NULL":"is not empty"},"monetary":{"=":"is","!=":"is not","\u003e":"is more than","\u003c":"is less than","\u003e=":"is more or equal to","\u003c=":"is less or equal to","IS NULL":"is empty","IS NOT NULL":"is not empty"},"time":{"=":"is","!=":"is not","\u003c":"is before","\u003e":"is after","\u003e=":"is exactly or after than","\u003c=":"is exactly or before than","IS NULL":"is empty","IS NOT NULL":"is not empty"},"date":{"=":"is","!=":"is not","\u003e":"is later than","\u003c":"is earlier than","\u003e=":"is exactly or later than","\u003c=":"is exactly or earlier than","IS NULL":"is empty","IS NOT NULL":"is not empty"},"entered_stage":{"=":"is","!=":"is not","\u003e":"is later than","\u003c":"is earlier than","\u003e=":"is exactly or later than","\u003c=":"is exactly or earlier than"},"timerange":{"=":"starts at","!=":"does not start at","ends_at":"ends at","does_not_end_at":"does not end at","\u003c":"starts before","\u003c=":"starts exactly on or before","ends_before":"ends before","ends_e_before":"ends exactly on or before","\u003e":"starts after","ends_after":"ends after","\u003e=":"starts exactly or after","ends_e_after":"ends exactly or after","includes":"does include","IS NULL":"is empty","IS NOT NULL":"is not empty"},"daterange":{"=":"starts at","!=":"does not start at","ends_at":"ends at","does_not_end_at":"does not end at","\u003c":"starts before","\u003c=":"starts exactly on or before","ends_before":"ends before","ends_e_before":"ends exactly on or before","\u003e":"starts after","ends_after":"ends after","\u003e=":"starts exactly or after","ends_e_after":"ends exactly or after","includes":"does include","IS NULL":"is empty","IS NOT NULL":"is not empty"},"varchar":{"=":"is","!=":"is not","IS NULL":"is empty","IS NOT NULL":"is not empty","LIKE '%$%'":"contains","LIKE '$%'":"starts with","NOT LIKE '$%'":"does not start with"},"stage":{"=":"is","!=":"is not","has_been":"has been"},"title":{"=":"is","LIKE '$%'":"starts with","LIKE '%$%'":"contains","NOT LIKE '$%'":"does not start with"},"set":{"=":"is","!=":"is not","contains":"contains","not_contains":"does not contain","IS NULL":"is empty","IS NOT NULL":"is not empty"},"enum":[{"=":"is"},{"!=":"is not"},{"IS NULL":"is empty"},{"IS NOT NULL":"is not empty"}],"deal":{"=":"is","!=":"is not","IS NULL":"is empty","IS NOT NULL":"is not empty"},"product":{"=":"is","!=":"is not","IS NULL":"is empty","IS NOT NULL":"is not empty"},"user":{"=":"is","!=":"is not","IS NULL":"is empty","IS NOT NULL":"is not empty","belongs_to_team":"belongs to team"},"status":{"=":"is","!=":"is not"},"visible_to":{"=":"is","!=":"is not"},"currency":{"=":"is","!=":"is not"},"pipeline":{"=":"is","!=":"is not"},"person":{"=":"is","!=":"is not","IS NULL":"is empty","IS NOT NULL":"is not empty"},"organization":{"=":"is","!=":"is not","IS NULL":"is empty","IS NOT NULL":"is not empty"}},"deprecated_operators":{"NOT LIKE '%$%'":"does not contain","LIKE '%$'":"ends with","NOT LIKE '%$'":"does not end with"},"relative_dates":{"Relative date intervals":{"last_quarter":"last quarter","this_quarter":"this quarter","last_month":"last month","this_month":"this month","last_week":"last week","this_week":"this week","next_week":"next week","next_month":"next month"},"Relative dates":{"6_months_ago":"6 months ago","5_months_ago":"5 months ago","4_months_ago":"4 months ago","3_months_ago":"3 months ago","2_months_ago":"2 months ago","1_months_ago":"1 month ago","3_weeks_ago":"3 weeks ago","2_weeks_ago":"2 weeks ago","1_week_ago":"1 week ago","yesterday":"yesterday","before_today":"before today","today":"today","now":"now","later_or_today":"today or later","before_tomorrow":"before tomorrow","tomorrow":"tomorrow","later_or_tomorrow":"tomorrow or later","in_1_week":"in 1 week","in_2_weeks":"in 2 weeks","in_3_weeks":"in 3 weeks","in_1_month":"in 1 month","in_2_months":"in 2 months","in_3_months":"in 3 months","in_4_months":"in 4 months","in_5_months":"in 5 months","in_6_months":"in 6 months"},"Deal specific":{"rotten_time":"Rotten time"}},"address_field_components":{"subpremise":"Apartment/suite no","street_number":"House number","route":"Street/road name","sublocality":"District/sublocality","locality":"City/town/village/locality","admin_area_level_1":"State/county","admin_area_level_2":"Region","country":"Country","postal_code":"ZIP/Postal code","formatted_address":"Full/combined address"}}}