Sorting

[Daniel Richard]

On Saturday 16 January 2010 02:53:42 pm Derek Atkins wrote:
> 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?
> 
> > Colin
> 
> -derek
> 
> 
Sorry - new to all this so I am not sure how to turn on the de-bugging.  However, I was able to create a new, clean file and duplicate the error.  I am attaching the file here and will also post a bug report with the file.  Thanks for the help.

-------------- next part --------------

[Top]
BookGuid=260044b82a44770c29501e89c9c45ded
WindowCount=1

[Window 1]
PageCount=2
FirstPage=1
PageOrder=2;1;
WindowPosition=12;0;
WindowGeometry=1422;821;
WindowMaximized=false
ToolbarVisible=true
SummarybarVisible=true
StatusbarVisible=true

[Page 1]
PageType=GncPluginPageAccountTree
PageName=Accounts
AccountTypes=-1
ShowHidden=false
ShowZeroTotal=true
SelectedAccount=Bank Accounts:Checking Account
OpenAccount1=Assets
OpenAccount2=Bank Accounts
NumberOfOpenAccounts=2

[Page 2]
PageType=GncPluginPageRegister
PageName=Checking Account
RegisterType=Account
AccountName=Bank Accounts:Checking Account
RegisterStyle=Ledger
DoubleLineMode=false
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test
Type: application/x-gzip
Size: 4534 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100117/0c66b7b1/attachment.tgz>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.20100117133256.log
Type: text/x-log
Size: 192 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100117/0c66b7b1/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.20100117132852.log
Type: text/x-log
Size: 340 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100117/0c66b7b1/attachment-0001.bin>