[vkwanengage]

Hi everyone. Fairly new to NetSuite SuiteScript 2.0 so please bear with me. I am trying to search for Inventory Items that uses a custom record type. I was wondering using the N/search module,

a) Is there any way to return a sublist in the columns attribute

b) Is there a way to filter on a sublist

Or do I have to get all the Inventory Items and go record by record to check if they have a sublist lineitem?

Thanks.
This is a cached copy. Click here to see the original post.

[jshepler]

I’m new and learning stuff too, and am interested in how to construct such a search.

One option might be to use a saved search. If you can craft a saved search in the UI (lists / searches / saved searches) that does what you want, you can run that search from code.

[vkwanengage]

Thanks jshepler…

I checked out the Saved Searches Page…. Looks like you can only filter by fields of that particular Record Type I don’t see an option to filter by a sublist/subrecord

[jshepler]

The drop down includes related records at the bottom in the form “XX fields…” and when you select that, you get a popup that then lets you select fields from that record type.

[MChammaTX]

Originally posted by jshepler

View Post

The drop down includes related records at the bottom in the form “XX fields…” and when you select that, you get a popup that then lets you select fields from that record type.

You are correct. You can use joins in SuiteScript to your custom record. The column format is something like {name:’customrecord column name’, join:’field id of custom record’}

[vkwanengage]

Thanks for all the help…. I figured out a different approach.. Instead of filtering by a sublist i went the other way around.. Search by the custom record type (which would have been the sublist) and getting the record type id that it is associated to and query that instead…

But this has been great help. Thanks everyone

[reecemak]

I think you need to use ‘join’

[Author]

Posts