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
481-500 / 500 Alle rijen tonen
481etUrgentEdit
482consequuntur eumUrgentEdit
483laborum dictaLowEdit
484quiaAnecdoticEdit
485ut teneturAnecdoticEdit
486enim harum minimaAnecdoticEdit
487natus etLowEdit
488doloribus veritatisHighEdit
489voluptatemHighEdit
490maximeEdit
491modi nesciuntEdit
492sed atEdit
493estEdit
494fugiat quaeratEdit
495qui ut inAnecdoticEdit
496velit non pariaturHighEdit
497impedit quoEdit
498sedLowEdit
499voluptatemUrgentEdit
500vel eaEdit

Fork me on GitHub