Fix substring search in LiveGrid column

diff --git a/lib/rico/ricoLiveGridAjax.js b/lib/rico/ricoLiveGridAjax.js
index 6377aa9..2e694f9 100644 (file)
--- a/lib/rico/ricoLiveGridAjax.js
+++ b/lib/rico/ricoLiveGridAjax.js
@@ -422,7 +422,11 @@ Rico.Buffer.AjaxSQLMethods.prototype = {
       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;
       }
     }