xuyongweb commented 1 year ago

Title

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID where shipperId=2 and ((employeeId=4 and Orders.customerId=34) or (employeeId=4 and Orders.customerId=76)) order by orderid asc

Description

select({
    from: "Orders",
    order: {
        by: 'Orders.customerId',
        type: 'asc' //supprted sort type is - asc,desc
    },
    join: {
        with: "Customers",
        type: "left",
        on: "Orders.customerId=Customers.customerId",
        as: {
            customerId: 'cId'
        }
    },
    where: [{
            shipperId: 2,
        },
        [{
            employeeId: 4,
            customerId: 34,
        }, {
            or: {
                employeeId: 4,
                customerId: 76,
            }
        }]
    ]
})

xuyongweb commented 1 year ago

select Orders.* , Customers.customerId as cId from Orders left join Customers on Orders.customerId=Customers.customerId where Orders.shipperId = 2 and((Orders.employeeId=4 and Orders.customerId=34) or (Orders.employeeId=4 and Orders.customerId=76)) order by Orders.customerId asc

ujjwalguptaofficial commented 1 year ago

Fixed in v - 4.6.0 @xuyongweb have a look and let me know.

ujjwalguptaofficial commented 1 year ago

also updated idbstudio -

xuyongweb commented 1 year ago

ok，Thanks

ujjwalguptaofficial commented 1 year ago

I hope this issue is fixed, feel free to reopen if not.

ujjwalguptaofficial / JsStore

Federated queries are used with or queries, and the query data is incorrect #340

Title

Description