+4Hi Community,
When defining a metadatareader you can add the parent ID in the output by specifying the Parent ID Column Name in the Columns tab. It is not always clear though to which entity this parent ID belongs (and browsing the model graph is often cumbersome).
Is there a way to identify the entity for a given GID value?
Thanks and kind regards,
Albert
Best answer by anna.spakova
Hello
I’ve been talking to engineering, and there is a way how to find out the ancestor type for an entity after all using the graphql query. The _ancestors property holds all the ancestors and the type is what you are looking for.
query GetCatalogItems {
catalogItems(versionSelector: {draftVersion: true}) {
edges {
node {
gid
draftVersion{
name,
connection {
type
},
_ancestors(depth:1){
gid
storedVersion{
_displayName
}
type
nodePath
}
}
}
}
}
}This will produce all CIs with their immediate parent:
If you remove the (depth:1) parameter, you can get all the ancestors all the way to the top metadata node.
So the graphql knows the information, unfortunately, it is not possible to get it through ONE Metada reader as of right now.
I hope this helps.
Kind regards,
Anna
+3Hello
thank you for this question. Currently, no mechanism would give you the entity type for a specified GID. However, what could maybe help a little, is that when you use the ONE Metadata Writer, on the General tab there is the Parent Type, which lists all the possible parents. In some cases the parent type is only one, in other it can be more types like in this example:
Usually, it lists all the subtypes of possible parent entities, so when you eliminate those, you will get only a handful of options (e.g. databaseLocation is a subtype of location so the parent is simply location and you should be able to insert the GID in the URL: https://<your-environment>/catalog/data/location/<parentId>)
It’s not much, but it can be used as another way how to get to the information together with the mmd graph.
Anyway, I will pass this on as feedback for our engineering. I had a similar request in the past.
Kind regards,
Anna
+4Hi Anna,
Although a direct ‘hit’ is not possible then, this looks like a very useful workaround.
Thanks :-)
Kind regards,
Albert
+3Hello
I’ve been talking to engineering, and there is a way how to find out the ancestor type for an entity after all using the graphql query. The _ancestors property holds all the ancestors and the type is what you are looking for.
query GetCatalogItems {
catalogItems(versionSelector: {draftVersion: true}) {
edges {
node {
gid
draftVersion{
name,
connection {
type
},
_ancestors(depth:1){
gid
storedVersion{
_displayName
}
type
nodePath
}
}
}
}
}
}This will produce all CIs with their immediate parent:
If you remove the (depth:1) parameter, you can get all the ancestors all the way to the top metadata node.
So the graphql knows the information, unfortunately, it is not possible to get it through ONE Metada reader as of right now.
I hope this helps.
Kind regards,
Anna
+4Hi
filter: "name = '<CI name value>'". I have also been trying to filter on gid but that doesn't seem to work as it 's not a regular property. Should filtering on gid been done in a different manner, or is that simply not possible?Thanks and kind regards,
Albert
+3Hello
to filter using GID, you need to use the dollar sign: $id = ‘<id>’. The plural form here does not affect that, it’s just the syntax of the graphQL saying you want all the CIs. This documentation can also give you more insight into the filtering. The filter is using the AQL query language.
Let me know if you have any further questions.
Kind regards,
Anna
+4No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
