DT

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!

 

by Veronika Ellermann
Badge for 'Fan' achievement
Posted on Tue, 10/05/2021 - 18:23

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

0
by Tanguy Petre
Posted on Tue, 10/05/2021 - 18:35

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

0
by David Torres Author
Posted on Wed, 10/06/2021 - 16:45

Thanks, Veronika and Tanguy for your valuable feedback!

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock