Yes, you're absolutely right. I revisited the query using CAML Query Builder and came to the horrifying realisation that the Name/FileLeafRef field is not available for filtering. :S
On 11 October 2012 09:29, Ishai Sagi <[email protected]> wrote: > It’s usually a problem with the query’s xml. But glad you worked around > it.**** > > ** ** > > ** ** > > **[image: Description: Description: C:\Users\Brian\Pictures\EXD > Logos\Extelligent logo no text.jpg]***Ishai Sagi* | Solutions Architect > 0488 789 786 | [email protected] | www.sharepoint-tips.com | > @ishaisagi<http://twitter.com/ishaisagi> > | MVP Profile <https://mvp.support.microsoft.com/profile/Ishai> **** > > ** ** > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Web Admin > *Sent:* Wednesday, 10 October 2012 14:57 > *To:* ozMOSS > *Subject:* Re: Sort SPListItemCollection issue**** > > ** ** > > 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 <[email protected]> wrote:**** > > What is the full CAML query?**** > > **** > > **** > > Regards**** > > **** > > *Paul Turner***** > > *Practice Lead - SharePoint***** > > *SMS Management & Technology***** > > * > **M 0412 748 168***** > > *[email protected]* <[email protected]>* ** > **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:* [email protected] [mailto:[email protected]] *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 > [email protected] > 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: [email protected] > w: http://www.ceosyd.catholic.edu.au/**** > > ** ** > > _______________________________________________ > ozmoss mailing list > [email protected] > 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: [email protected] w: http://www.ceosyd.catholic.edu.au/
<<image002.jpg>>
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
