Custom queries using a web GUI
Posted on 2011-09-02
I have seen a software in a workstation that is capable of showing queries from a database and you can "customize" the appereance just using drag and drop over the field headers. I would like to know if this functionallity is available for web using a component or stuff like that.
But I´ll explain better all this, lets say that we have the following query:
ID_PRODUCT, CATEGORY, GROUP, ITEM, DESCRIPTION, PRICE
Just by dragging the header of the field CATEGORY to the grouping area (at the very top of the GUI), I could group all the registers by its Group content, I could even nest two or more headers in order to get a more sophisticated query.
This is a very powerful tool for watching the same info organized in different ways.