[Libreoffice-bugs] [Bug 133366] FILEOPEN: Base views not showing on remote mySQL database, direct connection

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133366

Claudio Romeo <registrazioni at claudioromeo.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|1                           |0
             Status|NEEDINFO                    |UNCONFIRMED

--- Comment #2 from Claudio Romeo <registrazioni at claudioromeo.it> ---
@Alex
> views are server-side stored objects with MariaDB/MySQL. They should be displayed in the Table list in LO.
Yes, my view is correctly listed as a table. Only when I try to open it (double
click or right click → open), the error occurs.
Please note that the view can be properly accessed by phpMyAdmin.
Also note that in LO I can modify the view. Just, I can't show it.

> When you say you created a view, how did you go about this ?
I simply used the LO Base procedure Create View (in Italian it's called Crea
Vista, but I don't know the original English name)
1. Click the Create View command
2. Select the table
3. Drag and drop two of the three fields into the grid (I excluded the primary
key field)
4. Set the order of one field as descending
5. Save

> Does your view require any specific parameter input ?
I don't think so. It only sorts the data according to the values of one column

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200529/c014ae09/attachment-0001.htm>