i badly need to join multiple searches in NetSuite (joins which are not available in netsuite) - whats the best way to do it ? - do you iterate through each result ? - do you create json out of search results and then join ? do you split results into multiple arrays and then process ? i tried using json but NetSuite search structure is nested and unnecessarily complicated, also NetSuite search object columns do not have data types, any one having any experience or share code would be greatly helpful

@j.j I use this function to merge as many objects I need. It "joins" the two objects using a common field. In order for this to work properly, the secondary object needs to be sorted on that common field. The resulting object is the primary object. It also helps if you use column labels in your search results.