Multiple ORs failing

[JasminDreasond]

I'm trying to make something like it:

Select * from Table_Name where Column1=value1 and (Column2=value2 or Column2=value3 or Column2=value4);

if(Column1 === value1 && (Column2 === value2 || Column2 === value3 || Column2 === value4))
  return true;

EDIT: I have a value of a message to receive that already has the values of which Room belongs, but I'm adding another condition that this value also needs to vary between 3 responses of the same string input.

But that always fails, returning an array without my result

reference to test:
https://ujjwalguptaofficial.github.io/idbstudio/?db=Demo&query=select(%7B%0A%20%20%20%20from%3A%20%22Customers%22%2C%0A%20%20%20%20where%3A%20%5B%7B%0A%20%20%20%20%20%20%20%20or%3A%20%5B%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20country%3A%20'USA'%0A%20%20%20%20%20%20%20%20%7D%2C%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20country%3A%20'Mexico'%0A%20%20%20%20%20%20%20%20%7D%2C%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20country%3A%20'Brazil'%0A%20%20%20%20%20%20%20%20%7D%5D%0A%20%20%20%20%7D%5D%0A%7D)%3B

[ujjwalguptaofficial]

It's giving me results -

[JasminDreasond]

this is the results of London without the other countries. I need the Brazil, USA, Mexico in the results too.

[JasminDreasond]

I don't know if I should post it on issues. This was to theoretically perform exactly what I commented above. I have a value of a message to receive that already has the values of which Room belongs, but I'm adding another condition that this value also needs to vary between 3 responses of the same string input.

Everything works normally when I put only one extra condition value, but when I try to put multiple ORs, everything fails.
My explanation above is a realistic simulation of what I'm trying to do.

[JasminDreasond]

Forget about London, I updated the URL above to get easier because I realized that the example wasn't going to work properly.
Sorry for the incorrect example, I was posting 4:00 am and I was very tired from the work where I found the possible glitch.

[ujjwalguptaofficial]

I will have a look and provide resolution ASAP.

…

On Sat, 30 Nov, 2024, 6:22 am Yasmin Seidel, ***@***.***> wrote: Forget about London, I updated the URL above to get easier because I realized that the example wasn't going to work properly. — Reply to this email directly, view it on GitHub <#387 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACTOR56JRP6JL7475SFHMQD2DED3DAVCNFSM6AAAAABSWL4MM6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNBRHE3DQNY> . You are receiving this because you commented.Message ID: ***@***.*** .com>

[ujjwalguptaofficial]

What you want is this -

select({
    from: "Customers",
    where: [{
        city: 'London',
    }, {
        or: {
            country: 'USA'
        },
    }, {
        or: {
            country: 'Mexico'
        }
    }, {
        or: {
            country: 'Brazil'
        }
    }]
});

https://ujjwalguptaofficial.github.io/idbstudio/?db=Demo&query=select(%7B%0A%20%20%20%20from%3A%20%22Customers%22%2C%0A%20%20%20%20where%3A%20%5B%7B%0A%20%20%20%20%20%20%20%20city%3A%20'London'%2C%0A%20%20%20%20%7D%2C%20%7B%0A%20%20%20%20%20%20%20%20or%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20country%3A%20'USA'%0A%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%7D%2C%20%7B%0A%20%20%20%20%20%20%20%20or%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20country%3A%20'Mexico'%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%2C%20%7B%0A%20%20%20%20%20%20%20%20or%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20country%3A%20'Brazil'%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%5D%0A%7D)%3B

[ujjwalguptaofficial]

each curly braces represent and and if you want to do or, explicityly use or

[JasminDreasond]

That's the old url. I updated the discussion topic, adding more extra details to help you understand better the subject.

[JasminDreasond]

i think you better go on Github to see the answers because i edited some posts to fix my messages.

[ujjwalguptaofficial]

@JasminDreasond I have rectified your query in the above link. There was issue in how you were querying. Please check the new one.

[ujjwalguptaofficial]

It's different link than yours.

[ujjwalguptaofficial]

If you just want all or's condition without the city:'london', then here is equivalent query -

select({
    from: "Customers",
    where: [{
        or: {
            country: 'USA'
        },
    }, {
        or: {
            country: 'Mexico'
        }
    }, {
        or: {
            country: 'Brazil'
        }
    }]
});

[JasminDreasond]

The test failed. I really received the values of the variety of 3 options, but the conditions of the first "and" were totally ignored, making all the messages of all the rooms to be received at the same time. The "or" conditions needs to respect the first "and" condition.

[JasminDreasond]

The where value reference:

[
  {
    "room_id": "...",
    "redaction": false,
    "is_transaction": false
  },
  {
    "or": {
      "member_type": "join"
    }
  },
  {
    "or": {
      "member_type": "leave"
    }
  },
  {
    "or": {
      "member_type": "invite"
    }
  }
]

[ujjwalguptaofficial]

The query is wrong as per your expectation. If in first query the condition fails and or condition satisfies then data is counted as valid.

You are writing -

if(roomid && redaction && is_transaction) or (member_type=join) or (member_type=leave) or member_type = invite

I hope this makes sense.

If you want to return data only when those three column satisfy then you need to use and query with member_type value also.

[
  {
    "room_id": "...",
    "redaction": false,
    "is_transaction": false,
    "member_type" :{"in":["join","leave","invite"]}
  },
]

[JasminDreasond]

yep. now really made sense and worked properly. thank you! 🥳
I thought "In" was just to use in value searches inside arrays

i just have one last question now before closing the discussion definitely:
if instead of being "member_type", it's two different columns to use something like "In"?

• Example: the search fail to find the value in member_type then I will look in the member_type_2

[ujjwalguptaofficial]

yes you can use any column with in similarly.

[JasminDreasond]

that's not it. I'm saying something like it:

if(room_id === value && (member_type === value2 || member_type_2 === value2))