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

How do you get result.id and result.recordType to work with a grouped search?

If you can group by internalid and recordtype as well, you can do that. Otherwise, you don't.

how would I do that? In the column definitions?

make the search in the UI first, then export it. easiest way

I didn't see a type field when doing a customer search. Because I had a customer search in my code and it returned a "job" recored

I think it probably makes more sense if you explain what your search is for, doesn't make much sense at the moment

its a customer search that ended up returning a few items that linked to Job Records. So wanted to confirm the type is all

what does the code for the search look like

```var customerSearchObj = search.create({
                type: "customer",
                filters:
                    [
                        ["isinactive", "is", "F"],
                        "AND",
                        ["consoldaysoverdue", "greaterthan", "0"]
                    ],
                columns:
                    [
                        search.createColumn({
                            name: "entityid",
                            summary: "GROUP",
                            label: "Name"
                        }),
                        search.createColumn({
                            name: "companyname",
                            summary: "GROUP",
                            label: "companyname"
                        }),
                        search.createColumn({
                            name: "internalid",
                            summary: "GROUP",
                            label: "Name"
                        }),
                        search.createColumn({
                            name: "formulatext",
                            summary: "MIN",
                            sort: search.Sort.DESC,
                            formula: "ROUND(CURRENT_DATE-{usernotes.notedate})",
                            label: "Formula (Text)"
                        }),
                        search.createColumn({
                            name: 'consoldaysoverdue',
                            summary: 'MIN',
                            label: "Days Overdue"
                        }),
                        search.createColumn({
                            name: "formulanumeric",
                            summary: "MIN",
                            formula: "CASE WHEN LOWER({messages.subject}) LIKE '%past due invoices%' THEN ROUND(CURRENT_DATE-{messages.messagedate}) END",
                            label: "Formula (Numeric)"
                        })
                    ]
            });
            customerSearchObj.run().each(function (result) {```

im not really sure what setup you need to get a project to show up in a customer search

otherwise i dont think you can use `consoldaysoverdue` in an entity search, which has filters for the different entity types

so you may just be stuck doing another search (or maybe query)