how to query on android ??

[liufsd]

such as where user_last_time > 123456 and username = 'test' ???

[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: +4912342343"; 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: +4912342342"; 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: +4912342340"; 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!