sql query can not check array methods properly
I'm not able to check if an array element contains two attributes that match a certain condtion.
If I have a document with an array of elements, where each element has two attributes I only want to select documents that have an element wich has attribute1 = a and attribute 2 = b. The current query matches any element having that value. I know how to query that in mongo shell but I can not do it in SQL with the current syntax.
1
vote
Anonymous
shared this idea