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
61-80 / 500 show all
61quia architectoNormalEdit
62eum velit saepeNormalEdit
63accusamusEdit
64reiciendisNormalEdit
65eosHighEdit
66vitae at autemNormalEdit
67officia quo maioresAnecdoticEdit
68exercitationem delectusNormalEdit
69similique placeat ipsaAnecdoticEdit
70autemNormalEdit
71atNormalEdit
72illum explicabo modiEdit
73iure architectoNormalEdit
74molestiaeEdit
75velit non magniEdit
76totamAnecdoticEdit
77sed quibusdam isteLowEdit
78exercitationem sapienteUrgentEdit
79animiEdit
80corrupti officiaUrgentEdit

Fork me on GitHub