Sorting

[Fred Bone]

On 16 January 2010 at 15:53, Derek Atkins said:

> Colin Law <clanlaw at googlemail.com> writes:
> 
> > 2010/1/16 Derek Atkins <warlord at mit.edu>:
> >> Daniel Richard <drichard58 at gmail.com> writes:
> >>
> >>> I deleting the number like you suggested, but it didn't change
> >>> anything.  Since the numbers go 100, 101, 102, 103, 104, 110, 111,
> >>> 112, 105, 106, 107, ...., I even created a new entry and typed in 105
> >>> as the number.  Instead of placing it after 104 in the list, it put
> >>> it right after the existing 105.
> >>
> >> That would be correct behavior..  If you have two items with the same
> >> number they will get sorted together, but the date you enter the
> >> transaction will then take precedence.  So the #105 you enter on
> >> January 10 will appear after the #105 entered in December of last year.
> >
> > I think the OP means that with the new 105 added and with it sorted by
> > num he now sees (in this order) 100, 101, 102, 103, 104, 110, 111, 112,
> > 105, 105, 106, 107, .... which in one sense is correct insertion of the
> > new 105, but this would be equally 'correct' 100, 101, 102, 103, 104,
> > 105, 110, 111, 112, 105, 106, 107, .... In fact neither of them is
> > correct of course. Very strange.
> 
> Strange Indeed.
> 
> The code effectively does:
> 
> gncQuerySetSortOrder( query, split_trans->trans_num, standard_sort, NULL)
> 
> You might want to try turning on QOF Query debugging (assuming there's a
> debug level for qof query) and seeing what it's doing.
> 
> Can you create a small test file that doesn't sort correctly and then file
> a bug report and upload the data file?

PMFJI - here's one. New file (took all defaults in new-file druid), four 
transactions crediting Checking Account and debiting Cash In Wallet, 
numbered 001234, 001235, 001237 and 001238. Sort on "Num" puts 001238 
first.

Gnucash 2.2.9 on WinXPPro-SP3.

-------------- next part --------------
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  test
     Date:  17 Jan 2010, 19:26
     Size:  3911 bytes.
     Type:  Unknown
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test
Type: application/octet-stream
Size: 3911 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100117/a9d328c0/attachment.obj>