Created attachment 62683 [details] Composite screenshot of bug I am trying to use LibreOffice for household food inventory and price reckoning. I have a spreadsheet (via Calc) with the primary data in it, which I have imported into a database table (via Base). When I create a query using the Query Wizard in Base, which SHOULD filter the table so that e.g. only Dairy items show, it instead returns ALL RECORDS in the entire table. I am fairly certain that I am creating the query correctly. Can someone cue me into what is wrong? (Honestly, I hope it's a PEBCAK error.) I have attached a composite screenshot of the issue.
OK, obviously you folks don't care much about bugfixes. This has been open for something like two and a half weeks, and no attention has yet been given. I'll just go find another office suite, hopefully one that *works*. Congratulations on "resolving" a bug by losing a customer.
(In reply to comment #1) > OK, obviously you folks don't care much about bugfixes. This has been open for > something like two and a half weeks, and no attention has yet been given. > > I'll just go find another office suite, hopefully one that *works*. > Congratulations on "resolving" a bug by losing a customer. Did you pay for the use of this software ? If not, then you are not a customer, merely a user, and an obviously dissatisfied one. Nonetheless, you are not a customer. If you did pay for it then, you have been done, LibreOffice is free (both as in beer, and in the rights conveyed in the software), and you should take your quibble up with whoever managed to con you into spending money to download and install it. Now, as a user of a free (as in monetarily free) and volunteer driven project, you might feel disgruntled at a certain functionality not working. However, that gives you absolutely no right to demand that any problem be solved in any sort of time frame. You could express your desire for it to be done, you might even be able to help resolve the problem (if there is actually a problem), but that is about as far as your demands can go. If you had read up on the bug submission process, you would have noticed that most reports require a step by step detailed instruction of how to reproduce the behaviour you consider buggy. In addition, a sample file, or at least a script enabling the database to be reproduced, and the query used, would be more than helpful. You have done neither of these things, yet are content to gripe at the alleged slowness of the bug triaging process. Even paid-up software with a telephone help desk system would require more information than you have given in order to even attempt to help you. Alex
The image you have posted is of such low resolution that I can not usefully read any of the details, even when I zoom in. Additionally, if you seriously want anyone to look at the problem you have, please provide us with a sample database and detailed steps to reproduce the problem. Alex
Created attachment 63644 [details] Our food inventory This is our inventory. Yes, we have a lot of food.
I didn't think I'd get an answer! (and I'm honestly surprised that I did.) For the record, it's been 24 days or so since I first submitted this -- three weeks, three days. Hmmm... maybe you folks might consider a support forum as well as the buglist? Just sayin'. BTW, I only knew about the response because Bugzilla sent me like four emails all at once with the different changes. I've uploaded our database. It is created from a spreadsheet, courtesy of instructions in an online article that I've since lost. The operation goes like this, to create the database... (1) Select all cells in the spreadsheet (CTRL+A) (2) Run LO Base. In the "tables" screen, right click in an empty area, and select "Paste". (3) Accept the default values and settings in the Table Creation Wizard Thingy that pops up. (4) There is no step 4, it's done. According to what I recall of the article, that should allow full database functionality to the contents of the spreadsheet. If you folks want, I can upload the spreadsheet at some point. In order to generate a query, I use the Query Wizard (I'm not smart enough to make it in design view!). "Type of Food" gets set to "Dairy". Sort by the "Key" field, ascending. Those are the only things I set. If it works, I'll be amazed. It gives me a SQL Syntax Error no matter what the heck I do. I will also mention that I've got like five or six different Java installs, because they don't uninstall the old one when the new one's stuck in there. Not sure what gives with that, but it occurs to me that this might be causing a problem somehow.
Created attachment 64132 [details] Query-wizard in 3 versions of LO: correct only in LO 3.3.4 There is a bug in the wizard of LO. In LO 3.3.4 it works. The table is filtered by the term you wish. Then I tried this with LO 3.5.5 and LO 3.6.0 Beta 3 - there was only shown the whole table, no condition for filtering the values.
I will change the Status to "New" and the bug-title, because queries work right in LO 3.5 and other versions, but not the filter in the wizard for queries.
Then, having seen that, I will work for now in LO 3.3.4. When a patch is made for a current version (which right now is probably a future version) I will switch to something newer. Thank you both for your help so far. I hope a patch can be made. Alas, I can but test it -- I am by no means a programmer of any substance!
(In reply to comment #8) > Then, having seen that, I will work for now in LO 3.3.4. When a patch is made > for a current version (which right now is probably a future version) I will > switch to something newer. Yes, that is probably the best course, and is why I still keep a 3.3.4 version here on my Mac. However, there have been bugfixes in Base during 3.5 development that relate to bugs in the 3.3.x and 3.4.x development lines. I suppose it always boils down to what you can/can't live with. > > Thank you both for your help so far. I hope a patch can be made. Alas, I can > but test it -- I am by no means a programmer of any substance! Don't worry about that, I'm not a developer either, but we can all help in some way - thanks for your input ! Alex
Hi Lionel, Assigning to you, could you take a look ? Seems like we lost the ability to filter via the Query Wizard somewhere during 3.4.x/3.5.x development. Alex
Editing title to be more specific Filtered queries work in general, just not when they are created via the Query Wizard. Alex
Reproduced in my dev tree
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ede56437f9641cad698b97b2dd14b0c1c37dfcce fdo#50800 populate composedCommandNames ASAP, not at call of getFromClause
Hey, how big is that patch? I tried to download it but it didn't finish -- my Internet connection is a little tenuous (not dialup though, thankfully!).
(In reply to comment #14) > Hey, how big is that patch? Less than 4kB.
That's odd. The file on the patch-page, core-ede56437f9641cad698b97b2dd14b0c1c37dfcce.zip, is a LOT bigger, over 100mb. How can I download and apply JUST the patch? or do I need the whole tamale that's in the *.zip mentioned above?
(In reply to comment #16) > That's odd. The file on the patch-page, > core-ede56437f9641cad698b97b2dd14b0c1c37dfcce.zip, is a LOT bigger, over 100mb. That's the whole sources. > How can I download and apply JUST the patch? I assume you already have the full LibreOffice sources, and know how to build. In the absence of further information, I also assume a Unixy environment. Click on "patch" in parentheses on the line: commit ede56437f9641cad698b97b2dd14b0c1c37dfcc (patch) (side-by-side diff) 1) Save that as /some/file/name 2) cd /where/you/put/the/libreoffice/sources 3) patch -p1 < /some/file/name 4) make && make install
Sadly, no. Windows XP service pack 3, and no sources -- nor the proper environment for compiling them (or the knowledge to do so). I am by NO means a capable programmer! My ONLY programming experience is in QBASIC of all things -- I wrote a horribly-designed parserless text adventure (it's almost literally more if-then statements than it is anything else!) in that language, ONCE. I decided after that, that I'd done enough. Then again... TBH, if you gave me bonehead-proof step-by-step instructions for compiling, in Windows (as noted above), with the patch, AND it isn't terribly hard or complex... I might be able to do it. But if there are ANY errors in compiling, I'm not going to know how to handle them! I hope my ASUS netbook can handle it... Atom N270 CPU, 2gb RAM (I upgraded it).
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6a7c0710cc063912d912cc95b10415bc717a241f&g=libreoffice-3-6 fdo#50800 populate composedCommandNames ASAP, not at call of getFromClause It will be available in LibreOffice 3.6.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-3-5": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c5b6a945e898ded83613afefbedef71372665b13&g=libreoffice-3-5 fdo#50800 populate composedCommandNames ASAP, not at call of getFromClause It will be available in LibreOffice 3.5.6.
Great, thanks! I'll poke you guys again if the patch doesn't work (although I have every expectation that it will). Looking forward to trying it out.