View Single Post
  #2  
Old 04-05-2007, 11:44 AM
quant's Avatar
quant quant is online now
Registered User
 
Join Date: 11-30-2006
Posts: 967
Whatever sort you do, it's either date sorting or value or alphabetical sorting (irrespective of the attribute name) ... with it's comparison operator and predefined behaviour for undefined values. For date, you can see that undefined date is less that any defined date. Similar for values, any number is bigger that the undefined one ...

With this in mind, you can understand what results you get and can accommodate your searches accordingly (for example excluding those where this column is not defined, logically it's not an appointment you should see in the seach), or set some default values. For example, you could set in your template default appointment date to 1/1/2100, so that those with 'unset' value would go to the end ...
Reply With Quote