Hot answers tagged

29

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


15

Try using 1 for true, 0 for false. I was able to replicate your problem in SPO, but using 1/0 worked fine: /_api/web/lists/getbytitle('BtProjects')/items?$filter=Active eq 1


15

It does not seem possible to filter list items using FileSystemObjectType property in SharePoint 2013 REST. Option 1 But you could utilize the following REST query to return folders and associated list items: /_api/web/lists/Lists(guid'GUID')/rootFolder/Folders?$expand=ListItemAllFields JavaScript example var listTitle = "Documents"; var url = ...


14

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


9

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


8

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.


8

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


8

I can't really provide a sensible answer to why this is happening (I can confirm I'm experiencing the same weird behavior. I'm sure this is related to the fact that they cut out the designer part without properly thinking about the consequences this would have had). What I can offer is a dirty workaround that proved to be almost always working in my case. ...


7

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


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

Have you tried setting the DisableFilter property to true?


6

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


5

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


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


5

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()) { ...


5

How to retrieve document name using SharePoint REST Since FileRef contains file name, you could utilize the following query to return document names: Endpoint: /_api/web/lists/getByTitle('<list title>')/items?$select=FieldValuesAsText/FileRef&$expand=FieldValuesAsText Example Get documents (names) that have been created from 2014 year: ...


5

There are no other options as such. but you can use calculated columns as an alternate solution which will have most of the excel based features.


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

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


4

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


4

As indicated in the comment above, when the list has over 500 items for performance reasons some fields will not display the available values and display "Show Filter Choices" instead. If you wish you could try adding ?Filter=1 in the URL, which will show the available values by default. Not sure if it will work for you. If you are familiar and comfortable ...


4

Trick is to attach a JavaScript keyup event to the existing Searchbox for every ListItem (in this case above the Searchbox in the DOM, because events bubble up anyway) Each script can check against any content you can reference in a Calculated Column... that means no enumerables like Person fields or Multiple Select Choices. If you stuff it all in a ...


4

Simply showing a List/Library in batches or using group by still causes SharePoint to query for all records in that List/Library. Using a column index with a view and a filter based on the index is a requirement to stay under the LVT. And in this case, the filter must return less records than the LVT is set to (5K by default). If you were using SharePoint ...


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

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



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