Join in mongodb collections

[smuraliselvam]

Hi,

I try to join the two mongodb collections in Jaspersoft studio 6.3.0. It is not working..

I am using mongodb 3.2.6..

{
runCommand:
{
aggregate: [
    {
      $lookup:
        {
          from: "inventory",
          localField: "item",
          foreignField: "sku",
          as: "inventory_docs"
        }
   }
]
}}

 

Thanks,

Murali

 

[jon_23]

I'd really like to know if this is possible as well. Or any other work arounds. I know we can use sub-documents for this but in my table I need to join data from two collections. Many thanks.