WiceGrid 3.6.0.pre4 examples

Custom filters (null values)

Strings null and not null in custom_filter values are treated speacially and result in IS NULL and IS NOT NULL WHERE-clauses.

  • # encoding: utf-8
    class NullValuesController < ApplicationController
      def index
        @tasks_grid = initialize_grid(Task,
          custom_order: {
            'tasks.priority_id' => 'priorities.name'
          }
        )
      end
    end
    
  • <%= grid(@tasks_grid) 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: [['NOT DEFINED', 'null'], ['DEFINED', 'not null']] + Priority.to_dropdown do |task|
        task.priority.name if task.priority
      end
    
    
      g.column   do |task|
        link_to('Edit', edit_task_path(task))
      end
    end -%>
  • .well
      %h2= current_page_title
      %p
        Strings
        %code null
        and
        %code not null
        in
        %code custom_filter
        values
        are treated speacially and result in
        %code IS NULL
        and
        %code IS NOT NULL
        WHERE-clauses.
    
    = show_code
    
    .row-fluid
      .col-md-12
        = render   'grid'
IDTitlePriority
21-40 / 500 show all
21et rerum laborumEdit
22etAnecdoticEdit
23exercitationem autAnecdoticEdit
24voluptate culpaNormalEdit
25ab quiHighEdit
26quia mollitia delenitiUrgentEdit
27eum velHighEdit
28laborum enim voluptasEdit
29etEdit
30corrupti molestiae abHighEdit
31debitis pariatur illoEdit
32voluptatem ipsam liberoHighEdit
33voluptatemUrgentEdit
34illo voluptasHighEdit
35modiNormalEdit
36placeatUrgentEdit
37etNormalEdit
38minima doloribus sedLowEdit
39praesentium et idUrgentEdit
40dolorAnecdoticEdit

Fork me on GitHub