Yeah. It’s not flat. You can use admin fields, and it’s a recursive query to find. I have recursive CTE (thanks to ChatGPT). Could also be done on save, sinc

Yeah. It’s not flat. You can use admin fields, and it’s a recursive query to find. I have recursive CTE (thanks to ChatGPT). Could also be done on save, since they shouldn’t change for locations. The recursiveness though, gives you a benefit if you extract type and save the intermediate steps, it allows you to start grouping things together at different levels which is one of the use cases you mentioned.