diff options
| author | liviuconcioiu <liviu.concioiu@gmail.com> | 2021-04-17 00:44:19 +0300 |
|---|---|---|
| committer | William Desportes <williamdes@wdes.fr> | 2021-04-23 19:58:08 +0300 |
| commit | c4ca6f346c3d5114564c5ee1c9ff4de2188e51cc (patch) | |
| tree | 416009209d210fe8cebd6dd821df44ed030436cf /js | |
| parent | 971e07a3a2254299898e45de5fe4435b2236fa4f (diff) | |
Fix #16829 - Add NOT LIKE %...% operator to Table search
Signed-off-by: Liviu Concioiu <liviu.concioiu@gmail.com>
Diffstat (limited to 'js')
| -rw-r--r-- | js/src/database/query_generator.js | 1 | ||||
| -rw-r--r-- | js/src/table/change.js | 3 |
2 files changed, 3 insertions, 1 deletions
diff --git a/js/src/database/query_generator.js b/js/src/database/query_generator.js index 97842b3615..d2692aee3a 100644 --- a/js/src/database/query_generator.js +++ b/js/src/database/query_generator.js @@ -21,6 +21,7 @@ function getFormatsText () { 'LIKE': ' LIKE \'%s\'', 'LIKE %...%': ' LIKE \'%%%s%%\'', 'NOT LIKE': ' NOT LIKE \'%s\'', + 'NOT LIKE %...%': ' NOT LIKE \'%%%s%%\'', 'BETWEEN': ' BETWEEN \'%s\'', 'NOT BETWEEN': ' NOT BETWEEN \'%s\'', 'IS NULL': ' \'%s\' IS NULL', diff --git a/js/src/table/change.js b/js/src/table/change.js index 27ed7e3138..a4082bfa1a 100644 --- a/js/src/table/change.js +++ b/js/src/table/change.js @@ -849,7 +849,8 @@ function changeValueFieldType (elem, searchIndex) { if ('LIKE' === type || 'LIKE %...%' === type || - 'NOT LIKE' === type + 'NOT LIKE' === type || + 'NOT LIKE %...%' === type ) { $('#fieldID_' + searchIndex).data('data-skip-validators', true); return; |