Code:
var itemSearchObj = search.create({
type: “item”,
filters: [
[“matrix”,”is”,”T”]
],
columns: [
“itemid”,
“displayname”,
“salesdescription”,
“type”,
“baseprice”
]
});
itemSearchObj.run().each(function(result){
return true;
});

Hi sterlingr,

If you need use a scripted search to fetch specific matrix subitems, then you can use the following snippet:

Code:
var filters = [[‘matrixchild’,’is’,’T’]]; var columns = []; nlapiSearchRecord(“item”,null,filters,columns);
If you’re on an item record and need to verify if it is a matrix subitem, then use the following:

Code:
nlapiGetFieldValue(‘hasparent’);
It will also work if you load the record:

Code:
rec.getFieldValue(‘hasparent’);
Hope that helps,

– Robert

Thanks guys. I went ahead and setup a custom field for it because I want it available for multiple applications. I am going to work more with the search records though and see how that would apply. I’m still getting my feet wet here.

Also, I did try ‘hasparent’ but that doesn’t work as expected — It shows true for any item that has a parent even non matrix items (which is pretty much all of our items). I simply need the nlapiGetFieldValue(‘matrixchild’) option but that doesn’t work.

I highly recommend the ‘search export’ chrome extension – you can edit a saved search and click a button to see the scripted version of that search. super useful:

https://chrome.google.com/webstore/d…er-info-dialog

David Smith’s code should work for what you want.

That is brilliant. Added both of his extensions! Thanks!