What?
This is an article to document how to use the searchRecords function in CRM and to sort the results response.
Why?
This is unclear and not always working as coded below since each system ...
... the function I came up with. It loops through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice ...
...
Sort the list of keys in ascending/descending order.
Loop through the list of keys, retrieving each record
//
// build up sample map in random order
l_MyListUnsorted = List:Map();
m_Record ...
... newSortedArrayObject = JSON.stringify(my_records_copy); // note: will convert single apostrophes to double-quotes
// split by closing curly brace
var myRecords = newSortedArrayObject.split('}');
...
... as much as I have, you'll note that everyone seems to be recommending using a cursor. I went through about 10 pages of google results without working out how to use these in SSRS and then resorted to my ...
... Dates Order
If you have a date filter list and want it sorted in descending order, I would recommend you return it in SQL date format (yyyy-mm-dd) and then do "Sort Z to A". You may find that the field ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.