You could try to denormalize even more :
Create two collections:
- one with user groups in mind
- the second collection with user and groupSignature groups in mind.
For instance, with user groups in mind :
{
"id": "svsKQSFfzhu-SznsU8FUII",
"user": "admin",
"furniture_count":2,
"furniture":[
{
"name": "Table",
"updateDate": "2012-12-31T15:31:16.012Z",
"id": "svsKXRqbVhqZa-SznsU8FUII",
"type": 1,
"groupSignature": "5FJHzWke16auaB2hdqcIP)3a",
},
{
"name": "Chair",
"updateDate": "2012-12-31T15:32:16.012Z",
"id": "t1JLXRqbVhqZa-SzA7CiXdE2",
"type": 1,
"groupSignature": "5FJHzWke16auaB2hdqcIP)3b",
}]
}
{
"id": "svsKQSFfzhu-Sqsdr8FUGG",
"user": "bob",
"furniture_count":1,
"furniture":[
{
"name": "Desk",
"updateDate": "2012-12-31T15:33:16.012Z",
"id": "sIYLXRqbVhqZa-Sz)yIXsZCY",
"type": 1,
"groupSignature": "5FJHzWke16auaB2hdqcIP)3c",
}]
}
{
"id": "svsSDDFseshu-Sqsdr8FUGG",
"user": "Jimmy",
"furniture_count":1,
"furniture":[
{
"name": "Closet",
"updateDate": "2012-12-31T15:34:16.012Z",
"id": "D231Y(haaeWbS2abwjfOT2zt",
"type": 1,
"groupSignature": "5FJHzWke16auaB2hdqcIP)3d",
}]
}
-----
Jouve
France.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Get-groups-which-has-the-number-of-elements-greater-than-tp4174352p4174729.html
Sent from the Solr - User mailing list archive at Nabble.com.
