A dynamic saved search broke because it has 1,001 ...
# general
e
A dynamic saved search broke because it has 1,001 elements (entity) in a
Any Of
filter. If I remove one element in the
Any Of
selector, the Saved Search runs fine. Is this documented?
Seems to be related, but not exactly the same
Selecting Available Filters for Saved Searches
The maximum number of items contained in a field that can be displayed in a dropdown list is 10,000. If the field is an Entity, the maximum number of items is 1,000. If the field contains more items than the maximum number, the filter appears as an empty field.
https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N678025.html#Selecting-Available-Filters-for-Saved-Searches
🎯 1
r
I am not 100% sure on it, but can you put 2 entity filters of entity, split 500 entities each And put an or condition between them. And see if that works.
a
@Edgar Valdes this doesn't seem like a good design anyway. If you need over 1000+ entities to be included in some search, I would add a checkbox on the entity for whatever this is. Check the box on the 1001 entities and then add this checkbox as a criteria.
this 1
e
@AK47 It flew under the radar as part as an old script until now, when the number of
entity
elements passed that threshold. I'm trying to see if the filter is necessary at all, if another criteria can be used, etc. As part of my documentation process, I need to pinpoint the official docs (if any) where the limit is set.
a
• The maximum number of items contained in a field that can be displayed in a dropdown list is 10,000. If the field is an Entity, the maximum number of items is 1,000. If the field contains more items than the maximum number, the filter appears as an empty field.
definitely seems to be a limit of 1000
but I would never allow something to get near that number without being redesigned
e
Yep, same link I posted earlier
Thanks!