You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Category Maps

Content

I was asked by a colleague to assist in creating something to show a full map of categories used in the product. A few changes happened here and there and we ended up wanting each level, the level ID and then the ID of the category used.

The expression is fairly simple although it looks a bit messy. It's just a concat with dividers and data repeating to show each ID.
You could swap it out for products by simply swapping out categories.cat_lvl for products.prod_lvl with a quick find/replace.

Not sure if anyone will need it but thought I'd share it as it was annoying me to begin with then obvious once you'd stepped back and taken a look at it.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!