Bug 42126 - Base UI functionality request: Add ability to edit/add/delete/modify criteria in Database Form filter navigator like in "Standard filter"
Summary: Base UI functionality request: Add ability to edit/add/delete/modify criteria...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Base-Enhancements
  Show dependency treegraph
 
Reported: 2011-10-23 05:36 UTC by Alex Thurgood
Modified: 2018-10-02 04:10 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
test db (9.46 KB, application/vnd.oasis.opendocument.database)
2011-10-23 05:36 UTC, Alex Thurgood
Details
testdb2 (10.46 KB, application/vnd.oasis.opendocument.database)
2011-10-24 01:19 UTC, Alex Thurgood
Details
screenshot of formfilter navigator (87.96 KB, image/png)
2012-04-18 04:21 UTC, Alex Thurgood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2011-10-23 05:36:30 UTC
Created attachment 52649 [details]
test db

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.


Alex
Comment 1 Julien Nabet 2011-10-23 14:18:50 UTC
Hi Alex,

Same pb as 42120, there's an authentification.

Julien.
Comment 2 Alex Thurgood 2011-10-24 01:19:53 UTC
Created attachment 52679 [details]
testdb2

The first attachment I submitted was connected to a mysql db with
authentication, which of course was inaccessible for everyone else, my bad,
sorry.

This file is a native hsqldb ODB. Use this one for testing instead. The results
are the same.

Alex
Comment 3 sasha.libreoffice 2012-04-16 09:51:28 UTC
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.
Comment 4 Alex Thurgood 2012-04-18 04:14:44 UTC
(In reply to comment #3)

Hi,

> 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.


Alex
Comment 5 Alex Thurgood 2012-04-18 04:15:27 UTC
Tested also on Mac OSX, same behaviour. Setting platform to All

Alex
Comment 6 Alex Thurgood 2012-04-18 04:21:26 UTC
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.
Comment 7 sasha.libreoffice 2012-04-18 05:35:23 UTC
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
Comment 8 Alex Thurgood 2015-01-03 17:39:44 UTC Comment hidden (no-value)