From 91e93b38542f924296bd3ad1249a32812448da20 Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Mon, 21 Sep 2015 12:56:54 +0200
Subject: [PATCH 1/1] Convert filter value for type date

This fixes a problem when the date format is set to German.
Requires adjustments for other formats, though.
---
 minsrc/ricoLiveGridAjax.js | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/minsrc/ricoLiveGridAjax.js b/minsrc/ricoLiveGridAjax.js
index d239546..7fde76c 100644
--- a/minsrc/ricoLiveGridAjax.js
+++ b/minsrc/ricoLiveGridAjax.js
@@ -484,6 +484,16 @@ 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.format.type == 'date') {
+	    var parts = fval.split('.');
+	    if (parts.length > 1) {
+		parts.reverse();
+		for (var j=0; j < parts.length; j++)
+		    if (parts[j].length == 1)
+			parts[j] = '0' + parts[j].toString();
+		fval = parts.join('-');
+	    }
+	}
         if (c.filterOp=='LIKE' && fval.indexOf('*')==-1) {
 	    if (c.format.filterUI.charAt(1) == '^') fval=fval+'*';
 	    else if (c.format.filterUI.charAt(1) == '$') fval='*'+fval;
-- 
2.20.1