Summary of Problems

{
 supplierId : 123,
 partNumber:  4323, ---> Lets call it (P1)
 quantity: 10, 
 price: 350
}

Supplier 123 has 10 units of part number 4323.

{
 supplierId : 123,
 partNumber:  5463, --> Lets call it (P2)
 quantity: 2, 
 price: 343
}

Supplier 123 has 10 units of part number 5463.

Problem 1 : Search all suppliers who has P1 >=10 AND(and not OR) P2 >=20 . Given Part Number and Quantity are two different fields in the documents, how would we achieve this kind of faceting. Problem 2: How to groupBy search results based on 1 field ? For instance Group all search results by SupplierId.