AnsweredAssumed Answered

Smart List Field Contains Whole Word?

Question asked by Ashley Long on Apr 3, 2019
Latest reply on Apr 3, 2019 by Sanford Whiteman

Is there a way to limit my smart list attributes to return values that only match a whole word? For example, I'm attempting to pull job titles that contain "OT" (as seen in "Director of OT" or "OT Supervisor"), but keep returning titles like "Director of Emotional Learning" or "Motor Services Coordinator".

 

I've tried including the phrase in quotations (a la Google search), but that doesn't seem to make a difference. I also tried including a space before and after OT to try to enforce the whole word, but that space is not maintained when the list is generated. We collect a lot of data straight from customers, so there is a lot of variation and listing out all possible options for job titles is not very feasible. Any thoughts?

Outcomes