I have a view that contains an ORDER BY clause. Normally, when I access this view, for example, by
SELECT * from view;
it returns the rows in the order specified by the ORDER BY clause. However, when I right-click on the view in PG Lightning Admin and do a "Quick View Data", the rows come back in what appears to be random order. Is this supposed to work that way?
Turn off the sorting in the
Turn off the sorting in the grid. Right click on a column header and then select remove sort ( or similar).
The quick view data adds it's own order by column 1 if the object you are viewing is NOT a view. We did this for users coming from a non MVC system. For example, if you edit a row it will appear to disapear if the data was not generared witha order by. This is because the MVC deletes the edited row and puts a new copy with the changes at the end of the database.For the non PGSQL initiated the row would have seeemed to vanished.
I verfied that if you use the quick view data on a view it does not add a order by, but the grid does it's own sorting, so after youget the data remove the sorting like I mentioned above.