Great. That works very nicely. Has anyone had success with paging the results by rowlimit using ListItemCollectionPosition? Struggling to find decent examples that don’t use a data table. The best preacgice example here - http://msdn.microsoft.com/en-us/library/bb687949.aspx#WorkingWithFoldersLists – looks straightforward enough but does not explain how to create controls to navigate between the row sets. I just want something very simple that just shows a prev "<<" and next ">>" link. Would the following be a step in the right direction? // Get our query items and current position SPListItemCollection listItems = oList.GetItems(oQuery); SPListItemCollectionPosition itemPos = listItems.ListItemCollectionPosition; int iPos = (oQuery.RowLimit * itemPos) + 1;
foreach (SPListItem listItem in listItems)
{
// Define previous and next links
string nextPage ="<a onclick=\"javascript:SubmitFormPost("" + oUrl +
"?Paged=TRUE&p_FileLeafRef=" +
listItem["FileLeafeRef"] + "&p_ID=" + pPos + "&PageFirstRow=" + iPos +
"");javascript:return false;\" href=\"javascript:\">>></a>";
string prevPage = ...
From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of
Paul Noone
Sent: Friday, 28 October 2011 8:30 AM
To: ozMOSS
Subject: RE: Filter item collection
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@01CC955C.BF509180]
<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:image003.jpg@01CC955C.BF509180]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: image003.jpg>>
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
