Thanks guys. The initial idea was to create a new library for each “album” but this seemed like overkill given that I added a web part to the feature. @ishai I was planning on running it against the Name field for each item in the foreach loop. ☺ The query sounds a lot more efficient. Now to add my asset picker to avoid all the issues with incorrect list names. ☺ From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Salman Ahmad Sent: Wednesday, 26 October 2011 5:09 PM To: ozMOSS Subject: Re: Filter item collection
Hi Paul, query something like this will work for you.. <Where> <Contains> <FieldRef Name="Title" /> <Value Type="Text">YourString</Value> </Contains> </Where> Additionally, You can also search multiple string in same query using <In>, if you have exact strings. [cid:image001.png@01CC954B.C7D0FDB0] <Where> <In> <FieldRef Name='Title' /> <Values> <Value Type = 'Text'>String1</Value> <Value Type = 'Text'>String2</Value> <Value Type = 'Text'>String3</Value> </Values> </In> </Where> Cheers, From: Ishai Sagi<mailto:is...@exd.com.au> Sent: Wednesday, October 26, 2011 4:09 AM To: ozMOSS<mailto:ozmoss@ozmoss.com> Subject: RE: Filter item collection Startswith is something you do on a string, not on a collection. To properly (and efficiently) get items with a certain criteria from a list, you should do a query on the list. The query can then have a “BeginsWith” or “Contains” filter parameter (see http://msdn.microsoft.com/en-us/library/ms467521.aspx for all parameters you can specify) so you can get a collection of only the items that answer the filter criteria. [cid:image002.jpg@01CC954B.C7D0FDB0]Ishai Sagi | Solutions Architect 0488 789 786 | is...@exd.com.au<mailto:is...@exd.com.au> | www.sharepoint-tips.com<http://www.sharepoint-tips.com/> | @ishaisagi<http://twitter.com/ishaisagi> From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Wednesday, 26 October 2011 10:57 AM To: ozMOSS (ozmoss@ozmoss.com) Subject: Filter item collection Hi all, I want to filter an SPListItemCollection based on a provided string in the item Name. Can I do this using string StartsWith, or should I run an SPQuery against the collection? Kind regards, Paul Noone --------------------------------------------------- Online Developer/SharePoint Administrator Infrastructure Team, ICT Catholic Education Office, Sydney p: (02) 9568 8461 f: (02) 9568 8483 e: paul.no...@ceosyd.catholic.edu.au<mailto:paul.no...@ceosyd.catholic.edu.au> w: http://www.ceosyd.catholic.edu.au/ ________________________________ _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com<mailto:ozmoss@ozmoss.com> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
<<inline: image001.png>>
<<inline: image002.jpg>>
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss