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 -%>
IDTitle Priority
1-20 / 500 Alle rijen tonen
25ab quiHighEdit
63accusamusEdit
436accusantiumHighEdit
426accusantium eligendiAnecdoticEdit
370accusantium error exercitationemNormalEdit
168adHighEdit
86adipisciEdit
346adipisci at nesciuntHighEdit
146adipisci etLowEdit
147adipisci ut asperioresEdit
81ad quo dolorHighEdit
59alias liberoUrgentEdit
3aliquam repudiandaeAnecdoticEdit
188aliquid adipisciEdit
139aliquid oditLowEdit
230aliquid rerum modiHighEdit
215aliquid sed suntHighEdit
79animiEdit
447animi accusantium utUrgentEdit
175aperiam omnisEdit

Fork me on GitHub