> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Using filters

> Using ODATA filters

## Filter operators

**ints:** eq =, ne, le, lt, gt, ge, set, equals, greater, less, unequals, between

**strings:** contains, is, notBegins, notContains, isNot, in

**associate:** associateIsOneOf, associateIsNotOneOf,

**list IDs:** oneOf, NotOneOf,

**dates:** before, date, after, dateBetween, beforeToday

**Unary ops:** currentAssociate, beforeToday, today, afterToday, lastWeek, thisWeek, nextWeek, lastMonth, thisMonth, nextMonth, lastQuarter, thisQuarter, nextQuarter, thisHalf, thisYear

**Functions:** substringof(a,b), startswith(a,b), endswith(a,b)

## Example: get all companies with category 3

```http theme={null}
GET /api/v1/Contact?$select=name,category,number&$filter=category oneOf (3)
```

```json theme={null}
{
  value = [
    {
      "PrimaryKey": "25",
      "EntityName": "contact",
      "name": "Lena Trevare AS",
      "category": "Leverandør",
      "number": "10033"
    }, {
      "PrimaryKey": "26",
      "EntityName": "contact",
      "name": "Liumseter Hyttegrend",
      "category": "Leverandør",
      "number": "10034"
    }, {
      "PrimaryKey": "27",
      "EntityName": "contact",
      "name": "Mosjøen Boligbyggerlag AS",
      "category": "Leverandør",
      "number": "10035"
    }
  ]
}
```

## Full mode

Full mode returns raw values and display values separately.

```http theme={null}
GET /api/v1/Contact?$select=name,category,number&$filter=category%20oneOf%20(3)&$mode=FULL
```

Returns more information about each data point.

```json theme={null}
{
  value = [
    {
      "PrimaryKey": 25,
      "EntityName": "contact",
      "StyleHint": "",
      "LinkHint": "nav=contact&contact_id=25",
      "TableRight": {
        "Mask": 1,
        "Reason": "[SR_ACTIVITY_BLOCKED_FIND]"
      },
      "Column": {
        "name": {
          "RawValue": "Lena Trevare AS",
          "DisplayValue": "Lena Trevare AS",
          "LinkHint": "",
          "TooltipHint": "{contact_id=25}"
        },
        "category": {
          "RawValue": 3,
          "DisplayValue": "US:\"Vendor\";NO:\"Leverandør\";",
          "LinkHint": "",
          "TooltipHint": "{category_id=3}"
        },
        "number": {
          "RawValue": "10033",
          "DisplayValue": "10033",
          "LinkHint": "",
          "TooltipHint": "{contact_id=25}"
        }
      }
    },
    {
      "PrimaryKey": 26,
      "EntityName": "contact",
      "StyleHint": "",
      "LinkHint": "nav=contact&contact_id=26",
      "TableRight": {
        "Mask": 1,
        "Reason": "[SR_ACTIVITY_BLOCKED_FIND]"
      },
      "Column": {
        "name": {
          "RawValue": "Liumseter Hyttegrend",
          "DisplayValue": "Liumseter Hyttegrend",
          "LinkHint": "",
          "TooltipHint": "{contact_id=26}"
        },
        "category": {
          "RawValue": 3,
          "DisplayValue": "US:\"Vendor\";NO:\"Leverandør\";",
          "LinkHint": "",
          "TooltipHint": "{category_id=3}"
        },
        "number": {
          "RawValue": "10034",
          "DisplayValue": "10034",
          "LinkHint": "",
          "TooltipHint": "{contact_id=26}"
        }
      }
    },
    {
      "PrimaryKey": 27,
      "EntityName": "contact",
      "StyleHint": "",
      "LinkHint": "nav=contact&contact_id=27",
      "TableRight": {
        "Mask": 1,
        "Reason": "[SR_ACTIVITY_BLOCKED_FIND]"
      },
      "Column": {
        "name": {
          "RawValue": "Mosjøen Boligbyggerlag AS",
          "DisplayValue": "Mosjøen Boligbyggerlag AS",
          "LinkHint": "",
          "TooltipHint": "{contact_id=27}"
        },
        "category": {
          "RawValue": 3,
          "DisplayValue": "US:\"Vendor\";NO:\"Leverandør\";",
          "LinkHint": "",
          "TooltipHint": "{category_id=3}"
        },
        "number": {
          "RawValue": "10035",
          "DisplayValue": "10035",
          "LinkHint": "",
          "TooltipHint": "{contact_id=27}"
        }
      }
    }
  ]
}
```


## Related topics

- [Filter the section tabs](/en/learn/section-tabs/filter.md)
- [REST WebAPI search](/en/api/search/odata/index.md)
- [Email filter](/en/automation/event-model/email-filter.md)
- [Using trace](/en/automation/crmscript/debugging/using-trace.md)
- [How to Search using Find Selections](/en/api/search/find-selection/how-to-search.md)
- [Using tags in requests](/en/request/learn/tags.md)