I'm going to put this here, since it took me half a day of work to achieve it.
Following scenario:
One of our CI pipelines ran into an error, stating the following:
"The evaluation of the current component(name=Attribute, id=4fe6d1f0-de6d-417c-a930-47e37848debf) in the current operation (Update) failed during managed property evaluation of condition: Managed Property Name: canmodifyrequirementlevelsettings; Component Name: Attribute; Attribute Name: canmodifyrequirementlevelsettings"
So the message is clear. The pipeline is trying to update the Requirement Level of an attribute, but since its managed property "canmodifyrequirementlevelsettings" changed by an update, we are not allowed to do so anymore. But which attribute? On which entity/table? The error message only showed us the AttributeId.
Unfortunately the message did not state the table which contains this attribute. Also unfortunately that WebAPI MetaData retrieves for getting Attribute Information require entity information. (see https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/mt788314(v=crm.8)#retrieve-metadata-items-by-metadataid)
So, what to do. At first I checked the MetaDataBrowser in XrmToolbox to see if I can lookup the attributeId. Great tool, you can see and lookup the MetaDataId, but here you also need to open up an entity first.
Second I created a XLS which contained all attributes from the system with the help of MetaData Document Generator from XrmToolbox. Took pretty long as you can guess. Opened up the document - no MetaDataId available 😫
After some time, the SQL 4 CDS tool came to my mind. Opened up the tool, and YES - there is a section for MetaData and a table called "Attributes"! 😍
So, creating a short query like stated below, executing - BOOM! We have it!
SELECT displayname,logicalname,entitylogicalname,metadataid,requiredlevel
FROM metadata.attribute
WHERE metadataid = '4fe6d1f0-de6d-417c-a930-47e37848debf'
So now I could look into our repository and update the requiredlevel to the correct one.
