RQLQueryRange does not sort dates correctly
by Frank Kim on Nov.20, 2009, under Page Development
(Photo: Roppongi District Desktop by powerbooktrance)
This was bedeviling me for awhile. I could not figure out why my RQLQueryRange droplet was not sorting by dates correctly. It turns out this is a known ATG bug which only happens when you are using Oracle, which is 99% of the time.
Considering that this bug has been open since 2003 one can assume ATG is not interested in fixing it. This is probably because there is a simple work around.
Instead of using the sortProperties parameter, put the the sort directive directly in the RQL statement in the queryRQL parameter.
<dsp:param name="queryRQL" value="ALL ORDER BY creationDate DESC"/>
Related posts:
-
Innovate!
betweenGo is a web solutions provider, specializing in Ruby on Rails and ATG enabled solutions.
If you're interested in becoming a betweenGo client, please contact us.
Please feel free to join the discussion by leaving comments and stay updated by subscribing to the RSS feed.
You can also follow us on Twitter.
You can also subscribe by email by filling the field below:
