New answers tagged

0

You can use filter WebPart for multiple filters.When you want to filter between two dates then you need to use SP Designer to pass parameters.And for by default functionality SP only provide Choice filter WebPart not any specific to dropdown. Find the screenshot below I used to filters Choice filter and Text filter and applied both.The two filter are ...


1

I found the solution - In the List View set the following filters: Filters: a) Modified - Less than or Equal to - [Today] b) Publish Date - Less than or Equal to - [Today] c) Publish - Begins with - Yes Sort by Modified (Descending) Item Limit = 1


0

Why don't you use a content search web part and set it to return only 1 item and the sort can be on modified desc.


0

NVM. Found I can just filter on if the column Compliance is blank. Please find clarification. I went to Edit the View in my list. Within the View settings there is a Filter Setting. I set the filter to the Compliance column to show items that "is not equal to" and left the bottom text box blank.


0

Please look this site http://blog.hametbenoit.info/Lists/Posts/Post.aspx?ID=584 (not my :), but I have that issue too.


0

If you're still trying to figure out the problem with AuthorID i believe it is referenced as Author/ID here's a snippet of the parameters I use on my code for pulling up the tasks: var params = { URL:"/_api/Web/Lists/GetByTitle('tasks')/Items" , params:{ 1:1 , $select:[ 'Id' ,'Title' ...


0

this is what worked for me: _api/web/lists/getbytitle('LISTNAME')/Items?$orderby=Created desc&$filter=FSObjType+eq+1 FileSystemObjectType seems not to work


1

Install the OData Query Builder available (for free) in the App Store https://store.office.com/odata-querybuilder-WA104051159.aspx?assetid=WA104051159


2

You're writing it wrong. You need to use $filter= to filter results.


3

At least I typed my own text LOL In the Filter settings of a View you can only use [Today] as is, you can do simple +- calculations but you can not use Functions. So you need to add two Calculated Columns calculating january1st =DATE(Year([YourDate),1,1) and december31st =DATE(Year([YourDate),12,13) and then compare in your View Filter if [Today] ...


1

You can try this workaround: 1) Create a calculated column StartYear = DATE(YEAR([your date field]),1,1) 2) Create a calculated column EndYear = DATE(YEAR([Expiry Date]),12,31) 3) Create a View and Filter: StartYear is Less Than or Equal to [TODAY] AND EndYear is Greater Than Equal To [TODAY] Source.


1

You will need to use some workaround as mentioned below. 1) Create two calculated columns Start Year and End Year 2) Start Year = DATE(YEAR([Expiry Date]),1,1) 3) End Year = DATE(YEAR([Expiry Date]),12,31) 4) Create a View and Filter Condition will be Start Year is Less Than or Equal to [TODAY] AND End Year is Greater Than Equal To [TODAY]


2

Folders are also counted as Items and as such filter rules also apply to them. Since the folder does not have the user on the column it is not showing it to them. What you can do is add another filter (using OR) and set the logic to show content type Folder. This means it will show ALL folders as well as all items that have the user = Work Allocated


0

[Me] and [Today] are the only dynamic filters available for list views. [Me] works when trying to dynamically filter on person/group fields based on the current user. [Today] works when trying to dynamically filter on date fields based on the current date.


0

You have several options here. You can have your Farm Admin's Change the List View threshold which I wouldn't recommend but see the link below for something that may help you filter that data more easily. https://blogs.technet.microsoft.com/quentin/2014/07/15/the-list-view-threshold-stop-dont-change-it/


-1

These are few commands which can be used for a SharePoint calculated column in the list. Probably, the same can be used for applying filters because i have used same [Today] or [Me] in the filter which i have used for Calculated columns as well. Check which will suit you requirement. Get Week of the year =DATE(YEAR([Start Time]),MONTH([Start ...


0

The OOTB parameters list is pretty small. You can create your own parameters if needed using SharePoint Designer. This will get you started. http://www.ilikesharepoint.de/2013/01/sharepoint-2010-passing-parameter-values-into-listitem-forms/


0

You can accomplish this by using parameterbinding on your calender view: Open the page in SharePoint designer and edit your pages that contains the calender webpart. Add two parameterbindings for your columns like:<ParameterBinding Name="mycustomcol1" /> Save your page. Go to SharePoint, edit the page Add query string filter webpart Connect the ...


0

If I correctly understand what you need, then you can do the following using OOTB feature from UI: Create your two custom columns Modify the default view for the calendar Add two filters based on your custom columns


0

This was used at the end of the page, just passed the piece of Javascript. <div class="portfolioFilter text-center" > <a href="#" style="display:none;" data-filter=".fakeCategory" id="Fake" class="current"><img src="../SiteAssets/all.jpg"/></a> <xsl:call-template name="dvt_1"/> ...


0

You can use decode URI component to remove all characters added in the URL and retrieve query string values JSRequest.EnsureSetup(); var q = JSRequest.QueryString["ProcessName"]; decodeURIComponent(q); Above code will provide you Query String values with Spaces as you have provided for redirection Below image is screenshot of page containing list view ...


1

No, if you put HTML inside a Calculated Column (and set the datatype to anything but single-line of text to output the HTML) the bare HTML code itself will be displayed in the filter choices. Only in the View is the HTML code not escaped; it will appear as bare HTML on Forms, in Alert emails and more places. A way too complex workaround is to add ...



Top 50 recent answers are included