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
    
  • .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'
  • <%= 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 -%>
IDTitlePriority
81-100 / 500 show all
81ad quo dolorHighEdit
82utLowEdit
83enimEdit
84doloreHighEdit
85voluptatibus inventoreEdit
86adipisciEdit
87nostrumNormalEdit
88culpaUrgentEdit
89provident consequatur remLowEdit
90commodi et quisHighEdit
91quaeratHighEdit
92est praesentiumAnecdoticEdit
93autEdit
94officiisEdit
95quibusdam beatae adNormalEdit
96impedit explicabo voluptatemUrgentEdit
97voluptatem facilis etEdit
98aperiam rerumNormalEdit
99solutaHighEdit
100autem nonNormalEdit

Fork me on GitHub