Author: Nishant Rana

above and under were the 2 new operators introduced with Dynamic CRM 2015.

Let us see some of the examples.

Suppose I have the following hierarchy defined, wherein User 2 is manager of user Nishant Rana who in turn is manager of User 1.

And following are the contacts record owned by them.

In context of user Nishant Rana, if I apply Under operator, we’d get the following result

Only the records owned by child

And for Not Under

All the records owned by the user and its manager(s) or parent.

Now we do not have the Above operator in Advanced Find

So, using our favorite tool Fetch XML Builder, the above operator shows only the records owned by the parent(s) of current user.

We also have Above or equal, Under or equal operator which aren’t there in Advanced Find.

Hope it helps..

Today afternoon we started getting the below error in the lookup dialog box for customer and contact.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: A quick find filter cannot have any child filtersDetail:

<OrganizationServiceFault xmlns:i=”http://www.w3.org/2001/XMLSchema-instance&#8221; xmlns=”http://schemas.microsoft.com/xrm/2011/Contracts”&gt;

<ActivityId>a5d85309-b57b-4265-b54e-afd09bfeeddc</ActivityId>

<ErrorCode>-2147217118</ErrorCode>

<ErrorDetails xmlns:d2p1=”http://schemas.datacontract.org/2004/07/System.Collections.Generic”&gt;

<KeyValuePairOfstringanyType>

<d2p1:key>ApiExceptionSourceKey</d2p1:key>

<d2p1:value xmlns:d4p1=”http://www.w3.org/2001/XMLSchema&#8221; i:type=”d4p1:string”>Plugin/Microsoft.Crm.Common.ObjectModel.AccountService</d2p1:value>

</KeyValuePairOfstringanyType>

<KeyValuePairOfstringanyType>

Searching for this in the internet we found that mostly the users that are in Microsoft Dynamics 365Version 1710 (9.1.0.643) online are getting this error.

We as suggested raised the support ticket for this in the evening. However strangely enough after 2-3 hours when we are checking this error it is not coming anymore.

We had created one trial instance which was also having the same issue and it has been fixed there. It looks like product team have deployed some kind of fix for it in the background.

Hope it helps..

Sharing a sample code that can be used to delete the instance in Dynamics 365 CE using Online Admin API.

Read the previous post for more details

We basically need to get the instace id and use the HTTP Delete to achieve this

https://docs.microsoft.com/en-in/rest/api/admin.services.crm.dynamics.com/Instances/DeleteInstance

Production instance needs to be converted to Sandbox before it can be deleted else we’d get the operation not supported error.

The sample code :-

private static void Main(string[] args)
{
var authContext = new AuthenticationContext(Authority, false);
var credentials = new UserCredential(UserName, Password);

// Get the token
_authResult = authContext.AcquireToken(Resource, ClientId, credentials);

Task.WaitAll(Task.Run(async () => await DeleteInstance()));
}
private static async Task DeleteInstance()
{
var httpClient = new HttpClient
{
BaseAddress = new Uri(Resource),
Timeout = new TimeSpan(0, 2, 0)
};

httpClient.DefaultRequestHeaders.Add("OData-MaxVersion", "4.0");
httpClient.DefaultRequestHeaders.Add("OData-Version", "4.0");
httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer",
_authResult.AccessToken);

var retrieveResponse =
await httpClient.DeleteAsync("/api/v1.1/Instances/{instanceGuid}/Delete");

if (retrieveResponse.IsSuccessStatusCode)
{
var jRetrieveResponse =
retrieveResponse.Content.ReadAsStringAsync().Result;

}
}

Hope it helps..