yii-advanced-filters Improves Yii's grid filters by allowing more powerful search terms.

  1. Introduction
  2. Requirements
  3. Usage
  4. Resources

Introduction ¶

The Yii Advanced Filters extension improves Yii's grid view filters by allowing users to enter more powerful search terms. Multiple filter expressions can be combined together when filtering a single column, allowing for complex filters to be applied.

By default, the extension will understand the following patterns when they are entered into a grid filter:

Syntax Description
word1 word2 word3 All words must appear in any order.
"search term" The value must match the search term exactly.
#search term# The value must contain the exact search term.
/regex/ The value must match the regular expression pattern.
n1 to n2 Numerically between n1 and n2 inclusive.
< n1     <= n1 Numerically less than [or equal to] n1.
> n1     >= n1 Numerically greater than [or equal to] n1.
= n1 Numerically equal to n1.
! filter Invert any filter listed above with an exclamation mark.
filter1 | filter2 The value must match at least one of the combined filters.
filter1 & filter2 The value must match all of the combined filters.

For instance, the filters could be used and combined in the following ways:

Examples
< 400 & !"" Numerically less than 400 and not blank.
=100 | =200 | =300 Numerically equal to either 100, 200 or 300.
gold & ! fool's & ! pyrite Contains the word gold, but not fool's or pyrite.
/^[A-Z][0-9]+$/ A letter followed by one or more numbers (MySQL).
! /[A-Z]/ Does not contain any letters (MySQL).
1 to 100 & ! . & /[02468]$/ Even integers between 1 and 100.

Note that with most delimiters the whitespace is optional, so <400&!"" and < 400 & ! "" are equivalent.

Currently, MySQL and SQL Server databases are supported. See the guide section about extending database helpers if you need to add support for other databases.

Requirements ¶

The extension is targeted at Yii 1.1.x.

Usage ¶

Resources ¶

2 0
5 followers
262 downloads
Yii Version: 1.1
License: MIT
Category: Database
Tags: activerecord, database, gridview, ui, user interface
Developed by: Keith Keith
Created on: Jan 9, 2015
Last updated: 10 years ago

Downloads

show all

Related Extensions