Author: Carl

Visual Studio Snippets

In Visual Studio, code snippets are available to help with development. To use code snippets, open a Visual Studio project. Type CTRL-K then X. You will see below: You can also enter shortcut keys. For example, enter ctor and tab twice to have a constructor created: Result: Entering class and tab twice will create a class: Other often used code snippets such as try/catch, loops, etc follow the same tab … Continue reading Visual Studio Snippets

Dynamics CRM Generic SQL Error

One way a generic SQL error can occur is when dealing with ConditionOperator in QueryExpression. Consider the following code to get all users who’s first name is Bob:  QueryExpression userquery = new QueryExpression(); userquery.EntityName = “systemuser”; ColumnSet cols = new ColumnSet(); cols.AddColumn(“systemuserid”); userquery.ColumnSet = cols; ConditionExpression ce = new ConditionExpression(); ce.AttributeName = “firstname”; ce.Operator = ConditionOperator.Contains; ce.Values.Add(“Bob”); FilterExpression filter1 = new FilterExpression(); filter1.Conditions.Add(ce); userquery.Criteria.AddFilter(filter1); EntityCollection entColRoles = _orgService.RetrieveMultiple(userquery); if (entColRoles != null && … Continue reading Dynamics CRM Generic SQL Error

Dynamics 365 WhoAmI

In Dynamics 365, once we have the IOrganizationService object, we can retrieve the user id, organization id and the business unit id: CrmServiceClient conn = new CrmServiceClient(new System.Net.NetworkCredential(userid, password, domain),server, port, orgname); IOrganizationService _orgService; _orgService = (IOrganizationService)conn.OrganizationServiceProxy; Guid orgId = ((WhoAmIResponse)_orgService.Execute(new WhoAmIRequest())).OrganizationId; Guid userId = ((WhoAmIResponse)_orgService.Execute(new WhoAmIRequest())).UserId; Guid businessunitId = ((WhoAmIResponse)_orgService.Execute(new WhoAmIRequest())).UserId; Code running:

Dynamcis CRM On Premise Console App

To create a console app that connects to Dynamics CRM 2015, we will use the CrmServiceClient. Create a new Visual Studio project and add the assemblies: Microsoft.Crm.Sdk.Proxy Microsoft.Xrm.Sdk; Microsoft.Xrm.Tooling.Connector In the code, add Using: using Microsoft.Xrm.Tooling.Connector; using Microsoft.Xrm.Sdk; using Microsoft.Crm.Sdk.Messages; using Microsoft.Xrm.Sdk.Query; To connect to CRM, we will use the connection information to pass to CrmServiceClient:   string userid = “Administrator”; string password = “yourpassword”; string domain = “YOURDOMAIN”; string orgname … Continue reading Dynamcis CRM On Premise Console App

Dynamics CRM OData and Web API URLs

To finding the Dynamics CRM OData and Web API URLs for your organization, go to Dynamics CRM and select Settings->Customizations: From there, select Developer Resources. You will then see links to the Web API and the OData Organization Service: Web API URL: https://orgname.api.crm.dynamics.com/api/data/v8.1/ The service URLs: https://orgname.api.crm.dynamics.com/XRMServices/2011/Organization.svc https://orgname.crm.dynamics.com/XRMServices/2011/Organization.svc To get the OData: https://orgname.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/ https://orgname.api.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/  

Dynamics CRM Quick Find Entities

Dynamics CRM has quick find functionality, where you can enter text in the search box and it will search specific entity records in CRM. To change which entities are searched, go to system settings->Select entities for search: Here you can add/remove the entities searched:  

Dynamics 365 Copy Security Role

Security roles can be copied in Dynamics 365. To do this, go to Settings->Security and select a role to copy: Select More Actions->Copy Role: Enter a new role name and click OK: A new role is created with the original permissions:  

PowerShell Introduction

PowerShell is an interactive shell and a scripting language for Windows environments. It has several uses including for automation and configuration. It is also object oriented and based on the .NET Framework. To run commands, open the Windows PowerShell app: You can then run commands such as changing directory like in DOS. PowerShell also has the concept of “aliasing”, which is running a command by typing a different name. For example, there are several … Continue reading PowerShell Introduction

Dynamics 365 Form Non-Event Dependencies

In our Dynamics 365 forms, there are measures we can take to ensure fields that are being used by JavaScript are not removed from forms. For example, let’s say we have a function to display the Website URL entered by the user: function displayWebsite() { try { alert(“The website entered is: ” + Xrm.Page.getAttribute(“websiteurl”).getValue();); } catch (e) { alert(e.message); } } Let’s add this displayWebsite function to the form OnLoad … Continue reading Dynamics 365 Form Non-Event Dependencies

Dynamics 365 Subgrids

Subgrids are grids on a form that display records from another entity. We will go through an example of adding subgrids to a form using Accounts as an example. The account form in CRM looks something like the following: Notice there are Contacts and Recent Opportunities subgrids. To add more, we will need to customize the form: Select a place on the form to insert the subgrid: Select Insert->Subgrid: This opens the subgrid … Continue reading Dynamics 365 Subgrids