Quick filter isn't working for reference field

[Jay Harter]

• 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?

[Manon Soubies-Camy]

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

[Jay Harter]

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!