Hi Anu, > order by $first, $second > > as per my understanding it will first order on $first putting > the blank elements at the end and then it will again re sort > the list on $second where $first values are same. so finally > result will be order by $second as it will overwrite the > order of $first.
You could say: order by $first empty least, $second empty least > What i am looking for is order by if first element available, > if not then order by $second. Means conditional order by > output should be same as output of order by single element. > both results should be same. Are you aware that the order by can take expressions? I am not sure it solves your problem, but it should be possible to do something like this: order by (if ($first) then $first else $second) empty least Kind regards, Geert Drs. G.P.H. Josten Consultant http://www.daidalos.nl/ Daidalos BV Source of Innovation Hoekeindsehof 1-4 2665 JZ Bleiswijk Tel.: +31 (0) 10 850 1200 Fax: +31 (0) 10 850 1199 http://www.daidalos.nl/ KvK 27164984 De informatie - verzonden in of met dit emailbericht - is afkomstig van Daidalos BV en is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht onbedoeld hebt ontvangen, verzoeken wij u het te verwijderen. Aan dit bericht kunnen geen rechten worden ontleend. _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
