Is it possible to load a saved search in script and change the column that it is sorted by?
I use a saved search for a Suitelet and want to get around the limitation that the native column sort ONLY sorts the data on the current page. Instead, my client wants the entire dataset re-sorted.
I can get the columns off the search object after I load the search, and I try to overwrite the search.columns[i].sort element with “DESC” and set the default column to “NONE” but the results are not showing the data sorted.
Unfortunately, I think I need to create a NEW scripted search… which is a pain in the behind but not the worst. Anyone ever figure out how to change the sort direction of an existing saved search in script??
Scripting in 2.0 ~~~ any/all help helps!
var searchA = search.load({ id : 1430});
var columns = searchA .columns;
columns[1].sort = "NONE";
columns[8].sort = "DESC";
https://system.na0.netsuite.com/app/help/helpcenter.nl?fid=section_456142211913.html
After you create a column, you cannot change the sort order of the column. If you use the same column in another search and specify a new sort order, the previous sort order is still used.
Make a new columnn to replace the one you want to change
Thanks for the quick responses! Yes so my approach is:
- Field on SL for the column you want to sort by, another field for Descending (checkbox)
- Load the saved Search in script, if there is a column to sort by:
- Get columns of existing saved search
- Create a NEW scripted search, same type, maybe add a filter to remove “blank” values – I have noticed the sort descending assumes blanks are first?
- Iterate through columns, create NEW search columns and push onto an array
- If the column is the column to sort by, set the sort attribute for that search column
- Run the search
So going to test how this affects pagination… I noticed when I changed the saved search sort on the actual saved search definition, the “pageNumbers” changed to the sorted appreviation (A-H) changes to (0-12) when sorting on name vs. quantity.
Hope this helps someone else dealing with the same issue!
Eric T Grubaugh
The
sortproperty might be read-only. It’s not actually documented as a property on theColumnobject, and with some quick testing in the console I was unable to change the sort order. I was essentially trying the same approach as you, using thesearch.Sortenum values instead.