Success! Looks like we've fixed this one. According to our records the fix was applied for
TOUCH-3583
in
a recent build.
-
Sencha User
[ST2.1 RC2] SQL Proxy accessing incorrect Filter property
You need to access the getter for the anyMatch filter config.
Not sure if this is planned for 2.1 release, but it'd be nice to get this patch applied.
Here is a patch
Code:
diff --git a/vendor/sencha/touch/src/data/proxy/SQL.js b/vendor/sencha/touch/src/data/proxy/SQL.js
index 1df2d47..c6978bd 100644
--- a/vendor/sencha/touch/src/data/proxy/SQL.js
+++ b/vendor/sencha/touch/src/data/proxy/SQL.js
@@ -272,7 +272,7 @@ Ext.define('Ext.data.proxy.SQL', {
property = filter.getProperty();
value = filter.getValue();
if (property !== null) {
- sql += filterStatement + property + ' ' + (filter.anyMatch ? ('LIKE \'%' + value + '%\'') : ('= \'' + value + '\''));
+ sql += filterStatement + property + ' ' + (filter.getAnyMatch() ? ('LIKE \'%' + value + '%\'') : ('= \'' + value + '\''));
filterStatement = ' AND ';
}
}
-
-
Thanks for the report! I have opened a bug in our bug tracker.
-
Sencha User
Me too. I just pass empty arrays for now. And I've been using #load to setup new ones.
However, Im having larger issues getting inserts to work, so I've ended up doing all the executeSql by hand.

Originally Posted by
rkraus
I have problems with line 268 !
ln = params.filters.length;
When there are no filters setup in the proxy config...
-
-
Sencha User

Originally Posted by
TommyMaintz
I've fixed the issues with filters.
@wprater Can you tell me what particular issues you are having with inserts?
I haven't been able to dig into your callback chain, but it's stalling out Chrome when I #sync the store that's using the SQL proxy. I am, however, doing a very large set of inserts. I'll do another test today, but I was checking the raw sqlite database and it was not growing.
This is just a one time setup/import and Im inserting ~80k records into the table.
Inserting the records manually with executeSql takes a bit of time, but will succeed. After which new selects are fast, which is relieving.
-