Multiple startkey endkey variables as a single request

Couchbase Server
1

Hello,

I have read numerous threads and articles on multiple startkey and endkey embedded within the keys variable. With couch db they seemed to have solved this with a queries variable.
https://issues.apache.org/jira/browse/COUCHDB-523
This was quite some time ago so I was wondering if this has made into couchbase.
Sorry if this is the same question over and over but the only real answers seem to end with have your looked at N1QL or ElastiSearch?

Thank you very much for any guidance.

->Keith

In sql terms I trying do this:

select id from exployees where (name like ‘bill’ or name like ‘john’ or name like ‘cliff’) order by hire date desc.

Here is the cb view

Here is the dump from php’s print_r()

Array
(
[keys] => Array
(
[0] => Array
(
[startkey] => Array
(
[0] => bill
[2] => 1424110642838
)

                [endkey] => Array
                    (
                        [0] => bill
                        [1] => _1004
                        [2] => 1
                    )

            )

        [1] => Array
            (
                [startkey] => Array
                    (
                        [0] => john
                        [2] => 1424110642838
                    )

                [endkey] => Array
                    (
                        [0] => john
                        [1] => _1004
                        [2] => 1
                    )

            )
		[2] => Array
            (
                [startkey] => Array
                    (
                        [0] => cliff
                        [2] => 1424110642838
                    )

                [endkey] => Array
                    (
                        [0] => cliff
                        [1] => _1004
                        [2] => 1
                    )

            )

    )

)

1 Like