search

tombenner / reports_kit

Beautiful, interactive charts and tables for Ruby on Rails
https://reportskit.co
MIT License
362 stars 31 forks source link

ActiveRecord Associations #41

Open dlp21103 opened 5 years ago

dlp21103 commented 5 years ago

In my database I have a store, each store has_many locations, and each location has_many assets. I'm needing to use a context filter based on the current_user's store id, which I have working in more straightforward associations, but I need help with this one. How can I get assets that are only associated with the current user's store_id?

I'm currently getting this error: NoMethodError (undefined method `klass' for nil:NilClass)

<%= render_report 'my_assets_by_age', context_params: { chain_store_id: current_user.chain_store_id } do |report| %>

asset.rb

include ReportsKit::Model reports_kit do contextual_filter :for_chain_store, ->(relation, context_params) { relation.where(chain_store: context_params[:chain_store_id]) } end

nsoseka commented 5 years ago

Hi The best way to go about this is to use your own data method. There are some good examples in the documentation that allow you to do something like this. (https://www.reportskit.co/examples/data_methods_two_dimensions) If you need help writing a custom query for your use case let me know. I hope it helps