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
41-60 / 500 show all
41estUrgentEdit
42autHighEdit
43impedit atque minimaAnecdoticEdit
44id temporibus eligendiEdit
45rerumNormalEdit
46facereAnecdoticEdit
47temporibus iure delectusLowEdit
48qui inciduntLowEdit
49laborumHighEdit
50ipsum nam temporeUrgentEdit
51harum qui possimusAnecdoticEdit
52eos temporibus omnisLowEdit
53molestiaeEdit
54minima in voluptatemNormalEdit
55dolorLowEdit
56sitLowEdit
57nequeNormalEdit
58atque etAnecdoticEdit
59alias liberoUrgentEdit
60voluptas repellendusEdit

Fork me on GitHub