How to use the intersect query ?

[CHAWLU]

Hi All,

I am trying to use intersect in the typescript code but I am getting an error.
To use intersect, I created 2 queries and added them as parameters to the intersect query. But it does not work for me. Kindly suggest what needs to be done here. PFB the code:

Error: Argument of type '{ queries: Promise<{}[]>[]; }' is not assignable to parameter of type 'SelectQuery[]'.
Object literal may only specify known properties, and 'queries' does not exist in type 'SelectQuery[]'.

const queryProd1 = connection.select({
from: "Contents",
where: {
productName: "Bread"
}
});

const queryProd2 = connection.select({
  from: "Contents",
  where: {
    productType: "Bakes"
  }
});

var results = connection.intersect({
  queries:[queryProd1,queryProd2]    

})

[ujjwalguptaofficial]

You just need to specify the query not results like this -

var query1=  {
    from: 'Products',
    where: {
        price: {
            '>': 10
        }
    }
};
var query2 = {
    from: 'Products',
    where: {
        price: {
            '>': 50
        }
    }
};
var results = await connection.intersect({
    queries:[query1,query2]    
})

[ujjwalguptaofficial]

worker or without worker both should work - the problem is with the query not connection

[CHAWLU]

PFA the screenshots.

[ujjwalguptaofficial]

convert array into any and issue should be gone -

{
  queries: [qry1,qry2] as any
}

Let me know if it works

[CHAWLU]

Sorry, this did not work. I am still getting this error :
Argument of type '{ queries: any; }' is not assignable to parameter of type 'SelectQuery[]'.
Object literal may only specify known properties, and 'queries' does not exist in type 'SelectQuery[]'.

[ujjwalguptaofficial]

Hey Usha - drop me a message at my linked in : https://www.linkedin.com/in/ujjwalkrgupta/ - We can get on a call and then fix this.