Error when using condition 'next-x-weeks' or -next-x-days

(0) Share

Report

Posted on by Community Member

Hi everyone!

I have this strange error. I'm using this code on my development server with CRM 2016 on premise.

var fetchXml =
			"<fetch version='1.0' aggregate='true' >" +
			"<entity name='serviceappointment' >" +
			"<filter type='and' >" +
			"<condition attribute='scheduledstart' operator='next-x-weeks' value='2' />" +
			"<condition attribute='siteid' operator='eq' value='" + siteIdText + "' />" +
			"</filter>" +
			"<attribute name='scheduleddurationminutes' alias='sumDuration' aggregate='sum' />" +
			"</entity>" +
			"</fetch>";

It works great.

I use the same fetcxhXML on the Dynamics CRM Online 2016 , and it popups an error. If i change the condition to 'this-month' or 'next-month' it works ok. It is having issues with the specific condition .

How can add a condition to check if the fetchxml will return none items ? Is there a way to check this scenario??

Any ideas whats going wrong ? It is very strange.

*This post is locked for comments

I have the same question (0)