Monthly archives: April, 2017

SharePoint 2013 OData $filter seems broken with date functions

I am using SP2013 SP1. I am trying to perform the following OData opertaion from a client app that contains an External Content Type. The ECT points to a ASP.Net OData service. My Javascript code in the app makes a query call and the url looks like this: xxx/_api/web/lists/getByTitle('People‘)/items?$filter=month(BirthDate)%20eq%201%20and%20day(BirthDate)%20eq%206 I am saying get the People …

How to hide a WebPart from Specific users in SharePoint

I have a Content Editor WebPart Where Audience Targetting is set to all users.But I need to hide it from Few groups. Problem is These groups are part of NTAuthority/all user group.Please suggest something how to go ahead with this. =================      Did you consider aggregating all these groups and users into one SharePoint …

Sharepoint 2013 Development Boundaries

I need some understanding around SharePoint 2013 Development model. What are SharePoint 2013 Development Boundaries? What SharePoint developer can and cant do with each model? =================      Make sure you’ve read this on limits and boundaries as well: technet.microsoft.com/en-us/library/cc262787(v=office.15).as‌​px – Alexey Krasheninnikov Jan 28 ’15 at 8:03      Looks like your question body doesn’t …

List.getItems(query) returning too many results [duplicate]

This question already has an answer here: CAML query returns all items instead of one 2 answers I have the below sample CAML query that I built using the SPCAMLQueryHelper: 2014-12-29T00:00:00+02:00 2015-02-01T23:59:59+02:00 When I test the query in the query helper, I get the expected results (the items that are in the date range). However, …

Join 3 lists using JoinView

This is regarding SharePoint 2007, I have 3 list in a site called “A”, “B”, “C”. I have combined this 3 lists in one and created a new list called “D” using SharePoint Designer 2007. Now showed the List “D” fields or data on webpart in designer but it’s not coming up as I expected. …

Getting error while copying contents from one library to another

I am using below script to iterate through each folder/file in document library. $source = “sitecollection/sites/site/subsite” $dest = “sitecollection/sites/site/subsitearchive” $sourceLibrary = (Get-SPWeb $source).Folders[“Test”] $destLibrary = (Get-SPWeb $dest).Folders[“Test”] $destFiles = $destLibrary.Files foreach ($file in $sourceLibrary.Files) { $curFile = $file.OpenBinary() $destURL = $destFiles.Folder.Url + “/” + $file.Name $destFiles.Add($destURL, $curFile, $true) } However, I am getting error: Cannot …

Show more columns in content query Sharepoint 2013

How do I set the number of columns shown by content query which retrieves data form a list? It only shows the Content column and I’d like it to show the Rating column too. ================= ================= 2 Answers 2 ================= In SharePoint 2013 for adding new Fields you should modify the ItemStyle.xsl. This file is …

SQL Database ‘Project_Content’ on SQL Server instance ‘XXX’ not found – after removing project server

I keep getting this error in event viewer. I reckon project server was installed before on the farm and it has been removed but it seems its still looking for the content database see error below SQL Database ‘Project_Content’ on SQL Server instance ‘XXX’ not found. Additional error information from SQL Server is included below. …