RE: Filter item collection

[Paul Noone]

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 =">>";

   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..




YourString



Additionally, You can also search multiple string in same query using , if 
you have exact strings. [cid:image001.png@01CC955C.BF509180]

   

  
  
 String1
 String2
 String3
 
  


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
<><>___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

RE: Filter item collection

[Paul Noone]

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..




 YourString



Additionally, You can also search multiple string in same query using , if 
you have exact strings. [cid:image001.png@01CC954B.C7D0FDB0]

   

  
  
 String1
 String2
 String3
 
  


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
<><>___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

Re: Filter item collection

[Salman Ahmad]

Hi Paul,

query something like this will work for you..




 YourString



Additionally, You can also search multiple string in same query using , if 
you have exact strings. 

   

  
 
 String1 
 String2 
 String3 
  
  


Cheers,


From: Ishai Sagi 
Sent: Wednesday, October 26, 2011 4:09 AM
To: ozMOSS 
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.

 

 

Ishai Sagi | Solutions Architect 
0488 789 786 | is...@exd.com.au | www.sharepoint-tips.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
w: http://www.ceosyd.catholic.edu.au/

 




___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
<><>___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss

RE: Filter item collection

[Ishai Sagi]

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.


[Description: Description: Description: C:\Users\Brian\Pictures\EXD 
Logos\Extelligent logo no text.jpg]Ishai Sagi | Solutions Architect
0488 789 786 | is...@exd.com.au | 
www.sharepoint-tips.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
w: http://www.ceosyd.catholic.edu.au/

<><>___
ozmoss mailing list
ozmoss@ozmoss.com
http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss