Quick filter isn't working for reference field

Question

* I'm using the 'reference' field to capture a category of data - a schedule name (ie. RC-N, RC-A, HC-N)
* I'd like to create a quick filter for particular schedules
* I've created a quick filter for RC-A as follows: reference ~ "RC-A"* I wasn't able to use "=" I guess because of the field type

* When I click on the quick filter, I receive RC-A but also many other schedules (like RC-N, HC-N, etc).
* Help! Am I doing it wrong?

Jay Harter · Answer

Your doc helped! I went to the next level in and (contains) found this syntax worked to get the exact match: reference ~ "\"RC-A\""

Not very intuitive - but it'll work!

Manon Soubies-Camy · Answer

Hello Jay,

The tilde is for approximative search (see doc), that's why you get all values similar to RC-A. Which custom field type is Reference?

- Manon