Aris query Forumula and object definition

Last activity on October 1, 2023 - 11:21 237 Views 1 Reply Professional ARIS

Hammami Omar on December 29, 2021

Hello,

I m trying to understand how to work with aris query and i have the two following question :

- I know there is a formula (REQUETE_ATTRIBUT_VALEUR(element, attribut) to display the attribut in the table view but i dont know how to use it to display for example the definition of an object resulting form the query (defintion of a function for example).
What do i need to set as element and attribut between () of the query.
- Can i execute the query on the object definition level and not on the object occurance level.

Thanks

Omar

Bookmark

Notify Moderator

Best Reply

M. Zschuckelt on January 3, 2022

Hello Omar,

assuming

your result objects go to column A starting with cell A2
you place a formula like the following in Cell B1 as the column Header: =QUERY_ATTRIBUTE("AT_DESC")

Then cell B1 will show the attribute name "Description", representing the attribute type.

Now create the following formula in Cell B2: =QUERY_ATTRIBUTE_VALUE(A$2;$B1)

The first parameter references the query result object in A2, the second references the attribute type in B1. The $ sign works just the same as in common spreadsheet applications, if you copy the formula. Suppose you place another attribute in C1, then you can copy this formula from B2 to C2 and it will reference C1.

Regarding your second question: you can evaluate occurrences. You need to specify in your query path, if a step is supposed to be the definition or the occurrence. Select the step and use the toggle button for occurrence/definition.

or register to reply.

Show in context Notify Moderator

1 Reply

MZ

M. Zschuckelt on January 3, 2022

Best reply
Hello Omar,

assuming

your result objects go to column A starting with cell A2

you place a formula like the following in Cell B1 as the column Header: =QUERY_ATTRIBUTE("AT_DESC")

Then cell B1 will show the attribute name "Description", representing the attribute type.

Now create the following formula in Cell B2: =QUERY_ATTRIBUTE_VALUE(A$2;$B1)

The first parameter references the query result object in A2, the second references the attribute type in B1. The $ sign works just the same as in common spreadsheet applications, if you copy the formula. Suppose you place another attribute in C1, then you can copy this formula from B2 to C2 and it will reference C1.

Regarding your second question: you can evaluate occurrences. You need to specify in your query path, if a step is supposed to be the definition or the occurrence. Select the step and use the toggle button for occurrence/definition.
Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.