This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Howdy ya'll! Does anybody have any experience in creating a suitelet to combine saved searches? Basically, I'm trying to combine two different record types in a single report, using a key that both of the records have in common. The records technically are not linked, so unfortunately, I cannot use a join.

Yes, you can do that. Do you have a specific question?

Ha, yeah I guess I didn't even ask a friggin' question... How exactly do you do it?? I've always been fascinated with it. I have some experience with SS 2.0, but are there any SuiteAnswers articles relating to it or some type of basic walkthrough?

You might look into a solution that does this for you that's already built

<https://alterviewshop.com/product/alterview-charts-pro-for-netsuite/>

Basically you use custom records to join searches together and it does the stitching for you.

I haven't personally used it - but I am aware of a client of mine that bought it and loved it.

or one of their other solutions that did what you were looking for

Ah that sounds awesome! I don't know if that's feasible with my current client, unfortunately...

<@UM3UMEK3L> the basic idea is to run each search, retrieve all results into a JavaScript object/array, and then iterate through one of the results and combine it with the other. In a project I had to do this extensively I used a JS utility library called lodash, but you can do this all with just vanilla JS.

Loadash seems AWESOME! Now if I can just figure out how to set up libraries... Thanks so much for the help!