CSV export works with
define_grid
and external filters, too.
# encoding: utf-8 class CsvAndDetachedFiltersController < ApplicationController def index @tasks_grid = initialize_grid(Task, name: 'grid', enable_export_to_csv: true, csv_field_separator: ';', csv_file_name: 'tasks' ) export_grid_if_requested('grid' => 'grid') end end
<%= define_grid(@tasks_grid, hide_submit_button: true, hide_reset_button: true) do |g|
g.column name: 'ID', attribute: 'id', detach_with_id: :id_filter
g.column name: 'Title', attribute: 'title', detach_with_id: :title_filter
g.column name: 'Description', attribute: 'description', detach_with_id: :description_filter
g.column name: 'Archived', attribute: 'archived', detach_with_id: :archived_filter do |task|
task.archived? ? 'Yes' : 'No'
end
g.column name: 'Due Date', attribute: 'due_date', detach_with_id: :due_date do |task|
task.due_date.to_s(:short)
end
g.column do |task|
link_to('Edit', edit_task_path(task))
end
end -%>
.well %h2= current_page_title %p CSV export works with %code define_grid and external filters, too. = show_code = render 'grid' .row .col-md-2 ID: .col-md-10 = grid_filter @tasks_grid, :id_filter .row .col-md-2 Title: .col-md-10 = grid_filter @tasks_grid, :title_filter .row .col-md-2 Description: .col-md-10 = grid_filter @tasks_grid, :description_filter .row .col-md-2 Archived: .col-md-10 = grid_filter @tasks_grid, :archived_filter .row .col-md-2 Due date: .col-md-10 = grid_filter @tasks_grid, :due_date .row .col-md-12 %button.btn.btn-primary.wg-external-submit-button{'data-grid-name' => 'grid'} Submit %button.btn.btn-default.wg-external-reset-button{'data-grid-name' => 'grid'} Reset %button.btn.btn-primary.wg-external-csv-export-button{'data-grid-name' => 'grid'} Export To CSV %p .row .col-md-12 = render_grid(@tasks_grid)
ID | Title | Description | Archived | Due Date | |
---|---|---|---|---|---|
1-20 / 500 show all | |||||
1 | impedit aperiam libero | Est necessitatibus tempora ut. | No | 27 Jul | Edit |
2 | ut sint | Assumenda ut in commodi nihil ratione odio voluptatibus ea. | No | 21 Oct | Edit |
3 | aliquam repudiandae | Consequatur iste similique dolorum ducimus ut. | No | 20 Apr | Edit |
4 | nisi qui | Quas assumenda eos molestiae recusandae eveniet sit sint. | No | 16 May | Edit |
5 | dicta pariatur | Corporis iure repellat fuga omnis alias iusto aut voluptatum. | No | 4 Mar | Edit |
6 | molestiae autem | Explicabo aut ratione omnis voluptatem officia itaque dicta aut. | Yes | 26 Oct | Edit |
7 | ut veniam | Molestiae qui qui quo occaecati. | No | 4 Aug | Edit |
8 | nulla | Natus sint inventore culpa fugiat occaecati est distinctio. | No | 22 May | Edit |
9 | quisquam in iste | Et fugiat blanditiis facilis asperiores et. | No | 7 Mar | Edit |
10 | rerum occaecati | Cum aperiam voluptas aut. | No | 14 Aug | Edit |
11 | aspernatur est | Voluptatem error inventore officia rem nemo qui. | Yes | 21 Jun | Edit |
12 | explicabo hic | Porro in nisi ea sunt consequatur est incidunt et. | No | 15 Apr | Edit |
13 | ut | Est voluptas impedit perferendis excepturi aliquid doloremque. | No | 18 Jul | Edit |
14 | repellat consequatur velit | Error autem et deleniti nihil maxime voluptatem eius eveniet. | No | 10 Jan | Edit |
15 | est ut aut | Vero distinctio voluptatem veritatis. | No | 30 Oct | Edit |
16 | omnis | Possimus voluptas tempore sed mollitia neque vero nesciunt. | No | 5 Feb | Edit |
17 | itaque suscipit commodi | Et ut eveniet deleniti voluptatem omnis ea magnam et. | No | 23 Aug | Edit |
18 | necessitatibus commodi | Labore dolor et cumque quos. | No | 28 Mar | Edit |
19 | id rem ea | In odio quia laborum quam dicta nulla. | Yes | 14 Apr | Edit |
20 | aspernatur eligendi adipisci | Maiores perspiciatis tempore et aut sapiente eaque. | No | 8 Jun | Edit |