Couchbase lite sdk 2.7 nested array query problem

Mobile
, ,
1

I have below json. i want to query widgets whose createdAt value is greater than 1604047949428.

json →

{
“accountId”: “ABC”,
“haveUnreadConversation”: true,
“className”: “IntegratorUserChannel”,
“type”: “channels”,
“email":"abc@gmail.com”,
“conversations”: [
{
“widgets”: [
{
“createdAt”: 1604047949425,
“userResponse”: true,
“message”: “hi”
},
{
“createdAt”: 1604047949428,
“userResponse”: true,
“message”: “hello”
}
]
},
{
“widgets”: [
{
“createdAt”: 1604047949430,
“userResponse”: true,
“message”: “bye”
},
{
“createdAt”: 1604047949431,
“userResponse”: true,
“message”: “good”
}
]
}
]
}

@jens @priya.rajagopal

2

Not sure if there is a way to do that out of box without array unnest functionality (which we do not have at this time). The simplest option would be for you to query for conversations array and to process the result set locally within your app.

3

Hi @priya.rajagopal, thanks for reply. My problem is that i want to integrate pagination on widgets basis. Can you help me how to do this in such json format using couchbase query.