I'm struggling to understand the logical link between categories and item groups/items.
I would have presumed categories and item groups would have been linked together, however categories and items are linked.
I'm looking to create an inventory list, similar to the following:
However, it looks like I need to query 'categories', to get the 'items', and then get the distinct 'item groups' from there. Not impossible, but I'm using a nosql structure, while trying to follow clover's api closely.
I just want to ensure there's no easier route before preceding. Thank you