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
461-480 / 500 Alle rijen tonen
461dolor voluptasNormalEdit
462provident doloremque laudantiumHighEdit
463excepturiEdit
464culpaEdit
465totamEdit
466autAnecdoticEdit
467in error praesentiumNormalEdit
468officiisLowEdit
469natus autemNormalEdit
470et nonAnecdoticEdit
471illo ut evenietAnecdoticEdit
472perspiciatisEdit
473voluptatum quiEdit
474possimusHighEdit
475rerum perspiciatis eumEdit
476facere voluptasEdit
477et corruptiEdit
478necessitatibusAnecdoticEdit
479provident exUrgentEdit
480quas sapiente rerumAnecdoticEdit

Fork me on GitHub