FetchXml on stringmap returns no value for objecttypecodename

(0) Share

Report

Posted on by Sam Alex

I need to run a FetchXml to get the possible Option Set Values, but when I build the FetchXml based on objecttypecodename nothing is returned:

For example this returns nothing. Now if I use objecttypecode and 1 it works, but even in code when I run this and return objecttypecodename as a field it's empty in all cases. I've seen some posts where this is used to select values from StringMap in code for custom lookups and such, but given objectypecode on custom entities can change between organizations I need to somehow query on entityname instead. Any ideas if this is a bug or if someone has other suggestions on how to do this? We're using Dynamics 365 (CRM 2015 - v8) on prem.

Here's an article that actually suggests this method:
https://community.dynamics.com/crm/b/crmtipsfromadeveloper/posts/know-how-d365-crm-get-optionset-label-from-stringmap-using-fetchxml-c-js-ssrs

Thanks.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Martin Donnelly 1,030 on at

Like (0)

Report

RE: FetchXml on stringmap returns no value for objecttypecodename

Here's some ideas that might help. I think all the typecodes are the same for out of the box so, the problem is finding those for custom. I think they all start at 10000. Also, I'm guessing one cannot run a comparison against the virtual field to explain why it is not found.

So... maybe you need to fetch a set where objectypecode ge 10000, run the set looking for the entity name in objecttypecodename and use that record which matches.

If you are looking for something completely generic the forget the ge 10000 and search through the whole set. It can't be so big as to be a performance issue.
samalex1701 262 on at

Like (0)

Report

RE: FetchXml on stringmap returns no value for objecttypecodename

Yes it's listed when I check the Metadata of the Entity through XRM Toolbox:

But every query I create using objecttypecodename does not work or gives an error saying it doesn't exist.
cloflyMao 25,208 on at

Like (0)

Report

RE: FetchXml on stringmap returns no value for objecttypecodename

Hi Partner,

Have you confirmed that whether objecttypecodename field is actually existed in stringmap entity in your CRM environment?

Could you share me posts you've seen which tell us how does objecttypecodename field work?

In addition, my environment is Dynamics 365 v9 online,

I downloaded and imported a solution called Metadata Browser, selected stringmap entity and found objecttypecode is actually entityname.

And I execute web API script to retrieve stringmap entity records and still not found objecttypename field.

var req = new XMLHttpRequest();
req.open('GET', Xrm.Page.context.getClientUrl() + "/api/data/v9.0/stringmaps?$filter=objecttypecode eq 'account'", false);
req.setRequestHeader("Accept", "application/json");
req.setRequestHeader("OData-MaxVersion", "4.0");
req.setRequestHeader("OData-Version", "4.0");
req.setRequestHeader("Prefer", "odata.include-annotations=*");
req.send();
if (req.readyState == 4 /* complete */) {
    if (req.status == 200) {
        data = JSON.parse(req.response);
        if (data != null && data.value.length > 0) {
            console.log(data.value);
        }
    }
    else {
        var error = JSON.parse(req.response).error;
        console.log(error.message);
    }
}

Regards,

Clofly