Dynamics Community Forum Thread Details

Hi,

I am having issues filtering with linked entity XML with the below code on a N:N subgrid:

The issue is coming from the 'filterXml', I am able to filter this fine without using the 'link-entity' but I need to filter by this, is it possible to use the link-entity or adjust the code to support the link-entity?

// Custom function to call instead of the OOTB Add Existing button/command - all 3 parameters can be passed as CRM Parameters from the ribbon
FilterAddExistingVendor: (selectedEntityTypeName, selectedControl, firstPrimaryItemId) => {
console.log('here');
if (selectedControl.getRelationship().name == "XYZ_bookableresource_msdyn_vendor") {
// Custom Account -> Contact N:N - filters to show only contacts with this account as the parentcustomerid
var options = {
allowMultiSelect: true,
defaultEntityType: "msdyn_vendor",
entityTypes: ["msdyn_vendor"],
disableMru: true,
showNew: true,
searchText: "\n", // Search by default
filters: [{
entityLogicalName: "msdyn_vendor",
filterXml: //"<filter type='and'><condition attribute='msdyn_vendoraccountnumber' operator='eq' value='" + 'TEST' + "' /></filter>" +
"<link-entity name='msdyn_vendorgroup' from='msdyn_vendorgroupid' to='msdyn_vendorgroupid' link-type='inner' alias='ag'>" +
"<filter type='and'><condition attribute='msdyn_vendorgroup' operator='eq' value='" + 'SUBCON' + "' /></filter>"
}]
};

XYZ.BookableResource.lookupAddExistingRecords("XYZ_bookableresource_msdyn_vendor","bookableresource", "msdyn_vendor", firstPrimaryItemId, selectedControl, options);
}
else {
// Any other contact relationship (N:N or 1:N) - use default behaviour
XrmCore.Commands.AddFromSubGrid.addExistingFromSubGridAssociated(selectedEntityTypeName, selectedControl);
}
},

// relationshipName = the schema name of the N:N or 1:N relationship
// primaryEntity = the 1 in the 1:N or the first entity in the N:N - for N:N this is the entity which was used to create the N:N (may need to trial and error this)
// relatedEntity = the N in the 1:N or the secondary entity in the N:N
// parentRecordId = the guid of the record this subgrid/related entity is used on
// gridControl = the grid control parameter passed from the ribbon context
// lookupOptions = options for creating the custom lookup with filters: docs.microsoft.com/.../lookupobjects
lookupAddExistingRecords: (relationshipName, primaryEntity, relatedEntity, parentRecordId, gridControl, lookupOptions) => {
Xrm.Utility.lookupObjects(lookupOptions).then(function (results) {
if (results.length > 0) {
// Get the entitySet name for the primary entity
Xrm.Utility.getEntityMetadata(primaryEntity).then(function (primaryEntityData) {
var primaryEntitySetName = primaryEntityData.EntitySetName;

// Get the entitySet name for the related entity
Xrm.Utility.getEntityMetadata(relatedEntity).then(function (relatedEntityData) {
var relatedEntitySetName = relatedEntityData.EntitySetName;

// Call the associate web api for each result (recursive)
XYZ.BookableResource.associateAddExistingResults(relationshipName, primaryEntitySetName, relatedEntitySetName, relatedEntity, parentRecordId.replace("{", "").replace("}", ""), gridControl, results, 0)
});
});
}
});
},

// Used internally by the above function
associateAddExistingResults: (relationshipName, primaryEntitySetName, relatedEntitySetName, relatedEntity, parentRecordId, gridControl, results, index) => {
var formContext = gridControl.formContext;

if (index >= results.length) {
// Refresh the grid once completed
formContext.ui.setFormNotification("Associated " + index + " record" + (index > 1 ? "s" : ""), "INFO", "associate");
if (gridControl) { gridControl.refresh(); }

// Clear the final notification after 2 seconds
setTimeout(function () {
formContext.ui.clearFormNotification("associate");
}, 2000);

return;
}

formContext.ui.setFormNotification("Associating record " + (index + 1) + " of " + results.length, "INFO", "associate");

var lookupId = results[index].id.replace("{", "").replace("}", "");
var lookupEntity = results[index].entityType || results[index].typename;

var primaryId = parentRecordId;
var relatedId = lookupId;
if (lookupEntity.toLowerCase() != relatedEntity.toLowerCase()) {
// If the related entity is different to the lookup entity flip the primary and related id's
primaryId = lookupId;
relatedId = parentRecordId;
}

var association = { '@odata.id': formContext.context.getClientUrl() + "/api/data/v9.0/" + relatedEntitySetName + "(" + relatedId + ")" };