Hi Everyone,
I’m trying to set the correct AQL criteria to show related terms in a new Data Domain I have created. I can see the logic used for default domains like ‘Finance’, but I’m unable to replicate the outcome because I either don’t know how to find the need ID’s or where I can see an ID (like above the Relationship Type name), it’s the same ID anywhere it is present/visible.
We’re using 15.4.
Thank you for any help you can offer.
Regards
Stu
Best answer by Lisa Kovalskaia
name is "Finance" OR @termRelationship(target).any(type.$id = '125861e2-8f58-43d6-a8a6-7d25b8d524e0' AND source.$id = '15bbce34-0000-7000-0000-00000033052e')
@termRelationship(target).any() means it’s looking for terms that are in the target/child position of the relationship link,
type.$id = '125861e2-8f58-43d6-a8a6-7d25b8d524e0'means a specific relationship type, you’ll find it at https://<your-ataccama-base-URL>/organization/applicationSettings/relationshipType/125861e2-8f58-43d6-a8a6-7d25b8d524e0. You can replace this ID with any other relationship type ID from this list https://<your-ataccama-base-URL>/organization/applicationSettings/relationshipTypes
source.$id = '15bbce34-0000-7000-0000-00000033052e'means that the query is filtering for the specific term in the source/parent position of the relationship, in this case Finance. You will replace it with your domain term ID.
Does this help? Please let me know if you have more questions!
+3
name is "Finance" OR @termRelationship(target).any(type.$id = '125861e2-8f58-43d6-a8a6-7d25b8d524e0' AND source.$id = '15bbce34-0000-7000-0000-00000033052e')
@termRelationship(target).any() means it’s looking for terms that are in the target/child position of the relationship link,
type.$id = '125861e2-8f58-43d6-a8a6-7d25b8d524e0'means a specific relationship type, you’ll find it at https://<your-ataccama-base-URL>/organization/applicationSettings/relationshipType/125861e2-8f58-43d6-a8a6-7d25b8d524e0. You can replace this ID with any other relationship type ID from this list https://<your-ataccama-base-URL>/organization/applicationSettings/relationshipTypes
source.$id = '15bbce34-0000-7000-0000-00000033052e'means that the query is filtering for the specific term in the source/parent position of the relationship, in this case Finance. You will replace it with your domain term ID.
Does this help? Please let me know if you have more questions!
Thanks
In my case I wanted to create a ‘Customer’ domain, so the logic - name is "Customer" OR @termRelationship(target).any(type.name = 'ParentChild' AND source.name = 'Customer') did the trick. Now that I know to just lift my vision a little higher (to the URL) I’ll go back to using the ID’s to avoid any name changes breaking things down the track.
Thanks again. Have a great day.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
