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

Hi guys, do you know how to get the categories list data in a backend model with ss2? I need to get all the custom fields for each category so i can manipulate the display in the front.

I don't but I asked ChatGPT and it gave me this:

```var record = require('N/record');

function getCategories() {
    var categories = [];
    var categorySearch = search.create({
        type: "customrecord_ns_sc_category",
        filters: [
            ["isinactive", "is", "F"],
        ],
        columns: [
            search.createColumn({ name: "name", sort: search.Sort.ASC }),
            search.createColumn({ name: "internalid" }),
        ],
    });

    categorySearch.run().each(function(result) {
        categories.push({
            id: result.getValue("internalid"),
            name: result.getValue("name"),
        });
        return true;
    });

    return categories;
}```

I don't think this'll work but :man-shrugging::skin-tone-2: :smile:

`commercecategory` is a standard field so I don't know why it's using a custom record

Anyway, here's the docs: <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4732712917.html>