Hi, I am new to couchbase.lite, Can anyone help me how to get arrayobject based on condition.
Excepted: I want codes[0] array object when code =1
Query -
var query = QueryBuilder.Select(SelectResult.Expression(Meta.ID), SelectResult.All())
.From(DataSource.Database(database))
.Where(Expression.Property("$Type")
.EqualTo(Expression.String("Type1"))
.And(Expression.Property("Codes")
.In(Expression.Property("Code")).EqualTo(Expression.Int(1))))
.Limit(Expression.Int(1));
my json document format is
{
"Id": "TestDocument",
"$Type": "Type1",
"Items":["One", "Two"]
"Codes": [
{
"DocType": "DocumentType1",
"Code": 1,
"ConfigurationCode": 0,
"Name": "DocumentType Name"
},
{
"DocType": "DocumentType2",
"Code": 2,
"ConfigurationCode": 0,
"Name": "DocumentType Name"
}
]
}