Tag Info

Hot answers tagged

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

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


5

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


3

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


3

To the best of my knowledge the REST API does not support OData filters on null date values. There is an MSDN forums post with someone having the same issue and a member of the SharePoint team mentions that it is a known issue and they are working on it. The current implementation of REST does not support null values for filtering on list item ...


3

The new page added in layouts folder "inplview.aspx". When paging, sorting or filtering happens there is an AJAX call to the inplview.aspx and it returns a JSON based result set. That is the rows of the defined list view webpart. The "inplview.aspx" generates the "inplviewhash" tag and appends it with "#" in url.


3

Since CSR is the default rendering mode in SharePoint 2013, I would recommend the following approach to manipulate form fields in New/Edit Form page. As an introductory please follow this article Introduction to Client Side Rendering in SharePoint 2013. Suppose a Tasks list that contains a Task Category lookup field. Then the following rendering template ...


2

Use the following approach 1.) Create a visual webpart 2.) First add the following on the .ascx page Code for .ascx page <SharePoint:ListViewByQuery runat="server" ID="customlistview" /> 3.)Add the following code to query your list(assuming you have created the site and web objects) Code for .ascx.cs page SPList list = ...


2

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)


2

Use the date value like EndTime le datetime'2013-06-12' Note: You may need to use ListData.svc if you are on SP 2013. I started with turning on Team Collaboration Lists feature on my publishing site and creating the Calendar list. Then I have got my REST endpoint, this time around with a "greater than or equal to" filter: ...


2

Okay, I solved it. And you can't tell me it doesn't work, because I can see it with my own eyes :) So, that javascript you are running from that guy is unecessary, and it makes things more difficult that they should be. So you have three columns. One column has the status, one column determines the color, and the final column has the div tags. And it's ...


2

I found the answer to my problem. By default, grouped lists are set to be collapsed. If you change this to expanded by default, the list filters as expected. Another wonderful hidden feature of SharePoint maybe?


2

Use double quotes to find exact phrases. If you want to learn about "AD.300" and don't want a bunch of results that include documents that include the word. This tells the search engine to find the exact phrase inside the quotes. Look about more nice tips about search ...


2

You just need to do it the other way round. Make it: Approval Status is equal to rejected OR Approval Status is equal to pending AND Created by is equal to [Me] which gives you (a OR b) and c.


2

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


2

Try this https://mysite.com/site/_api/web/lists/GetByTitle('Posts')/items?$filter=Alert eq 1


1

You need to define a list view with a filter on the "claim completed" field. Create a new view or edit an existing view. Scroll down to the Filter section. In the dropdown "Show the items when column" select the "Claim completed" column. in the next dropdown select "is equal to" in the text box below type "no" Save the view. The view will now show ...


1

I'm assuming you're talking about using the FilterField and FilterValue query string parameters: You can filter on fields that are not displayed in the dataview. I would actually probably make a seperate querystring parameter for your data view in SP Designer, then you can use an OR condition in the list filter and not make any new fields (you also avoid ...


1

You can make use of Calculated columns, create your column 'TitleDescription' with 'Calculated Column' as type and use the below formula to concat the Title and Description, =[Title]&[Description] The above code will concat the two column value. EDIT: Calculated columns in SharePoint 2010 are similar to formulas in Excel spread sheet. Their result ...


1

I fixed it by removing the "multiple values" check! Who knew?


1

There are two ways: Create a view where you filter for the value of the last modified field, and compare it to the value of [today-7]. Create a view with calculated column with filter =[Modified]+7, and its return type is DateTime, which will returns the documents changed within the last 7 days more information on creating view and filter is here ...


1

Okay, this is a very verbose answer, only because I cannot think of another way around this. I will try to answer this as easily as I possibly can (no offense to you, I don't mean to make it sound like I am trying to speak down to you, it just involves a lot of steps that involve arguments that will be different for me as they are for you. To answer your ...


1

I have created a similar solution that is done using Client side scriping (jQuery), it hides all the rows initially and shows them based on options selected. You may get some idea from this solution. Please have a look at jQuery - Filtering SharePoint lists


1

One option you have is to implement filtering in the client side. I have done this in one of my implementation, i used to pass the values from a page using Query string and on the list view page i had another script to read the values and display only matching rows. Check jQuery Filters


1

Have you tried using [today]-180?


1

Try to $expand the field, as well as $select it, like this: ?$select=*,Access/Id&$expand=Access/Id&$filter=Access/Id+eq+null


1

There is no way OOTB to have a column filter behave like the one you have in Excel. As you already noticed, the SharePoint filter is an exact-match type of filter. There is a workaround though, which involves creating a parameter on the XsltListViewWebPart and adding either a text filter webpart or a textbox input control on the same page where the XLVWP ...


1

There is no need to use $expand operator if you don't need to return the projected fields. The following REST endpoint demonstrates how to filter by Author Id: /_api/Web/Lists/getByTitle('Tasks')/items?$filter=(AuthorId eq 12)


1

Create a new view for your list (either from SPDesigner or the browser UI) and make it the default. Now, in SPDesigner, go to Lists and Libraries > your list > Views > Right click on the new view and Edit file in advanced mode. In Split mode, hover the mouse over the first EmployeeID field value, then click right before it and enter some dummy text (see ...


1

The reason why they are disabled is because the rich text fields contains html formatting, and will by default always be wrapped inside two hidden div tags and making the functions useless.



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