SunShine
02/06/2025, 6:25 PMCeligo AI
02/06/2025, 6:25 PMAI generated answer (using internal Slack threads):To create a search which filters customers from id, from date, to date using SuiteScript, you can use the
SEARCH.createFilter
method to create filters for your search. Here is a sample code snippet:
javascript
var filters = []
filters.push(SEARCH.createFilter({ name: 'internalid', operator: 'IS', values: [id] }));
filters.push(SEARCH.createFilter({ name: 'datecreated', operator: 'AFTER', values: [fromDate] }));
filters.push(SEARCH.createFilter({ name: 'datecreated', operator: 'BEFORE', values: [toDate] }));
var customerSearch = SEARCH.create({
type: SEARCH.Type.CUSTOMER,
columns: ['internalid', 'datecreated'],
filters: filters
});
var searchResult = customerSearch.run();
In this code:
- SEARCH.createFilter
is used to create filters for the search. The name
parameter is the field name, the operator
parameter is the search operator, and the values
parameter is the value to filter by.
- SEARCH.create
is used to create the search. The type
parameter is the record type to search, the columns
parameter is an array of column names to return in the search results, and the filters
parameter is an array of filters for the search.
- customerSearch.run()
is used to run the search and return the results.
Please replace id
, fromDate
, and toDate
with your actual values.
******
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
02/06/2025, 6:25 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827302
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821563125
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820710182
Celigo AI
02/06/2025, 6:25 PM