Query Index Not Working

SQL++
1

I have a query that I know should bring back data but doesn’t. I have added an index to make this query faster but ends up coming back with 0 documents. What am I doing wrong?

CREATE INDEX platform ON cmw((devices.platform))

select * from cmw where devices.platform = “roku-1”;
{
“requestID”: “97b24968-0252-4ddf-96e7-044cbe63b1b7”,
“signature”: {
"": ""
},
“results”: [
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “15.935331ms”,
“executionTime”: “15.819574ms”,
“resultCount”: 0,
“resultSize”: 0
}
}

##########################

Sample data of what is there

{
“devices”: {
“2b5d6e50-0a0c-57fa-9f35-8edac58726e7”: {
“product”: “sling”,
“platform”: “roku-1”,
“oauth-token-secret”: “doApRNv81nO2oECmwWZfee6wVYTtCvhTx0oYO8Yh”,
“oauth-token”: “A9UqN6Hme72IidXocn7hft0J2dFUOdwJG2ggRYbQ”,
“consumer-key”: “EbwOPNSdzCPUB2YWB0KPmjhHKJWVwF2tp1iTIN6o”,
“consumer-secret”: “FVlLo5JuzdL9Mk3uMyGldlY6rjQN9EKcXVKEotsC”
}
}
}

2

Couchbase Server 4.5.0-2601 (CE)

3

cbq> select count(*) from cmw;
{
“requestID”: “8f186d0d-3fc4-4745-927a-1f6e2922263e”,
“signature”: {
"$1": “number”
},
“results”: [
{
"$1": 11399023
}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “23.223164ms”,
“executionTime”: “23.148936ms”,
“resultCount”: 1,
“resultSize”: 38
}
}

4

Just realized that this will work …
select * from cmw where cmw.devices.0cf01664-a172-5446-ae4a-570ce1a990ba.platform=“roku” limit 5;

Any idea on how to wild card that guid so that I can get all documents back?

5

See the syntax and examples for ANY / IN / SATISFIES and ANY / WITHIN / SATISFIES.

6

This seemed to work
select * from cmw where object_values(devices)[0].platform = ‘roku’;

7

That works if there is only one GUID under devices.