I am trying to get my head around how to generate a path or folder structure based on record values. The order is known, as it’s laid out in the following schema by PARAM_NAME: (PARENT, CONTAINER, PURPOSE, STATUS). I’m trying to return a result that I can use to generate a folder structure from these values. But the PARAM_VALUES can be different, meaning a different visual folder structure. How I do this on the html side is still undecided, but I can’t even consider that part until I can somehow represent the data in a structured form. Whether it be records via cursor, or a json dump or string. I just need to be able to walk the data to generate an unordered list or hierarchy.
Example based on the following data:
id file_id param_name param_value
100 1 PARENT WORK
101 1 CONTAINER PROJECT
102 1 PURPOSE SPECIAL
103 1 STATUS OPEN
104 2 PARENT WORK
105 2 CONTAINER TODO
106 2 PURPOSE CHORE
107 2 STATUS INPROGRESS
Any tips would be greatly appreciated.
Thank you in advance =]
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>