Tag Info

Hot answers tagged

13

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


7

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


7

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


6

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


6

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


5

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


5

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

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.


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

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


3

You will need three Filters all with ORs between them: [Field] contains [Field] contains <div></div> [Field] contains <div>&nbsp;</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

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


3

I can confirm it doesn't look like taxonomy field made it to filter web parts. I think its called an ISV opportunity ;-) Maybe its somehow related to my question: Taxonomy field doesnt always show up in CQWP filter


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

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.


3

We were finally able to resolve the issue. In short - to work you need to change the way how OOTB Filter code works to way that it thinks that it is operating with SPFieldLookup. To achieve this you need 3 steps. 1.Create copy of Filter.aspx file located from Sharepoint Root Directory. This aspx is responsible for rendering items in filter view. 2. ...


3

Applying such complicated filter just isn't possible from UI. However, you can do it e.g. from SharePoint Designer or Powershell. From SharePoint Designer: Open your site in SharePoint Designer Go to Lists and Libraries Select your list There is "Views" section to the right. Find your view there and click on it. Code editor will be shown. Find ...


3

You can create/modify a view and apply the filter on the start date. To create/modify a view, go to list settings-> Scroll down to bottom and you will see a section named Views. Here you can click on exiting view or create a new view. In the view you can filter based on the start date in the Filter Section. UPDATE Based on your update in the question. This ...


2

Forget about any third party tools. I was able to handle this very problem by modifying the sql call in the WCF service and using filtering that's built in to the BCS via SharePoint Designer. I've blogged about it here. http://www.spcrew.com/blogs/Lists/Posts/Post.aspx?ID=47 Here are the basic steps: Create a Method in WCF Service to call the database ...


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

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

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

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

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

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



Only top voted, non community-wiki answers of a minimum length are eligible