As of April 12th, you must go to Progress SupportLink to create new support cases or to access existing cases. Please, bookmark the SupportLink URL and use the new portal to contact the support team.
so this can be accomplished with a workaround, by overloading the `equals` method. Use this in combination with the fact that a `GenericJson` is just a HashMap, and you can access any mongo operators that might not be wrapped by the library.
Ruben
db.products.find({"items.shoppinglists":{$elemMatch:{
"shoppinglistid":"52602d3582d850d77f001466",
"state":"pending"
}}})
Sample of the data:
{
"_id" : "541485d974c3eae62603dc1b",
"items" : [
{
"content" : 1,
"price" : 1,
"quantity" : 1,
"shoppinglists" : [
{
"quantity" : 1,
"shoppinglistid" : "52602d3582d850d77f001466",
"state" : "pending"
}
]
}
],
"product" : "Milk",
"_acl" : {
"creator" : "52601ac17c932fc07e00187b"
},
"_kmd" : {
"lmt" : "2014-09-13T17:58:53.267Z",
"ect" : "2014-09-13T17:58:49.223Z"
}
}
The best aproximation I've find is this but doesn't return the desired data:
mDataStore.query.in("items.shoppinglists.shoppinglistid", arrayshoppinglistids)
.equals("items.shoppinglists.state","pending");
Is the command elemMatch not supported? Is there any other workaround?
Thanks in advance,
Ruben.