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


8

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


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

Have you tried setting the DisableFilter property to true?


6

Or "Content Type" is equal to "Folder":


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

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

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

I solved same problem by dynamicaly setting permissions on list items in event receiver. But this solution is not scalable at all. I will recomend create Folders with unique security assignments and view for all items without folders.


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

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

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

Your OR clause must be done first. Try Department = "Sales" OR Department = "Marketing" AND EmployeeActive=true


3

Simply order the view as you have it by Created, descending order, and limit the number of items returned to 1 and you should have the desired affect.


3

Use SPGridView or SPListViewByQuery instead of SPView. http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.webcontrols.listviewbyquery.aspx.


3

No that'll be three clauses in the filter


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

Per Jakobsen has a very nice solution. You don't need to "muck up" anything, Chris! The only thing I have to add is to show how the REST url can be automated. Look at this: var date = new Date(), //or some relevant date filterFormat = "$filter={0} gt datetime'{1}'", filterQuery = String.format(filterFormat, "Created", date.toISOString()), url = ...


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


3

To query any person or group field against logged in user you can use **<UserID/>** tag in Value. if (!Page.IsPostBack) { using (SPSite mySite = new SPSite(SPContext.Current.Web.Url)) { using (SPWeb myWeb = mySite.OpenWeb()) { ...



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