Hello!
I am trying to get an attribute ("Hierarchy Number") of an object ("BPMN Task") using a query. Therefore, what I want is to know how can I get the value using the instruction QUERY_ATTRIBUTE. I have seen other attributes like
=QUERY_ATTRIBUTE("AT_DESC")
=QUERY_ATTRIBUTE("AT_NAME")
=QUERY_ATTRIBUTE("AT_LAST_CHNG_2")
=QUERY_ATTRIBUTE("AT_BPMN_TASK_TYPE_2")
Also, I am wondering how can I get that attribute list
Thanks!
Hello David,
First you need to define the attribute you want; By typing in a top cell =query_attribute(hierarchy, it will display a list of attribute corresponding to the string. Select the one you need and hit enter. It should display the attribute in that cell.
Then in the second row, use he method proposed by Veronika, where the first argument is the object/model cell and the second is the cell you have just enter.
When running the query, this will bring the value of the requested attribute in the table.
Kind regards
Tanguy
Hello David,
First you need to define the attribute you want; By typing in a top cell =query_attribute(hierarchy, it will display a list of attribute corresponding to the string. Select the one you need and hit enter. It should display the attribute in that cell.
Then in the second row, use he method proposed by Veronika, where the first argument is the object/model cell and the second is the cell you have just enter.
When running the query, this will bring the value of the requested attribute in the table.
Kind regards
Tanguy
Thanks, Veronika and Tanguy for your valuable feedback!
Veronika Ellermann on
Hi David,
if I remember orrectly, the correct query is called: query_attribue_value(item;attribute).
Under data there should be an option that says: "insert attribute"- and I would reference that attribute in your query.
so, if you have incerted the attribute "Name" in cell A1 and the model in B1, I would use the formular: query_attribute_value(B1;A1).
Hope this helps :)
Best,
Veronika