and operator in where clause

[AnouarMc]

Hi I have a table that looks like this:

I want to execute this query:

SELECT * FROM dates WHERE due != "" AND due <= "2022-09-20"

So that I can get "2022-09-20" and "2022-09-19"

when I execute this code:

await window.JS.select({ from: "words", where: { due: { "<=": "2022-09-20" }, due: { "!=": "" } } });

I get "2022-09-21" , "2022-09-20" and "2022-09-19"

If I changed the order inside the WHERE like this:

await window.JS.select({ from: "words", where: { due: { "!=": "" }, due: { "<=": "2022-09-20" } } });

I get "2022-09-20" , "2022-09-19" and "" (empty string)

How can I achieve the above query?

Thanks

[ujjwalguptaofficial]

your date value is stored as string, so you won't be able to compare it with another date.

or do you want to string comparision only ?

if yes - then use array query for querying multiple value with same property. take a look at some query example - https://jsstore.net/tutorial/adv-sql-example/

[AnouarMc]

Thank you for your quick response.

Yes, I want only string comparison I store dates in "yyyy-MM-dd" format so even string comparison gives the intended results in SQL.

How can I achieve this:

SELECT * FROM dates WHERE due != "" AND due <= "2022-09-20"

I could not find in the provided link an example of a query on same the column

[ujjwalguptaofficial]

@AnouarMc here is equivalent query -

connection.select({
    from: "Table_Name",
    where: [
        {
            due:  { "!=": "" }
        },
        {
            due: { "<=": "2022-09-20" }
        }
    ]
});

the trick is to use array to specify multiple query.

[AnouarMc]

Thanks a lot. that what I was looking for. 👍