Yii Advanced Filters Demo
Filter Grid
You can test the advanced filters extension using the grid below.
Click here for filter suggestions.
Enter aa into the Symbol field. Now try "aa".
Enter /[0-9]/ into the Name field.
Enter 100 to 200 into the Price field.
Enter med systems into the Name field.
Enter plc | ltd into the Name field.
Enter systems into the Name field.
Now try systems & ! adobe.
Enter < 2 into the Dividend Yield field.
Now try < 2 | "".
Enter 1.2 into the Dividend Yield field.
Now try =1.2.
Enter \& into the Name field to search for names
containing the & character.
Displaying 141-150 of 496 results.
| Symbol | Name | Price | Dividend Yield | Earnings / Share |
|---|---|---|---|---|
| BMY | Bristol-Myers Squibb | 60.65 | 2.45 | 1.620 |
| PFG | Principal Financial Group | 53.47 | 2.43 | 3.529 |
| GCI | Gannett Co | 32.69 | 2.43 | 2.050 |
| UPS | United Parcel | 110.98 | 2.43 | 4.024 |
| IVZ | INVESCO Ltd | 41.15 | 2.41 | 2.285 |
| SJM | Smucker (J.M.) | 101.72 | 2.41 | 5.461 |
| NI | NiSource | 41.81 | 2.41 | 1.673 |
| INTC | Intel Corp | 37.67 | 2.40 | 2.100 |
| NOV | Natl Oilwell Varco | 66.89 | 2.40 | 5.971 |
| MET | MetLife | 56.35 | 2.40 | 4.888 |
Data provided by GitHub datasets and originally sourced from the S&P 500 website.
Quick Guide
| Text | |
|---|---|
| word1 word2 | All words |
| "search term" | Exact |
| #search term# | Substring |
| /regex/ | RegEx |
| Numeric | |
| n1 to n2 | Between |
| < n1 | Less than |
| <= n1 | or equal |
| > n1 | Greater |
| >= n1 | or equal |
| = n1 | Equal |
| Modifiers | |
| ! filter | Invert |
| filter1 | filter2 | Or |
| filter1 & filter2 | And |
\.