HO
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
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.
