Lock or Unlock Business process flow fields using JavaScript in CRM

Use the below syntax to lock or unlock the business process flow fields in a crm record using javascript,

Lock:

Xrm.Page.getControl(“header_process_FieldSchemaName”).setDisabled(true);

UnLock:

Xrm.Page.getControl(“header_process_FieldSchemaName”).setDisabled(false);

Advertisements

How to get list of all Entities Display Name, Logical Name and Other info using SQL Query in MSCRM?

Use the below query to get all the list of Entities Display Name, Logical Name and Object Type Code.

SELECT 
DISPLAYNAME.LABEL 'Display Name', 
EV.NAME 'Logical Name',
ObjectTypeCode 'Object Type Code'
FROM 
ENTITYVIEW EV INNER JOIN 
LOCALIZEDLABELLOGICALVIEW DISPLAYNAME
ON (EV.ENTITYID = DISPLAYNAME.OBJECTID) AND (DISPLAYNAME.OBJECTCOLUMNNAME = 'LOCALIZEDNAME')
WHERE 
LANGUAGEID = 1033 -- Add this if you want to filter records using language Id. For Example : LANGUAGEID 1033 is English
--AND ISCUSTOMENTITY = 1 -- Remove this if you want to show the system entities as well 
--AND ISACTIVITY = 0 -- Add this if you want to filter out the activity entity
--AND EN.NAME NOT LIKE '%MSDYN%' -- Add this if you want to remove like post album, filter, etc
ORDER BY 1

Output:

How to get list of all Entities Display Name, Logical Name and Other info using SQL Query in MSCRM

Inspired from Miss Dynamics CRM blog

How to get the number of Tables and their records information in MSCRM On-premise?

Follow the below steps to get the volume of Tables,

Step 1: Open MSCRM SQL Database.

Step 2: Under Databases, select the required <CRM_Org_Name>_MSCRM database. Right click on it and click on Reports -> Standard Reports -> Disk Usage by Table.

Disk Usage by Table

Step 3: Disk Usage by Table report will be displayed as shown below.

Disk Usage by Table Report

Other way to do the same is,

Step 1: Select the required MSCRM database. Click on F7 or View -> Object Explorer Details.

Disk Usage by Table - View Object Explorer Details

Step 2: Object Explorer will be opened in a new window. Right click on the header to select the required data columns to be displayed as shown below.

Disk Usage by Table - Object Explorer Details

Hope you got the results successfully :):):)

How to Install/ Uninstall Sample Data in CRM?

Follow the below steps to Install/ Uninstall Sample Data from Dynamics 365 CRM Online,

Step 1: Open Dynamics 365 Online. Goto Settings -> Data Management and click on Sample Data.

Sample Data Settings Under Data Management

Step 2: If you have not installed any Sample Data earlier, it will show Sample Data button. Click on it to import sample data given by CRM OOB.

Sample Data - Install Sample Data

Step 3: After clicking on it, Goto Imports under Data Management to see the Sample Data import records Status.

Sample Data - Imports Status

Step 4: Once all the records Status Reason change to Completed, we can Sample records in the Entities Specified in the Import Name.

For an Instance, below is the Contacts Sample Data imported during this operation,

Contacts Sample Data

Step 5: If you want to Uninstall the same data imported during this operation, Goto Settings -> Data Management and click on Sample Data.

Then click on Remove Sample Data button.

Remove Sample Data

Step 6: Records deletion status can be seen under Settings -> Data Management -> Bulk Record Deletion.

Bulk Record Deletion record Status

Hope you learned this feature in CRM :):):)

 

How to add/ edit/ remove subjects in CRM?

Subjects field is a commonly used in Products, Cases, Sales Literature and Articles. Using this, we can organize them in a Tree structure.

Follow the below steps to Add/ Edit/ Remove subjects.

Step 1: Go to Settings -> Business Management -> Subjects

Settings - Subjects - Business Management Setting

Step 2: Select the required Subject. Add/ Edit/ Remove subjects using Common Tasks Area.

In this below screen shot, I have selected Subject Products and added Product 1 and Product 2.

Subject Common Tasks Area

Step 3: Open New Case/ Articles record to see the updated Subjects.

Case Subject

Unified Service Desk 3.0.0 released

You can download Unified Service Desk 3.0.0 Version Package Deployer and Executables from the below links,

Name Size Download Link Description
Dynamics365-USD-3.0.0.859-PackageDeployer 85.4 MB Click here USD Package Deployer to install solution components in CRM
Dynamics365-USD-3.0.0.859-amd64 88.9 MB Click here 64 bit USD client
Dynamics365-USD-3.0.0.859-i386 88.9 MB Click here 32 bit USD Client

Click here to see “What’s new in Unified Service Desk 3.0.0