I'm building a new website where users can create their own reports. The report consists of blocks and a block can be a graph or a table. So such a block visualizes some data. The user can chose which objects are the source of that block and the filters on that. From an existing block he can edit those filters. reports are saved so later on such a report can be called and the data in the graphs and tables is updates.
Are there any gems or methods in Ruby On Rails how I can achieve the saving of such data filtering?
One way could be generating SQL code when creating a block, but I have to save a lot of information then to be able to edit such a block.
Thanks Laurens
You could store report filters in nosql database such as mongodb. With this solution it will be very easy to store and retrieve those params as JSON documents.