Fix caret in filter specs

[infodrom/rico3] / minsrc / ricoLiveGridAjax.js

diff --git a/minsrc/ricoLiveGridAjax.js b/minsrc/ricoLiveGridAjax.js
index 44fd353..d239546 100644 (file)
--- a/minsrc/ricoLiveGridAjax.js
+++ b/minsrc/ricoLiveGridAjax.js
@@ -484,7 +484,11 @@ Rico.Buffer.AjaxSQLMethods = {
       queryHash['f['+colnum+'][len]']=c.filterValues.length;
       for (var i=0; i<c.filterValues.length; i++) {
         var fval=c.filterValues[i];
-        if (c.filterOp=='LIKE' && fval.indexOf('*')==-1) fval='*'+fval+'*';
+        if (c.filterOp=='LIKE' && fval.indexOf('*')==-1) {
+           if (c.format.filterUI.charAt(1) == '^') fval=fval+'*';
+           else if (c.format.filterUI.charAt(1) == '$') fval='*'+fval;
+           else fval='*'+fval+'*';
+       }
         queryHash['f['+colnum+']['+i+']']=fval;
       }
     }