Hot answers tagged filter
9
In addition to your "Deactivated" field, create a Calculated field named "ActiveTitle" (or whatever you want to call it). Use the following formula:
=IF(Deactivated,"",Title)
The ActiveTitle field will be empty when the Deactivated field is set. When you configure your lookup column, tell it to use the value from ActiveTitle instead of Title. Empty values ...
6
You can filter list by using CAML and DaysOffset attribute of the Today tag. This can be done even from GUI.
For example, this filter will narrow the shown items of a list view to those, which have Due date within a week from the current date:
(List Tools => List => Modify view on the contextual ribbon)
In terms of CAML, this will produce the following ...
5
Codeplex - SharePoint Filtered Lookup Field
This project creates a custom SharePoint lookup field that offers new
functionalities to default SharePoint lookup field by allowing filters
to be applied to retrieved data. Applied filters can be either dynamic
CAML queries or pre-defined list views residing in source lists
...
4
Based on your last comment
I create a webpart to show the
Document List on a certain page, and
then I applied a filter on a column
content to show only certain
documents. But in that way the folder
structure is lost and all documents
are shown flat.
I think I can answer your your question now.
If you create a new view and select in the ...
4
Thanks, guys, I'm already create paging and sorting with BCS. In my case BCS works fine with WCF services.
At first I'm develop web service with follow contract:
[OperationContract]
IEnumerable<Employee> GetEmployeesPaged(int startRowNumber, int pageCount, string sortColumn, string sortDir);
then I'm created BDC definition with Read List Method for ...
4
To filter a person group column by the current logged in user, use column equals [me].
Edit to add:
Using equals when a person/group column accepts multiple people still filters properly from my experience. If you are listed individually, you see the item. If you are one of 3 people listed, you see the item. The UI might be saying equals but my theory is ...
4
It is possible to accomplish with OOTB Metadata Navigation and Filtering Feature using Navigation hierarchies control.
Navigation hierarchies control allows to select an item in a hierarchy for a managed metadata column with filter for
single Term
Term with descendant child terms
Applying filter in Navigation hierarchies control corresponds to ...
4
SharePoint List Filter web part is rendered as input text field for displaying filter value:
<input type="text" readonly="readonly" id="{ClientID}_SpListPicker_SelectionBox" title="Selected values" >
and input hidden field for storing filter value:
<input type="hidden" id="{ClientID}_SpListPicker_Selection" value="{FilterValue}">
Below ...
3
You will need three Filters all with ORs between them:
[Field] contains
[Field] contains <div></div>
[Field] contains <div> </div>
Here is a screenshot to make this a little more obvious:
In the image above Answer is a Multiple lines of text field allowing Rich text
UPDATE:
For Multiline plain text fields just doing ...
3
What I have found is that if Sharepoint is set to (UTC) Greenwich Mean Time but the servers are set to (UTC) Coordinated Time instead of (UTC) Dublin, Edinburgh, Lisbon, London. Then the Key Filters displays the correct result. It is almost as though GMT + Our Daylight Saving Time is throwing it 2 hours out instead of 1. Cheers Ross
3
The filter that worked for my library view... to show only "ABC" related folders and documents is shown below. Remember that SharePoint appears to be unix-based in that things are case-sensitive, so where "Folder" worked in the below filter, "folder" did not. Also note that, since most users who are creating folders don't apply categories, I used the "Name ...
3
If you filter manually, you'll see that the URL changes, e.g. to something like
http://server/site/Lists/Links/AllItems.aspx?FilterField1=DocumentID&FilterValue1=650
So if you pass the parameters FilterField1 and FilterValue1 accordingly, it should work.
3
I did something similar to this. What I had was a list, Department Contact, under each Department site. It was just a custom list that I saved as a list template (easy to recreate across all departments).
I then created a Data View Web Part in Designer that linked to the list. Admittedly, I used a table format for the output because it's just easier (I ...
3
To simply add filter to default view of existing list you can use:
$web = Get-SPWeb -Identity "http://mysamplesite"
$list = $web.GetList("http://mysamplesite/Lists/mysamplelist")
$query = "<Where><Eq><FieldRef Name='MyField' /><Value Type='Text'>MyFilterValue</Value></Eq></Where>"
$view = $list.DefaultView;
...
3
This article, by Phil Wicklund, is an article I always go back to that suits your requirements. It uses a dataview web part and a form web part to do wild card searching of the DVWP content. It's geared towards 2007, but the principles apply to 2010.
2
If you created the view in code you will need to specify the Scope="Recursive" ViewAttribute
Some examples are given here
http://sharepointmagazine.net/technical/development/writing-caml-queries-for-retrieving-list-items-from-a-sharepoint-list
If you created the views with the SharePoint UI you will need to
Modify the view.
Expand the "Folders" section ...
2
I can confirm it doesnt look like taxonomy field made it to filter web parts. I think its called an ISV opportunity ;-)
Maybe its somehow related to my queston:
http://www.sharepointoverflow.com/questions/4416/taxonomy-field-doesnt-always-show-up-in-cqwp-filter
2
You could use different scenarios :
Apply security on a series of list depending on the AD Group they are in
Apply "By Item" security on a single list by adding an event handler by code, and with some logic, apply the good group to the item
Adding a column that would be the department, and filter the list by that column
Using this solution to edit the ...
2
One 3rd party tool (no connection) that will do this is Roxority FilterZen. They have a free 'lite' version.
http://roxority.com/sharepoint-zen/sharepoint-list-filtering-by-user-group-membership.html
2
Yes, you can. You need to create them on the External Content type, through SharePoint Designer. Edit your Read List method - and when you configure your Filters Parameters add the filters you need. You should be able to add many filters.
When configuring the filters, make sure you check the "Use to create match list in external item picker".
You should ...
2
What about item level permissions on the master list? Usually I discourage this, but here it could be a good solution. Set up the list so that by default a new item gives no one in the clients permission to view. Then set the permissions for each new item to allow only the proper client to see it. (You could use a workflow to assist with the process.)
Using ...
2
If you want to stay in the UI, you could try a method similar to @theChrisKent but use 5 filters instead and for each filter do a contains for a, e, i, o, u. This would obviously assume that any input in the fields would contain a word (including a vowel). See screen shot below.
A second approach would be to create a view in the library and then use ...
2
You list the main options. Depending on how complex the requirement, and what development resources you have, it is often easier to build a custom web part (or parts) than jump through hoops to get the OOB web parts to do what you want. I would recommend a web part rather than a custom application page, as the former is a more flexible solution and keeps ...
2
You could create a view (either manually or programmatically), and then get a reference to this SPView, and call RenderAsHtml() on it. This renders like an SPGridView (which is what you want).
Alternatively, you could use an SPDataSource. You can then bind this SPDataSource to an SPGridView. This can be done declaratively with ASPX/ASCX markup only.
Let me ...
2
I wouldn't use either Designer or InfoPath; instead, I would use a Content Editor Web Part along with a jQuery script to format the data the way you want it on the page.
The steps would be:
Add the jQuery script library (file) to a document library on your SharePoint site. jQuery can be downloaded here.
Add a Content Editor Web Part to your page
Set the ...
2
Yes you can use CAML:
http://abstractspaces.wordpress.com/2008/05/05/caml-query-lookup-field-by-id-not-by-value/
or you can use this:
http://filteredlookup.codeplex.com/
or
How to make a filtered lookup field
2
Yes, it is possible but it is kind of a hack.
Step 1: Make your filter values pretty
For this, you'll need to create a class inheriting from SPGridView and override the GetCallbackResult function:
public class SPFilterGridView : SPGridView
{
protected override string GetCallbackResult()
{
string result = base.GetCallbackResult();
// do ...
2
Sounds like search might be a good option. Maybe create a special search page (could be the view page) where you:
Add a search box
Add a core results web part where you:
set site:UrlOfList as additional query parameters
set xslt to render with the information you want
And then teach users about Keyword query syntax
2
Try to use this caml:
<Where>
<Eq>
<FieldRef Name="Author" LookupId="True" />
<Value Type="User">123</Value>
</Eq>
</Where>
this also might work, but first is preferable:
<Where>
<Eq>
<FieldRef Name="Author" LookupId="True" />
<Value Type="Lookup">123</Value>
...
Only top voted, non community-wiki answers of a minimum length are eligible
