I’m successfully loading my data from my API as JSON, but this is where I run into an issue. All of my sorting, filtering, etc is done server side, and returns the JSON object in the order I desire it to output. This works perfectly, as long as I don’t group the items in the Datatable.
I have multiple product categories, eg. Cat1, Cat2, Cat3. Each of these categories has 1 or more sub categories, eg. Cat1Sub1, Cat1Sub2, etc. When I initialize the table, I use groups: [“BrandTitle”, “BrandName”] to combine the appropriate groups/subgroups. The JSON object would like this:
If groups are not set, Cat1 and its subcategories will appear first, like I want them to. If groups are set as I mentioned, ACat will appear first. How can I disable this automatic sorting when grouping?