It was just a basic query. I played with different fields to order by and everything worked as expected. It's just that slight difference in the way it ordered the name.
I've now gone down the SPView path which works a treat. On 10 October 2012 14:30, Paul Turner <ptur...@smsmt.com> wrote: > What is the full CAML query?**** > > ** ** > > ** ** > > Regards**** > > **** > > *Paul Turner***** > > *Practice Lead - SharePoint***** > > *SMS Management & Technology***** > > * > **M 0412 748 168***** > > *paul.tur...@smsmt.com* <paul.tur...@smsmt.com>* ** > **www.smsmt.com* <http://www.smsmt.com/>* ***** > > *About SMS: Level 29, Westpac House, 91 King William Street, Adelaide SA > 5000** > **SMS Management & Technology (SMS) [ASX:SMX] is Australia's largest > publicly listed Management Services company. We solve complex problems and > transform business through Consulting, Technology and Systems Integration* > **** > > ** ** > > *From:* ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] *On > Behalf Of *Web Admin > *Sent:* Wednesday, 10 October 2012 11:39 AM > *To:* ozMOSS > *Subject:* Sort SPListItemCollection issue**** > > ** ** > > Hi all,**** > > ** ** > > I'm retrieving a list via spquery and using CAML OrderBy Name.**** > > ** ** > > The problem is that the sorted results don't match the list view which > also sorts by Name ascending.**** > > ** ** > > i.e.**** > > ** ** > > *CAML Result***** > > ** ** > > 1-1**** > > 1-2**** > > 1-3**** > > 1-1-1**** > > ** ** > > *List View***** > > ** ** > > 1-1**** > > 1-1-1**** > > 1-2**** > > 1-3**** > > ** ** > > I could always change the list item naming convention (undesirable) or > ditch the CAML and get the items by SPListView. But I'm more curious to > know why this is occurring and if there's an easy fix.**** > > ** ** > > Regards,**** > > ** ** > > Paul**** > > ------------------------------ > NOTICE - This communication is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking any action in reliance on, this communication by persons or entities > other than the intended recipient is prohibited. If you are not the > intended recipient of this communication please delete and destroy all > copies and telephone SMS Management & Technology on 1300 842 767 > immediately. Any views expressed in this Communication are those of the > individual sender, except where the sender specifically states them to be > the views of SMS Management & Technology. Except as required by law, SMS > Management & Technology does not represent, warrant and/or guarantee that > the integrity of this communication has been maintained nor that the > communication is free from errors, virus, interception or interference. > > _______________________________________________ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > > -- Regards, Paul Noone SharePoint Farm Admin/Developer Infrastructure Team CEO Sydney p: (02) 9568 8461 f: (02) 9568 8483 e: paul.no...@syd.catholic.edu.au w: http://www.ceosyd.catholic.edu.au/
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
