Created attachment 52649 [details]
On Ubuntu Oneiric with distrib provided LibO 3.4.3 :
Steps to reproduce :
1) Open the sample db provided.
2) Open the form.
3) Click on the Filter button, the Filter Navigator and Toolbar appear.
4) Try adding a filter criteria to the Filter Navigator window (left mouse button click or double-click topmost entry in Filter tree view)
Expected result :
User should be able to add/delete/modify filter criteria and then apply them.
Actual result :
Nothing happens. There is no possibility to add criteria.
As an alternative, if a criteria is added via the Form directly, then it becomes available in the Filter Navigator window - however, the user still can not add further criteria to the Filter Navigator window.
Same pb as 42120, there's an authentification.
Created attachment 52679 [details]
The first attachment I submitted was connected to a mysql db with
authentication, which of course was inaccessible for everyone else, my bad,
This file is a native hsqldb ODB. Use this one for testing instead. The results
are the same.
In navigator I select word "V Or", then place values into form, then palace cursor in another cell of form for apply last value. In Navigator appears result of this input. After this values in Navigator can be edited. New criteria also can be added.
When I place mouse cursor over Navigator, appears extended tooltip with explanation how to use. Works as explained.
Reproduced in 3.3.4 and 3.5.2 on Fedora 64 bit
Sorry if I misunderstand problem.
(In reply to comment #3)
> In navigator I select word "V Or", then place values into form, then palace
> cursor in another cell of form for apply last value. In Navigator appears
> result of this input. After this values in Navigator can be edited. New
> criteria also can be added.
> When I place mouse cursor over Navigator, appears extended tooltip with
> explanation how to use. Works as explained.
> Reproduced in 3.3.4 and 3.5.2 on Fedora 64 bit
> Sorry if I misunderstand problem.
I can not edit or add a new filter condition directly to the navigator without first having entered a condition in one of the fields of the FormFilter. If this is the expected behaviour, as indicated in the tooltip, then yes, that works.
However, when you do this, a new "Or" condition is created in the tree hierarchy of filter conditions. I can not edit this second condition directly, ie. by double-clicking on it, or by calling up its context menu, which only gives me the option to Delete (and which in fact does nothing).
So, the conclusion is that you can only edit a condition in the Filter Navigator
after you have entered a condition in the FormFilter for each and every field that you want to set a condition for.
Tested also on Mac OSX, same behaviour. Setting platform to All
Created attachment 60244 [details]
screenshot of formfilter navigator
This screenshot shows that an "Or" entry appears in the tree view which suggests it can be clicked or in some way manipulated to allow the user to set a new FormFilter criteria, however this is not the case.
May be in context menu for this "Or" (or all Navigator) should appear something like "Edit filter". After choosing it will appear "Standard filter" like in "Table Data View" in Base, or Data->Filter->Standard filter in Calc. It would be great improvement for Base usability.
Thanks for new idea
Adding self to CC if not already on