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

There is no limit on `anyof` filters. I had this confirmed with NS, they tested with a million elements without an issue

Is there a limit on Formula with huge blocks of Case statements?

I haven’t run into any issues, but I’m curious.

<@U9D2H3SBV> is there any limit if i use multiple OR operator?

Just for the information, I tried it for around 2K ids. It worked well. But for item id as text filters using 'OR' on around 1.5K ids took quite more time than normal search execution.

<@U9D2H3SBV> Netsuite confirmed this with you? They said they tested 1 million?
After hours of debugging, I found this is not true. Or at least if the `anyof` is on a joined field.

I had this filter
```... ['customer.parent', 'anyof', parentIds], 'AND', ...```
and I was breaking my head to figure out why it wasn't working. The :netsuite:  error message is just an unexpected error has occurred.

I broke the array with a length of about 1075 into 3 parts, and each one on its own worked.

I then took the first 1001 results and it failed.
I took the first 1000 results then it worked

ANYOF was restricted to 250 IDs as far as I can remember

<@U2C4P9YR3> I suppose the workaround is to just expressions and keep using OR till I add all my needed filters

&gt; Thanks for waiting. The documentation for Filter objects doesn't explicitly indicate any limitations for the elements in an AnyOf operator, so there doesn't seem to be any. To test this, created an AnyOf filter with a million element values successfully in my test account.

must have updated a while back we couldn't get any more than 250 to work...maybe they SHOULD document it :smile: