How to Retrieve Records using FETCHXML using JavaScript in MSCRM or Dataverse

In this blog we will see how to How to Retrieve Records using FETCHXML using JavaScript in MSCRM or Dataverse

1. Prepare FetchXML ( Login to CRM or Dataverse then Go to Advance Find and Frame your Query and Download the FetchXML)

2. Consider am retrieving All Accounts

function retriveRecordusingFetchXML() {
    var fetchXml = `
<fetch>
  <entity name="account">
    <attribute name="accountid" />
    <attribute name="name" />
  </entity>
</fetch>`;

    var encodedFetchXML = encodeURIComponent(fetchXml);
    var fetchXmlRequest = "?fetchXml=" + encodedFetchXML;
    Xrm.WebApi.retrieveMultipleRecords("account", fetchXmlRequest).then(
        function success(result) {
            for (const record of result.entities) {
                var name = record.name;
            }
        },
        function (error) {
            var alertMessage = { text: error.message };
            Xrm.Navigation.openAlertDialog(alertMessage, null);
        }
    );
}

Use the Above Code to retrieve Record 

you can change the FetchXML based on your requirement.

Day 22: Fetching Records with Xrm.WebApi.retrieveRecord in Dataverse / MSCRM

 In this Blog we will see how to Use Xrm.WebApi.retrieveRecord in Dataverse / MSCRM

Video for your Reference: https://youtu.be/9QHxNtClV-4?si=1vM2lViCY9XngIXW

function retreiveRecord(executionContext) {
    var formContext = executionContext.getFormContext();
    var getCurrentRecordid = formContext.data.entity.getId();
    getCurrentRecordid = getCurrentRecordid.replace("{", "").replace("}", "");
    Xrm.WebApi.retrieveRecord("TABLENAME", getCurrentRecordid , "?$select=fieldname1,fieldname2").then(
        function success(result) {
            console.log(result);
            // Columns
            var bosch_dayid = result["fieldname1"]; 
            var bosch_dayname = result["fieldname2"]; 
        },
        function (error) {
            console.log(error.message);
        }
    );
}

Day 11 - Customizing Option Sets Dropdown Fields with JavaScript

 In this Blog, we will see how to Customizing Option Sets Dropdown Fields with JavaScript

label1 = formContext.getAttribute("bosch_optionsetvalues").getOption(377870000);
    label2 = formContext.getAttribute("bosch_optionsetvalues").getOption(377870001);
    label3 = formContext.getAttribute("bosch_optionsetvalues").getOption(377870002);
    label4 = formContext.getAttribute("bosch_optionsetvalues").getOption(377870003);
    label5 = formContext.getAttribute("bosch_optionsetvalues").getOption(377870004);
    label6 = formContext.getAttribute("bosch_optionsetvalues").getOption(377870005);
    formContext.getControl("bosch_optionsetvalues").removeOption(377870000);
    formContext.getControl("bosch_optionsetvalues").removeOption(377870001);
    formContext.getControl("bosch_optionsetvalues").removeOption(377870002);
    formContext.getControl("bosch_optionsetvalues").removeOption(377870003);
    formContext.getControl("bosch_optionsetvalues").removeOption(377870004);
    formContext.getControl("bosch_optionsetvalues").removeOption(377870005);


        formContext.getControl("bosch_optionsetvalues").addOption(label1);
        formContext.getControl("bosch_optionsetvalues").addOption(label2);
        formContext.getControl("bosch_optionsetvalues").addOption(label3);

YoutTube

Day 10 - Using JavaScript to Set Field Requirements Dynamically - JavaScript in MSCRM/Dataverse

 In this Blog, we will see how to Set Field Requirements Dynamically - JavaScript in MSCRM/Dataverse

if (formContext.getAttribute("bosch_booleanfield").getValue() == true) {
        formContext.getAttribute("bosch_enabledisablefield").setRequiredLevel("none");
    }
    else if (formContext.getAttribute("bosch_booleanfield").getValue() == false) {
        formContext.getAttribute("bosch_enabledisablefield").setRequiredLevel("required");
   }

YoutTube

Day 9 : Working with Lookup Fields - JavaScript in MSCRM/Dataverse

 

In this Video we will see how to Working with Lookup Fields in Javascript (MSCRM or Dataverse Environemnt)

Day 7: Formatting Data (Dates, Numbers) in MSCRM JavaScript

In this Blog we will see Formatting Data (Dates, Numbers) in MSCRM JavaScript

if (formContext.getAttribute("bosch_destinationdate").getValue() != null){
var getFullYear = formContext.getAttribute("bosch_destinationdate").getValue().getFullYear();
        var getDate = formContext.getAttribute("bosch_destinationdate").getValue().getDate();
        var getMonth = formContext.getAttribute("bosch_destinationdate").getValue().getMonth() + 1;

        formContext.getAttribute("bosch_getnumbersfromdestinationdate").setValue(getFullYear + "-" + getDate + "-" + getMonth);
}

Day 6: Showing and Hiding Fields with JavaScript in MSCRM

 Introduction :

In this blog we will see how to Showing and Hiding Fields with JavaScript in MSCRM

function enableDisableFieldsBasedonCondition(executionContext) {
    debugger;
    var formContext = executionContext.getFormContext();

    if (formContext.getAttribute("bosch_booleanfield").getValue() == true) {
        formContext.getControl("bosch_enabledisablefield").setDisabled(true);
    }
    else if (formContext.getAttribute("bosch_booleanfield").getValue() == false) {
        formContext.getControl("bosch_enabledisablefield").setDisabled(false);
    }
}