Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

not like '...'

not like '...'

Allows for matching text fields that do not contain a substring

Works with the following datatypes:

This function works with 2.1 endpoint(s). What does this mean? »

The like '...' function allows you to filter for Text values that do not match a given pattern. Patterns can include placeholders to make fuzzy matches:

  • An underscore (_) matches a single character
  • A percent symbol (%) matches any string of zero or more characters

For example, to query the employees at the City of Chicago who aren’t advisors (the ‘%’ characters are URL encoded as ‘%25’):

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=job_titles not like '%2525ADVISOR%2525'