Getting Security Role Name for logged-in user in Dynamics using Xrm.

Description:

In this example, we explain that how to get logged in user role in Dynamic 365 CRM.or how to get security role name for logged-in user in Dynamic CRM using XRM.or how to retrieving login user security roles in Dynamic CRM.or how to get role name of current user in Dynamic CRM using JavaScript. Alternatively, get current logged in user’s security role using JavaScript.so below is the JavaScript code with XRM will used to get or retrieve current logged in user role in Dynamic CRM.

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.