GnuCash
Contact   Instructions
Bug 797185 - [transaction association window] sorting by column
Summary: [transaction association window] sorting by column
Status: RESOLVED FIXED
Alias: None
Product: GnuCash
Classification: Unclassified
Component: User Interface General (show other bugs)
Version: 3.5
Hardware: PC All
: Normal enhancement
Target Milestone: ---
Assignee: ui
QA Contact: ui
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-09 04:48 EDT by Jannick
Modified: 2020-06-08 11:42 EDT (History)
5 users (show)

See Also:


Attachments

Description Jannick 2019-04-09 04:48:24 EDT
It would be great if the list of transaction associated files could be sorted by clicking on any of the headers (date, description, association, available?, relative) in ascending/descending order.

Currently there is a button to sort file associations. But I am unable to figure out which order is applied to the column. (This might be influenced by blanks in the head path, see #797183 for a bug report on Windows).
Comment 1 Jannick 2019-04-09 04:52:10 EDT
Reference to bug 797183 did not come through in comment 1.
Comment 2 Bob 2019-04-12 09:53:49 EDT
I have pushed a fix and will be in the next nightly if you could try that would be great.

I am still undecided about the other columns being sortable but am still working in that area so we will see.
Comment 3 Jannick 2019-04-13 07:28:36 EDT
Thanks! After installing nightly gnucash-3.5-2019-04-13-git-3.5-27-g0f6465ca6+.setup.exe:

(In reply to Bob from comment #2)
> I have pushed a fix and will be in the next nightly if you could try that
> would be great.

Sorting by file association works nicely with your fix.

> I am still undecided about the other columns being sortable but am still
> working in that area so we will see.

From my point of view the sorting feature for each column would be helpful. It would enable the user to adjust the view on the data to his needs, in particular when plenty of files are associated to transactions.

Please see bug 797183 where I'll collect further comments on the nice association window.
Comment 4 Bob 2019-04-14 05:01:54 EDT
Additional points/issues I encountered working with the useful association window:

1 - When opening the association window, column 'avaliable?' says 'unknown' for each association, while - in my case - for some of the lines 'relative' shows TRUE. 

2 - Hitting then button 'locate association' makes GC check if each file association exists - not the highlighted one only as suggested by the button text.

3 - To update a (probably not existing) file path, the user currently needs to jump to the transaction window, then change the file path there. When going back to the association window, there is currently no refresh feature. So the user needs to close the window and open the association window again to check if the changes made are fine.

4 - the text of button 'Close' is not translated when I am opening GC with the German locale (de_DE).
Below text moved from Bug 797183 as this is already an enhancement bug...

Some additional suggestions to enhance the usability of this report:

a - populate the column 'available?' upon opening the association window.

b - if 'relative' is set to TRUE, couldn't the relative file path be displayed? (I am currently not sure how the user could use this info.)

c - change the button text 'locate association' to 'locate associations' or apply the location procedure to the highlighted row(s) only. See d.

d - c could benefit if multiple lines could be selected.

e - add a button 'refresh' to retrieve the data for the table again and update it.

f - add a button - or another event - to update the file path from the association window.

g - the text of button 'close' should be captured by translations.

h - add the sorting feature for every column (from bug 797185 to collect things in one single list / ticket).

Very happy to test.  Many thanks!
Comment 5 Bob 2019-04-14 05:06:34 EDT
My cut and paste seems got confused, all the above text is from bug 797183.
Comment 6 Bob 2020-05-31 05:48:25 EDT
I think most if not all items here have been fixed and will be in 4.0.
Comment 7 Jannick 2020-06-08 11:42:19 EDT
Bob, great - many thanks for working on this.  I am testing things using the nightly version gnucash-3.904-2020-06-08-git-3.904-1-gb5aeca94b+.setup.exe.

Thanks again for the implemented improvements!
J.

Note You need to log in before you can comment on or make changes to this bug.