WiceGrid 3.6.0.pre4 examples

Saved queries: simple example

Read SAVED_QUERIES_HOWTO.rdoc for details.

  • # encoding: utf-8
    class SavedQueriesController < ApplicationController
      def index
        @tasks_grid = initialize_grid(Task,
          include: [:priority, :status, :project, :assigned_users],
          order: 'statuses.name',
          custom_order: {
            'tasks.priority_id' => 'priorities.name',
            'tasks.status_id' => 'statuses.position',
            'tasks.project_id' => 'projects.name'
          }
        )
      end
    end
    
  • .well
      %h2= current_page_title
      %p
        Read
        %code SAVED_QUERIES_HOWTO.rdoc
        for details.
    
    = show_code
    
    .row-fluid
      .col-md-6
    
        = saved_queries_panel(@tasks_grid, confirm:  false)
    
    = render   'grid'
    
  • <%= grid(@tasks_grid, show_filters: :always) do |g|
    
      g.column name:  'ID', attribute: 'id', filter: false
    
      g.column name:  'Title', attribute: 'title'
    
      g.column name:  'Priority', attribute: 'priority_id', custom_filter: Priority.to_dropdown do |task|
        task.priority.name if task.priority
      end
    
      g.column name:  'Status', attribute: 'status_id', custom_filter: Status.to_dropdown  do |task|
        task.status.name if task.status
      end
    
      g.column name:  'Project Name', attribute: 'project_id', custom_filter: Project.to_dropdown do |task|
        task.project.name if task.project
      end
    
      g.column  name:  'Archived', attribute: 'archived' do |task|
        task.archived? ? 'Yes' : 'No'
      end
    
      g.column name:  'Added', attribute: 'created_at' do |task|
        task.created_at.to_s(:db)
      end
    
      g.column   do |task|
        link_to('Edit', edit_task_path(task))
      end
    end -%>

Opgeslagen query's

IDTitlePriority StatusProject NameArchivedAdded

1-20 / 500 Alle rijen tonen
22etAnecdoticCancelledSuper GameNo2015-05-19 12:37:19Edit
43impedit atque minimaAnecdoticVerifiedSuper GameYes2015-06-03 12:37:19Edit
103molestiaeAnecdoticCancelledDivine FirmwareNo2015-06-08 12:37:20Edit
154nostrumAnecdoticDuplicateDivine FirmwareNo2015-06-06 12:37:21Edit
183iureAnecdoticVerifiedUltimate WebsiteNo2015-04-14 12:37:21Edit
231quia quisAnecdoticDuplicateSuper GameYes2015-03-21 12:37:22Edit
247eum temporeAnecdoticNewDivine FirmwareNo2015-06-09 12:37:22Edit
306omnis voluptatem abAnecdoticVerifiedDivine FirmwareNo2015-05-13 12:37:23Edit
322qui doloresAnecdoticDuplicateSuper GameNo2015-03-31 12:37:23Edit
364nesciunt ullam nequeAnecdoticCancelledSuper GameNo2015-03-26 12:37:24Edit
410et qui sintAnecdoticStartedDivine FirmwareNo2015-04-11 12:37:25Edit
425nulla quoAnecdoticPostponedSuper GameNo2015-03-24 12:37:25Edit
495qui ut inAnecdoticVerifiedUltimate WebsiteNo2015-04-21 12:37:27Edit
208officiaAnecdoticVerifiedUltimate WebsiteNo2015-04-17 12:37:22Edit
58atque etAnecdoticStartedDivine FirmwareNo2015-05-28 12:37:19Edit
422harum enimAnecdoticVerifiedSuper GameNo2015-04-25 12:37:25Edit
3aliquam repudiandaeAnecdoticAssignedDivine FirmwareNo2015-03-21 12:37:18Edit
169vitae oditAnecdoticVerifiedSuper GameNo2015-06-07 12:37:21Edit
14repellat consequatur velitAnecdoticNewUltimate WebsiteNo2015-05-06 12:37:18Edit
331consequuntur ipsa quiAnecdoticResolvedDivine FirmwareNo2015-06-15 12:37:23Edit

Fork me on GitHub