I have a query I am using in the report module which pulls the codes and description of those codes then using those group all lot numbers that were created by it along with quantity, length and time.
The query works fine as it grabs the info for the codes, desc and then I created another column called lots which then holds all the information for each lot that is part of that product code.
That all works well, however I setup the lot section to produce all information as a JSON not sure if thats the right approach, however, on a table how can I get it to display the JSON information separated, I manage to setup a table to do this but the actual reading of the JSON is the problem.
So I guess my first question is how do I read JSON in a table on the report module