| Code let f = jqGridFilterBuilder; |
Js object returned * ver la consola |
Filter2Where.php |
|---|
| Op | In Sql | Note |
|---|---|---|
| eq | = | |
| ge | >= | |
| gt | > | |
| le | <= | |
| lt | < | |
| ne | <> | |
| bt | BETWEEN | Values in array or coma separated. |
| nu | IS NULL | |
| nn | IS NOT NULL | |
| in | IN | Values in array or coma separated: value1,value2,... |
| ni | NOT IN | Values in array or coma separated: value1,value2,... |
| bw | LIKE 'asdf%' | begins with |
| bn | NOT LIKE 'asdf%' | not begins with |
| cn | LIKE '%asdf%' MATCH(field) AGAINST('+word1 +word2' IN BOOLEAN MODE) | contains If filter2where defines field has full text index, respetando min y max token size |
| nc | NOT LIKE '%asdf%' | not contains |
| ma |
MATCH(field) AGAINST('+word1 +word2' IN BOOLEAN MODE)
LIKE '%asd%'# en menos de mi token o mas de max token | full text search Usa fulltext Index sin checar si esta definido |
| ew | LIKE '%asdf' | ends with |
| en | NOT LIKE '%asdf' | not ends |