This message was deleted.
# suiteql
s
This message was deleted.
e
why not? You can, just need to spend time to do the migration and figure it out what is the matching field on SuiteQL. if the saved search is slow, you would need to also check if more filters are necessary or updating the range of dates, etc.
Where are using the saved search currently? I do not follow you, if you want to inject a portion of suiteql to a saved search via script, that is not possible.
No, that is not possible as far as I know. You need to get more familiar with SuiteQL. You did not mention any script but in a script you would use the N/query Module and then use code like this:
// Create Query instance
*var* productTypeQuery = query.create({*type*: query.Type.ITEM});
// Add Condition
productTypeQuery.condition = productTypeQuery.createCondition({
fieldId: 'id',
operator: query.Operator.ANY_OF,
values: itemList
});
// Add Columns
productTypeQuery.columns = [
productTypeQuery.createColumn({fieldId: 'id'}),
productTypeQuery.createColumn({fieldId: 'your_field'})
];
// Execute Query and process results using native JS Array methods
*var* productTypeResultSet = productTypeQuery.run();
You are mixing two different NetSuite capabilities, you cannot inject a select into a saved search, saved search does not understand suiteql and it is older than the other. If you already have the suiteQL, then it seems you have the problem solved.
Oh man, nobody will help you with that aptitude, you are not paying for anything and I was just trying to help a strange who thinks that know a lot but you did not even share enough details, go for a walk and you might figure it out. Good luck to you with your problem.
s
Don't fret eminero, Simon clearly has no clue.
🤝 2