in Suitescript 1.0, I'm wanting to filter a search...
# suitescript
a
in Suitescript 1.0, I'm wanting to filter a search using the 'contains' operator on our customer divisions. I can't do that, because it's a list/record field. How can I get around this? I want to report sales by rep by state, and there could be multiple divisions per state. So the easy thing would be to say 'show me sales for rep X where customer division LIKE 'Ohio'... is that possible? Division formats are 'Ohio: Younstown', 'Ohio: Columbus', 'Kentucky: Lexington', etc. I have tried writing the script for the search (as opposed to using a saved search), and it works but it times out every time.