Is it possible to use SuiteScript to programmatica...
# suitescriptt
tdietrich
10/14/2019, 1:23 PMIs it possible to use SuiteScript to programmatically get a record type's search joins, filters, and columns (the info that the Records Browser provides)?
n
nzaleski
10/14/2019, 1:43 PMI am not sure how you want to use this, but the short answer is yes. You have access to this properties in the search object. There is also a very sweet chrome extension that gets all of that for you. https://chrome.google.com/webstore/detail/netsuite-search-export/gglbgdfbkaelbjpjkiepdmfaihdokglp
nzaleski
10/14/2019, 1:45 PMBut if you need this in a suitescript then the
searchsearch.columnssearch.filterst
tdietrich
10/14/2019, 1:46 PMThanks, @nzaleski. That plugin seems to provide the settings for a saved search. What I'm trying to get is a list of the supported joins, filters, and columns for a given record type.
n
nzaleski
10/14/2019, 1:49 PMOh I see. I dunno if that is possible. I remember reading an article where someone was trying to achieve a
SELECT * FROM recnzaleski
10/14/2019, 1:52 PMSorry that was in the old NetSuite user group (before it was Oracle) and it doesn't look like the old content got was moved to the new user group. so I wasn't able to find it
t
tdietrich
10/14/2019, 2:06 PMThanks, @nzaleski. I've searched everywhere, and I just don't think it's possible to get those values via SuiteScript itself. It is possible to get some of this info using the new REST-based SuiteTalk API, but not everything.
2 Views