I've only been playing with this product for a day and I am neither a web developer or a DBA. I created a query that joins results from several other entities. Some of the results look like this:
How can I get the table to display the data like this:
From this post, I am not 100 percent sure what you are trying to achieve. Can you give a little more details so I can try to help you out?
I think first image is a result of Query and second image is data grid which you would like to see on screen, correct?
You can use this query inside preparation of any form, use ListRecords widget on form and give spurce Record List which is output of this query.
You will be able to see data grid.
Hope this helps.
Thanks and Regards,
If you can attach the oml it would be great to understand your problem.