SOLVED

Smart List Field Contains Whole Word?

Go to solution
Highlighted
Level 2

Smart List Field Contains Whole Word?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Level 10 - Community Moderator

Re: Smart List Field Contains Whole Word?

1 REPLY 1
Highlighted
Level 10 - Community Moderator

Re: Smart List Field Contains Whole Word?