filter with parent opportunity id using Odata query Dynamic CRM.

Description:

In this example, we explain that how to filter with parent opportunity is using OData service in Dynamic CRM.or how to get or filter record based on parent opportunity using OData in Dynamic CRM.or OData query to get some parent field in Dynamic CRM.or using OData query to determine whether specific entity has children or not in Dynamic CRM.

So below is the JavaScript code with OData query to fetch or filter record with parent opportunity in Dynamic CRM.

Prefiltering in SSRS report on selected(current) record in Dynamic CRM.

Description:

In this example, we explain that how to run the SSRS report based on specific entity record using FetchXML in Dynamic 365 CRM.or prefiltering in SSRS report on current or selected record in Dynamic CRM using FetchXML. Alternatively, working with SSRS report pre-filtering or related entities record using FetchXML in Dynamic CRM.or how to display current record on SSRS report using FetchXML in Dynamic CRM.

So below is the FetchXML to prefiltering record in SSRS in Dynamic CRM.

Retrieving the last record in each group - SQL Server.

Description:

In this example we explain that how to get Last Record of each group using SQL Server. Alternatively, SQL query to retrieve Last record of each product or group using SQL Server. Alternatively, how to get last record of each group in every month of specific range using SQL query. Alternatively, how do I get latest record of each group using SQL Server query. Alternatively, how to select Last record of each group using SQL Server.

So below is the SQL query that will help you to select or retrieve last record of each group in each month.

Add/Insert New Value into OPTIONSET - Microsoft Dynamics CRM.

Description:

In this example, we explain that how to get or set Option Set item dynamically in Dynamic CRM using JavaScript. Alternatively, how to Add/Insert new value into Option Set in Dynamic CRM using JavaScript. Here in this example we explain that how to add New Items in Option Set control in Dynamic CRM using JavaScript. Or dynamically add or remove Option to an Option Set using JavaScript in Dynamic CRM.or add new Option Set to an Option in Dynamic CRM using JavaScript.in below example ="example-enableFiltering" is the id of the Select.

How to open confirmation dialog in Dynamic CRM.

Description:

In this example we explain that how to open Confirmation Dialog Box in Dynamic CRM using JavaScript. Alternatively, how to open Confirmation Dialog Box in Dynamic CRM and perform action when click on the button using JavaScript.

In Dynamic CRM Xrm.Utility library are used to display Confirm and alert Dialog Box in a form. Here in this example we explain that how to open confirmation dialog box and when click on ok button then perform some action or when click on cancel at that time close the dialog box.

So below is the JavaScript code to open Confirmation Dialog Box in Dynamic 365 CRM.

How to Get Opportunity Won or Lost via JavaScript in Dynamic CRM.

Description:

In this example we explain that how to get Opportunity is Won or lost using JavaScript in Dynamic CRM.or how to get the Status of the Opportunity using JavaScript in Dynamic 365 CRM.or How to track Opportunity closed as won using JavaScript in Dynamic CRM.

In our requirement like when any Opportunity is open by user at that time we have to get the status of the Opportunity like it is Won Opportunity or Lost Opportunity so we have used one JavaScript function on Form Load of Opportunity and get the status of the Opportunity when Opportunity is open by end user.

So below is the JavaScript code that are used to get the Opportunity status like Won or Lost in Dynamic CRM.

Retrieve Option set value from web API in Dynamic CRM

Description:

In this example, we explain that how to get the Option Set Value and Text in jQuery Ajax call success method result in Dynamic CRM.or how to retrieve Option set value from web api in Dynamic CRM.or retrieve the option set values for collection attribute in Dynamic CRM.

So here we explain that how to get option set text and value from OData query in Dynamic CRM web api.so below is the OData query that are useful to get the Option set value in Dynamic CRM.

Display Pie Chart in Dynamics CRM using Web Resource.

Description:
In this example, we explain that how to display pie chart in Dynamic CRM using HTML Web Resource. Alternatively, how to display revenue vs cost of particular opportunity in pie chart using HTML web Resource and Canvas JS chart in Dynamic CRM.or how to display pie chart in Dynamic CRM entity form using JavaScript and Web Resource.

So here we explain that how to get data of the Opportunity entity and display it in Pie Chart dynamically using HTML Web Resource and JavaScript in Dynamic CRM.

how to avoid image getting loaded from the cache in Asp.Net

Description:

In this example, we explain that how to remove images from browser cache when image is changed in Asp.Net.or how to avoid image getting loaded from the cache. Alternatively, image are loaded from cache so how can I load new images instead of old image in Asp.net.

Therefore, there are many questions raised like how to load new, image every time when image is changed instead of loading image from cache in browser in Asp.Net.or by default browser load image from cache when image is changed.

Now since it is not possible to clear cache of user’s browser from server side. We can use the following trick

Retrieve another entity record by using GUID of that record in Javascript.

Description:
In this example, we explain that how to get all the record based on GUID in Dynamic CRM using JavaScript or jQuery. Or filter the records based on guid in Dynamic 365 CRM using JavaScript Ajax call. Or retrieve another entity record by using GUID of that record in JavaScript in Dynamic CRM.

So here, we explain that how to retrieved record by GUID in dynamic CRM using OData using JavaScript.

For Nvarchar(Max) I am only getting 4000 characters in SQL Server?

Description:
In this example we explain that how to use SQL string variable larger than 4000 character in SQL Server Stored procedure because we all know that SQL will not execute Query parameter contains more than 4000 character so to overcome this problem we have to use the while loop and assign the string in a variable.

There are many questions are raised from user like nvarchar max after 4000 character not working. Or trouble printing out long varchar max string.so below is the query that will help you when you SQL Query size more than 4000 character.

set parent case lookup in quick create form using JavaScript in Dynamic CRM

Description:
In this example we explain that how to populate Quick create from with data from parent form in Dynamic CRM using JavaScript. Or how to set Parent Case Lookup in Quick Create case form in Dynamic CRM using JavaScript. Or how to pre-fill fields in a quick create form from the parent form using JavaScript in Dynamic CRM.

Here we demonstrate that how to populate a parent form lookup field value in a child form using JavaScript in Dynamic 365.so how to fill-up the Parent Case Lookup in Child case form using JavaScript in Dynamic CRM.

Open new activity form with ‘Regarding’ field prefilled in Dynamic CRM

Description:

In this example we explain that how to open new activity form with “Regarding” field prefilled in Dynamic CRM using JavaScript. Or how to open Phone Call or Task Activity form with fill-up Regarding filed using JavaScript in Dynamic CRM.or open New Activity form with regarding and Party List field prefilled using JavaScript in Dynamic CRM.

So here we explain that how to use Xrm.Utility. openEntityForm with Regarding field in Dynamic CRM using JavaScript.