Mad D365

Open  Webresource Dependencies Checker tool in  XrmToolBox . This tool was developed to get all the events attached to a form for a specific or all web resources on the form. You have two options to check dependencies, either by Web Resource or by Entity .  Filter by  WebResource : Type your Script Logical Name and press the  Tab key. It will retrieve all the entities having decencies on the specified script. Select Entity , it will retrieve all the forms which are using the specified script. Select Form , it will show all the events attached to form, from the script. In the result table, you will see the following fields: Webresource Name : Logical Name of the web resource. Control Type : The type of control where an event is registered.  Control Name : Name of control on which event is registered. Function Name : Function name specified in event registration. Event : Trigger for an event. Enabled : Specifies function is enabled or not. Execution Cont...

In this blog, we are going to discuss how we can apply a custom filter on multi-entity reference lookup. There was a requirement, to restrict lookup data on From field on Email. From field has the data type of Party List which basically allows you to select a record from the users and queues table. Now, the requirement was to restrict the data in such a way where logged In user can see only the queues of which he was a member, and for the user's table only his record to be shown. As per the requirement, I have to apply two custom filters on the form field for each entity. I never did this before. So, after a lot of research and development found that the solution was too easy. We just have to apply a addCustomFilter function twice(one for each entity). like this: Now I know how I can apply the custom filter on Multi-Entity lookup. It could have done the job for me if my filter on entity was straight forward. But, In this case it wasn't solving my problem as it only works with...

In this blog, we are going to discuss how to perform CRUD operations between CRM environments. As you all might be aware, there are already existing ways to do data migrations, such as  Data Import , Kingswaysoft SSIS Package , using programs, and so on. Here we are going to perform data migration between CRM environments in a different way to import data with the same record identifier and then we are going to perform read, update, and delete operations on imported data. Prerequisite:  You must have an understanding of the  SQL queries. So, Let's Start. 1. Open  SQL 4 CDS in XrmToolBox. 2. Add connection of source and target environment. In this example target is RND and source is TEST . 3. Write a query to perform operation and execute it. CREATE: Inserting records from source environment to target environment. Here we are inserting only two columns, activityid : record identifier and subject , with a pretext of ' Imported Task: '. So, you can add the c...

You all might be aware of the CRM inbuilt  User Audit Access functionality , which shows user login access. I also proposed the same solution to my client, when he asked me about how to check user login date and time in CRM. But, he wanted a user-friendly and flexible way to access this data.  Problem with current inbuilt functionality :      1. Accessing Data                   To access the user login audit data, as a user I have to perform several steps. which is not the quickest or most convenient way. i.e.   Go to Advanced Settings >> Auditing >> Audit Summary View >> Filter Event Column with "User Access via Web".      2. No filter on User Record                     It shows the login data for all users. The filter is not available for the user record, which makes it hard ...

Disclaimer:  It is recommended to use the existing OOB N: N relationship for an entity. The custom N: N relationship is only to be used for entities that do not support the N: N relationship. As the title suggests, in this blog we are going to discuss how to create a custom N: N relationship. The topic is divided into the following parts: 1. Need of custom N: N relationship. 2. Implementing custom N: N relationship. So, let's begin. 1. Need of custom N: N relationship         One day, I received a requirement to develop functionality where a user can add multiple users and contacts for appointments and phone calls, and later on, he can send notifications to selected contacts or users via mail. The approach was simple, to create an N: N relationship between appointment to user and contact and then add a subgrid on the form for each entity. But for activity entities, CRM does not allow you to create an N: N relationship.  Hence, a custom N: N relati...