Hello,
I am trying to auto populate an insight field from one Object Type to another field in a different Object Type.
For instance, I have an Object Type = GUM that has an attribute of "GUM" and an Attribute called "App Name". "App Name" is referenced in other Object Types and is something I can join on.
I also have an Object Type = "OS Instances", which also has an attribute of "GUM" that references back to the Object Type above ("GUM"). This Object Type ("OS Instances") also has a attribute field called "Application" (same as "App Name" from "GUM" Object Type).
Is there a way I can fill in the "Application" attribute from the Object Type GUM's App Name attribute when both GUM attributes match?
Hi @P. Peña
i am trying to reconstruct ehat youve written…
Object Type = GUM
Object Type = "OS Instances"
If i have understood this correct, your facing the same thing like me a week ago.
You want to keep the attributes in sync, so that there is no inconsistency and no work for the team to keep it in sync. Normally we should not have the same information at two or more places, BUT in a real world we want to see the information of some specific attributes in both objects, because we dont want to do the extra drill down to the reference, to get the information we want.
Ideal would be an “VIEW Attribute of reference” attribute, but thats not existing.
At the moment we can solve this with an automation. I have already done that.
The short logic is the following:
I have a realworld implementation of something similar. I will add it as soon i aM at my PC tomorrow.
My Schema: Inventory
ObjectType: Notebook
ObjectType: Model
Then Lookup objects:
"Name" IN ("{{object.Model.Name}}") AND objectType in objectTypeAndChildren("Models")
i Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Frederic Wolf Appreciate the help! Question. On the last piece where you are looking up the objects from "objectType in objectTypeAndChildren" in the below statement:
"Name" IN ("{{object.Model.Name}}") AND objectType in objectTypeAndChildren("Models")
Where is the reference of "objectTypeAndChildren" coming from?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
i am uaing the function objectTypeAndChildren because my schema has an hirachy.
Models ia an abstract and below models are different model types. E.g. Notebooks, Printers, …
The function include all childs, so the function is much more generic.
I have the same structure for the assets.
If you need further information for the functions have look here: https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/
I am curreNtly in the middle of developing a good structure. I am trying to find a good balance of abstraction and normalization, without making it to complicated to create new objects.
my current structure is looking like this:
if you are are also in the middle of structure and related logic, i would appreciate some 1:1 discussion about it. PN me via LinkedIn https://www.linkedin.com/in/frederic-wolf-026ab6239
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Okay, this helps with the screenshot. I wasn't sure how that was used but if I am understanding correctly, that specific statement refers to the objectType and any children under those objectTypes. My model doesn't currently have any children associated.
Thank you very much!!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.