This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Dumb question I’m sure, but if I have a filter on a saved search that is for a text field, how do I get the filter to behave as a `contains` rather than a `starts with` filter?  E.g. I have a filter on my Sent Email search for the subject, but it won’t match a keyword unless the subject STARTS with that word.

I may have just answered my own question, seems if I add a Criteria for Subject and set it to `contains` and put the value as ' ' it works.  That’s …. dumb.  Why would anyone want default to be `starts with`?

stats with is incredibly more performant than contains, you just look at the first char and exclude a bunch of results.. for contains you have to go through the whole text :slightly_smiling_face: so its a sane default in that regard

<@U4TPAFXEC> Assuming you're talking about a filter added on the `Available Filters` tab, there's also a dropdown on that tab for `Default Text Field Filter` that you can switch to `contains` (has to be done on each search though as far as I'm aware).

ahhhh I didn’t that as it’s technically a “view”, I had to go into More Options.  Thanks.