I've got a programatic search I'm trying to run using the following as the basis for the code:
columns = new Array(); columns[0] = new nlobjSearchColumn('itemid'); columns[1] = new nlobjSearchColumn('internalid'); columns[2] = new nlobjSearchColumn('urlcomponent'); columns[3] = new nlobjSearchColumn('categorypreferred'); columns[4] = new nlobjSearchColumn('storedisplayname'); columns[5] = new nlobjSearchColumn('displayname'); columns[6] = new nlobjSearchColumn('parent'); columns[7] = new nlobjSearchColumn('matrix'); columns[0].setSort(); filters = [ ["type","anyof","InvtPart"], "AND", ["isonline","is","T"], "AND", ["isinactive","is","F"], "AND", ["website","anyof","2"] ] results = nlapiSearchRecord('inventoryitem', null, filters, columns);I need to be able to sort by itemid because I need to group the items together by matrix items. But, the results that are returned in the itemid column via nlapiSearchRecord are not the same ones I get when I just execute the search in Netsuite. When I run the search in Netsuite, I can see an itemid like this:[LIST][*]Item Name-Black-S[*]Item Name-Black-L[/LIST] (with extra data representing their matrix options.). When I execute the code above, all that comes back is:[LIST][*]Item Name[*]Item Name[/LIST] What gives? Why are they different?