A gem for saving report filters - 【StackMirror】|ruby-on-rails|filtering

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

2012-04-05 18:51
by Laurens Van Acker

report ≠ rapportJordan Running 2012-04-05 19:17

Thanks Jordan, I changed it. It's called Rapport in dutch. - Laurens Van Acker 2012-04-07 12:48

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.

2012-04-07 12:56
by luacassus

Thanks for the tip @luacassus. But could you explain it some more? I have investigated Mongodb a bit and saw some advantages (less work when adding and removing attributes and sometimes speed advantages) but not how it could help in this case? As I understand, I still have to create Ruby objects with all the possible properties.. create savings objects.. etc.. I see no difference in the pure Ruby On Rails code - Laurens Van Acker 2012-04-07 18:08