Re: [libreoffice-users] Table filter in Base
Hi Robert, On Sun, 2024-05-19 at 19:18 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > I can confirm that with my current LO 24.2.1.2 this is NOT the > > behaviour. Removing ANY ONE table in the Table Filter followed by > > Refresh Tables causes ALL Table to disappear, and the Table Filter > > thereafter shows none selected. It is only possible to regain a > > view on > > ALL tables by closing and reopening the database. It's ALL OR > > NOTHING. > > Try to rename the user folder of LO: > > /home/user/.config/libreoffice/4 ...doesn't work. I get locked out of the databases because the 'class' files cannot be loaded. Have renamed back again. > > > > > Will Leap 15.6 with bug fixes to 24.2.1.2. in early June have this > > problem sorted? > > No it doesen't appear. But it is the same version you use at this > moment. So the behavior is a special behavior of the constellation in > your system - not of LO, packed by SuSE. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Table filter in Base
Hi Harvey, I can confirm that with my current LO 24.2.1.2 this is NOT the behaviour. Removing ANY ONE table in the Table Filter followed by Refresh Tables causes ALL Table to disappear, and the Table Filter thereafter shows none selected. It is only possible to regain a view on ALL tables by closing and reopening the database. It's ALL OR NOTHING. Try to rename the user folder of LO: /home/user/.config/libreoffice/4 Will Leap 15.6 with bug fixes to 24.2.1.2. in early June have this problem sorted? No it doesen't appear. But it is the same version you use at this moment. So the behavior is a special behavior of the constellation in your system - not of LO, packed by SuSE. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Table filter in Base
Hi Robert, On Sun, 2024-05-19 at 09:15 +0200, Robert Großkopf wrote: > Hi Harvey, > > have tested with LO 24.2.3.2 on OpenSUSE (original packages from LO): > > Started > Tools → Table Filter > Marked "All views" → OK > Started > View → Refresh Tables > All tables and view could be seen, special "information_schema" and > the > database I have connected to. > > Could save this and reopen → same behavior. > > Then clicked in Tools → Table Filter on checkbox "information_schema" > to > unselect this tree. > Refreshing tables and "information_schema" couldn't be seen any more. > > Then clicked in Tools → Table Filter on checkbox for the database, > which > is shown now to unselect this table. > Refreshing tables and the table couldn't be seen any more. > I can confirm that with my current LO 24.2.1.2 this is NOT the behaviour. Removing ANY ONE table in the Table Filter followed by Refresh Tables causes ALL Table to disappear, and the Table Filter thereafter shows none selected. It is only possible to regain a view on ALL tables by closing and reopening the database. It's ALL OR NOTHING. Will Leap 15.6 with bug fixes to 24.2.1.2. in early June have this problem sorted? > With direct connection "information_schema" won't be shown, but all > databases I could connect to and input data. There it is indeed > impossible to unselect a whole database. "test" appears here, but I > could unselect all tables. > > A little bit tricky to get back the tables, because they will > disappear > in the direct connection if I have unselected them. I have to > unselect > the table and select the table afterwords to see all tables - which > are > all selected then. > > Seems to work better with JDBC than with direct connection. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Table filter in Base
Hi Harvey, have tested with LO 24.2.3.2 on OpenSUSE (original packages from LO): Started Tools → Table Filter Marked "All views" → OK Started View → Refresh Tables All tables and view could be seen, special "information_schema" and the database I have connected to. Could save this and reopen → same behavior. Then clicked in Tools → Table Filter on checkbox "information_schema" to unselect this tree. Refreshing tables and "information_schema" couldn't be seen any more. Then clicked in Tools → Table Filter on checkbox for the database, which is shown now to unselect this table. Refreshing tables and the table couldn't be seen any more. With direct connection "information_schema" won't be shown, but all databases I could connect to and input data. There it is indeed impossible to unselect a whole database. "test" appears here, but I could unselect all tables. A little bit tricky to get back the tables, because they will disappear in the direct connection if I have unselected them. I have to unselect the table and select the table afterwords to see all tables - which are all selected then. Seems to work better with JDBC than with direct connection. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Table filter in Base
The Table Filter in Base doesn't seem to work well in my configuration. I am running Base as frontend to a network server with mysql/mariadb containing several databases, connected via MySQL(JDBC) Logging in to the mysql server causes Base to show ALL the tables of these databases (including the mysql and performance_schema tables) in the Tables window. I supposed that I could limit the view to the database tables on which I am working at any time by applying the Table Filter (Tools > Table Filter). Unfortunately, the Table Filter causes only NO databases/tables AT ALL to be shown, and then ONLY AFTER closing Base and opening it again. So the option seems to be ALL or NONE, but certainly not selectively filtered tables. Is this behaviour a result of my network configuration or a fault in LOBase? Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded Cheers Harvey -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy