Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Multiple values on list view column filtering by URL

  Asked By: Colt    Date: Apr 02    Category: Sharepoint    Views: 5233

Does anyone know if there is a way to filter by multiple values for one
column in a list view by URL?

I have the current URL format:

http://server/list/Forms/AllItems.aspx?View=" target="_blank" rel="nofollow">http://server/list/Forms/AllItems.aspx?View={LISTID}
&FilterField1=Activity&FilterValue1=Design

which will obviously filter the "Activity" column by the value "Design".

I would like to introduce an OR statement into here so that I can
filter by "Design" or "Build" for example.

http://server/list/Forms/AllItems.aspx?View=" target="_blank" rel="nofollow">http://server/list/Forms/AllItems.aspx?View={LISTID}
&FilterField1=Activity&FilterValue1=Design OR FilterValue1=Build

Any ideas?

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Nick Johnson     Answered On: Sep 18

Try this...

<Where>
<Or>
<Eq>
<FieldRef Name="ID" />
<Value Type="Integer">1</Value>
</Eq>
<Eq>
<FieldRef Name="ID" />
<Value Type="Integer">2</Value>
</Eq>
</Or>
</Where>

 
Answer #2    Answered By: Sharepoint Engine     Answered On: Sep 18

I did a work-around:

Created another computed value field and used it to wrap the ID field with quotes. I use this to filter with instead of the ID field.

 
Didn't find what you were looking for? Find more on Multiple values on list view column filtering by URL Or get search suggestion and latest updates.




Tagged: