<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:registrazioni@claudioromeo.it" title="Claudio Romeo <registrazioni@claudioromeo.it>"> <span class="fn">Claudio Romeo</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN: Base views not showing on remote mySQL database, direct connection"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133366">bug 133366</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN: Base views not showing on remote mySQL database, direct connection"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133366#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN: Base views not showing on remote mySQL database, direct connection"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133366">bug 133366</a>
from <span class="vcard"><a class="email" href="mailto:registrazioni@claudioromeo.it" title="Claudio Romeo <registrazioni@claudioromeo.it>"> <span class="fn">Claudio Romeo</span></a>
</span></b>
<pre>@Alex
<span class="quote">> views are server-side stored objects with MariaDB/MySQL. They should be displayed in the Table list in LO.</span >
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.
<span class="quote">> When you say you created a view, how did you go about this ?</span >
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
<span class="quote">> Does your view require any specific parameter input ?</span >
I don't think so. It only sorts the data according to the values of one column</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>