Column Autocomplete Doesn't Work When Table Names In Parentheses

[Mitch]

Auto complete for column names does not appear to work when the table names are in parentheses.

 

For example `order` o and customer c in this:

 

— this is the base query that gives order ID, amount due, billing type and entity ID

SELECT o.stuff

    FROM (`order` o, customer c)

        LEFT JOIN partner p ON c.customerid = p.customerid

        LEFT JOIN order_transaction t ON o.orderid = t.orderid

    AND t.status = ‘approved’

    AND DATE(COALESCE(t.charged, t.addeddatetime,NOW())) <= '2016-04-05'     WHERE o.customerid = c.customerid     AND c.clientid=3     AND o.cancel_datetime IS NULL     GROUP BY o.orderid;  

[Sibin A S]

Hello Mitch,

 

We did try your query and the autocomplete did work perfectly at our side. Can you please tell us the particular point where the autocomplete does not work in the query if any? so that we could try to reproduce it.

 

Regards,

Sibin

[Mitch]

It is working for me now also.

[Author]

Posts