Salesforce Reports and Dashboards REST API Developer Guide

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
Overview
Examples
Reference
Analytics Download
Analytics Notifications
Dashboards
Filter Operators
Filter Operator List
Folders
Reports
Report Types
PDF

Filter Operator List

Return a list of filter operators.

Syntax

URI
/services/data/vXX.X/analytics/filteroperators
Formats
JSON
HTTP methods
Method Description
GET Returns a list of filter operators.
Parameters
Parameter Description
forDashboards Optional. When forDashboards equals true, returns filter operators for dashboard filters. Otherwise, the GET response always returns filter operators for report filters.

GET Response Body

Returns an array of field data types. Each object contains the following fields:

Property Type Description
label String The end user-facing name of the operator.
name String The API name of the operator.

Example GET Reponse Body

{
  "date" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  } ],
  "string" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  }, {
    "label" : "contains",
    "name" : "contains"
  }, {
    "label" : "does not contain",
    "name" : "notContain"
  }, {
    "label" : "starts with",
    "name" : "startsWith"
  } ],
  "double" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  } ],
  "picklist" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  }, {
    "label" : "contains",
    "name" : "contains"
  }, {
    "label" : "does not contain",
    "name" : "notContain"
  }, {
    "label" : "starts with",
    "name" : "startsWith"
  } ],
  "textarea" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  }, {
    "label" : "contains",
    "name" : "contains"
  }, {
    "label" : "does not contain",
    "name" : "notContain"
  }, {
    "label" : "starts with",
    "name" : "startsWith"
  } ],
  "percent" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  } ],
  "url" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  }, {
    "label" : "contains",
    "name" : "contains"
  }, {
    "label" : "does not contain",
    "name" : "notContain"
  }, {
    "label" : "starts with",
    "name" : "startsWith"
  } ],
  "int" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  } ],
  "reference" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  } ],
  "datetime" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  } ],
  "boolean" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  } ],
  "phone" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  }, {
    "label" : "contains",
    "name" : "contains"
  }, {
    "label" : "does not contain",
    "name" : "notContain"
  }, {
    "label" : "starts with",
    "name" : "startsWith"
  } ],
  "currency" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  } ],
  "id" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "starts with",
    "name" : "startsWith"
  } ],
  "email" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "less than",
    "name" : "lessThan"
  }, {
    "label" : "greater than",
    "name" : "greaterThan"
  }, {
    "label" : "less or equal",
    "name" : "lessOrEqual"
  }, {
    "label" : "greater or equal",
    "name" : "greaterOrEqual"
  }, {
    "label" : "contains",
    "name" : "contains"
  }, {
    "label" : "does not contain",
    "name" : "notContain"
  }, {
    "label" : "starts with",
    "name" : "startsWith"
  } ],
  "multipicklist" : [ {
    "label" : "equals",
    "name" : "equals"
  }, {
    "label" : "not equal to",
    "name" : "notEqual"
  }, {
    "label" : "includes",
    "name" : "includes"
  }, {
    "label" : "excludes",
    "name" : "excludes"
  } ]
}