Anyone tried doing a saved search on a support cal...
# suitescript
a
Anyone tried doing a saved search on a support call(support case) with a filter criteria being the company(customer's internal id)? I looked at records catalog and it really has a company field but I cant have company in the filter criteria, it does but it's options are 'has keywords', 'starts with' 'contains' etc. Instead of anyof. I also tried doing suitescripts to do a search using n/search module, and searching support calls with a specific customerId and it doesn't seem to work? Even though the customerId I specified have lots of support calls. Thanks for the help
j
You mentioned "saved search" but said you looked in the records catalog. Are you attempting to use the N/query module or the N/search module? If you are using the N/query module, I've successfully used both the EQUAL and ANY_OF operators to filter company. Here's a condition that I used successfully in a query: const fourthCondition = myLoadedQuery.createCondition({ fieldId: 'company', operator: query.Operator.ANY_OF, values: [129,79] }); I was also able to fetch for a single customer using the EQUAL operator. If you truly are just trying to create a saved search in the UI, to use the Any Of operator you need to filter on the Internal ID under Company Fields.