Hello everyone, I'm trying to get search results o...
# suitescriptl
Lukasz Formela
11/17/2020, 12:09 PMHello everyone, I'm trying to get search results of transactions limited to few types only. From what I can see search filters accept only abbreviated names like
CustInvcSalesOrdtypeb
burkybang
11/17/2020, 1:21 PMIf you're only searching for one type, then you could just set the type of the search to "invoice" or "salesorder" instead of "transaction".
l
Lukasz Formela
11/17/2020, 1:27 PMThanks, I need to search for several transaction types at once, splitting it into different searches is not an option really
b
burkybang
11/17/2020, 1:28 PMWhich version of SuiteScript are you using?
burkybang
11/17/2020, 1:33 PMYou could run a search beforehand to get the values for both record type and the filter type to use as a key/lookup.
❤️ 1
burkybang
11/17/2020, 1:37 PM Copy code
search.create({
type: search.Type.TRANSACTION,
columns: [
search.createColumn({
name: 'recordtype',
summary: 'GROUP',
}),
search.createColumn({
name: 'formulatext',
summary: 'GROUP',
formula: '{type.id}',
}),
],
});burkybang
11/17/2020, 1:37 PM Copy code
nlapiSearchRecord('transaction', null,
[],
[
new nlobjSearchColumn('recordtype', null, 'GROUP'),
new nlobjSearchColumn('formulatext', null, 'GROUP').setFormula('{type.id}')
]
);b
battk
11/17/2020, 1:42 PMthe usual saved search advice applies, build your search in the ui first
battk
11/17/2020, 1:43 PMthe load the search to see what its filters/columns look like
battk
11/17/2020, 1:43 PMthere is an extension that can help
l
Lukasz Formela
11/17/2020, 2:51 PM@battk yes, I do/I have it
@burkybang SS2, I'm pulling list of record types from custom multiselect field. Thanks for your help, I think that's what I needed :)
👍 1
5 Views