Hot answers tagged

30

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 = "/_api/...


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":


9

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


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


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 http://filteredlookup....


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


6

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: /_api/...


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

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

I am going to cover a few things as I don't know exactly what you're doing here. Create a calculated column to display the first letter of your field using formula - lets call this "FirstLetter" =LEFT([YourFieldName],1) Optionally, you can then use the Group By feature to show a collapsed/expanded list on [FirstLetter] - (see "The By Last Name View" here ...


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

You are missing ID in expand. The query should look like: _api/Web/Lists(guid'id')/items?$select=Id,Author/ID&$expand=Author/ID&$filter=(Author/ID eq 21)


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

If you have a SharePoint task list where the task is assigned to a SharePoint group, you may notice that the My Task list does not show tasks even if you are a member of the group of which the task is assigned. Fortunately, there is a simple fix. It does require SharePoint Designer though. Open SharePoint Designer and then open the My Tasks view of the ...


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.



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