Chris
04/14/2025, 9:38 AMCeligo AI
04/14/2025, 9:38 AMAI generated answer (using internal Slack threads):The filter
['id','anyof','%a.id']
is not correct to search any id that have a.id
at the end. The 'anyof' operator in NetSuite is used to compare a field with any value in a list of specified values. It is typically used with select or multiselect fields.
In your case, you are trying to search for a pattern in a string, which is not what 'anyof' is designed for. The 'anyof' operator will not interpret '%a.id' as a wildcard pattern. Instead, it will look for an exact match with the string '%a.id'.
If you want to search for ids that end with 'a.id', you would need to use a different approach. Unfortunately, NetSuite does not support wildcard or regex searches directly in saved search filters. You would need to retrieve the data first and then filter it in your script.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
04/14/2025, 9:39 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819211245
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.811409235
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.803656936
Celigo AI
04/14/2025, 9:39 AM