Kinook Software Forums

Go Back   Kinook Software Forums > Ultra Recall > [UR] General Discussion

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 09-06-2010, 05:21 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Data Explorer Sorting Anomaly

On the Data Explorer pane, sorting will fail after the 2nd period. For example:
2010.07.01
2010.01.03
2010.03.01
2010.07.05
2010.09.07
2010.10.02
2010.02.03
2010.03.05

The sorting works fine for the months but fails for the days, regardless manual or automatic.
Armstrong
Reply With Quote
  #2  
Old 09-06-2010, 07:40 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
you're right, that's strange
Reply With Quote
  #3  
Old 09-06-2010, 07:45 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Quote:
Originally posted by quant
you're right, that's strange
Quant,
Thanks for your confirmation. I discovered it by accident while creating a timeline using yyyy.mm.dd as the item title.
Armstrong
Reply With Quote
  #4  
Old 09-06-2010, 01:24 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,752
Download the attached file, extract and double-click DisableSortDateNumericInTree.reg, and restart UR.
Attached Files
File Type: zip reg.zip (589 Bytes, 604 views)
Reply With Quote
  #5  
Old 09-06-2010, 05:37 PM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Quote:
Originally posted by kinook
Download the attached file, extract and double-click DisableSortDateNumericInTree.reg, and restart UR.
Hi Kinook,
Thanks for your fast help. Yes, your solution works brilliantly.
May I know the technical effects of EnableSortDateNumericInTree.reg and DisableSortDateNumericInTree.reg? That's, uf Date Numeric Tree is disabled, how would affect sorting of other item titles?

2010.09.10, for example, is just like any text string. Why does UR treat it as a date?

Thank you.
Reply With Quote
  #6  
Old 09-07-2010, 06:54 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,752
If the sort option is enabled (default behavior), when sorting in the tree, UR first attempts to convert the values to dates (using the Windows VarDateFromBstr API) and performs a date comparison if conversion succeeds, otherwise it converts the values to numbers and performs a numeric sort if the values look like numbers.

If the sort option is disabled, or the above fails, a regular string comparison is used (using lstrcmp).
Reply With Quote
  #7  
Old 09-07-2010, 08:29 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Kinook,
Thanks for the enlightenment. The itching question here: how could UR discern the various date formats around the world?
yyyy.mm.dd
mm/dd/yyyy
dd/mm/yy
...etc.

I thought all item titles are assumed char string data type.
In UR, it turns out to be a data data type.

Thanks for allowing us to know more the technical details of the UR.
Reply With Quote
  #8  
Old 09-07-2010, 09:00 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 5,752
UR doesn't -- Windows does, based on the date settings in Regional and Language options in the Control Panel.
Reply With Quote
  #9  
Old 09-07-2010, 09:11 AM
armsys armsys is online now
Registered User
 
Join Date: 12-19-2007
Posts: 647
Thanks.
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 03:10 PM.


Copyright 1999-2019 Kinook Software, Inc.