how to query on android ?? about todolite-android

[tleyden]

Can you ask on the couchbase mobile google group?

https://groups.google.com/forum/m/?utm_medium=email&utm_source=footer#!forum/mobile-couchbase

[liufsd]

i have not found any help from groups website .

hi ! thanks for your help.
i have a question about query cause .
i mean .in sql such as :select *from user where (sore >90 and per = ‘wade’) or due = ‘today’
how query this line on couch???
Thanks

[jchris]

This might help http://developer.couchbase.com/mobile/develop/guides/couchbase-lite/native-api/query/index.html

[liufsd]

my data:
2014-09-30 09:19:01.980 TestCLDB[490:10457] Found document: CBLDocument[N_ol..ro_3] ,{
"_id" = "N_older_Pro_3";
"_rev" = "1-0601c2e7054bd8f1c21f26c9ebd93c3a";
contactData = "Tel: [phone]";
progress = 60;
type = contacInfo;
userOlder = 8;
"user_id" = "N_older_Pro_3";
}
2014-09-30 09:19:01.981 TestCLDB[490:10457] Found document: CBLDocument[N_ol..ro_2] ,{
"_id" = "N_older_Pro_2";
"_rev" = "1-e550947cda089edd35170c49c6d1023b";
contactData = "Tel: [phone]";
progress = 65;
type = contacInfo;
userOlder = 9;
"user_id" = "N_older_Pro_2";
}
2014-09-30 09:19:01.981 TestCLDB[490:10457] Found document: CBLDocument[N_ol..ro_0] ,{
"_id" = "N_older_Pro_0";
"_rev" = "1-2fc730769d3a7ff64c7e3e512cadb12a";
contactData = "Tel: [phone]";
progress = 75;
type = contacInfo;
userOlder = 8;
"user_id" = "N_older_Pro_0";
}

and i query (progress>60 and progress<75) and (userOlder>5 and userOlder<8)
i use this:
query.startKey = @[pro,startOlder];
query.endKey = @[endPro, endOlder];
but it will return the progress>60 and progress<75 but not filter userOlder ?
why ??
thanks
my project here:(https://github.com/79144876/CouchbaseQuery) you can test it!