Multi level tab in JSON datafeed

Hi Fabien,

can you explain what your desired result would look like? From your explanation I don't understand it. A table could potentially already help :) 

Best,

Veronika

The result I want is : 

I try to retrieve the third column (level1.ID) without success. 

Regards,

Fabien

so, that is an attribute that is maintained on model level- it is not "concatenated", right?

Yes. 

It's a level-1 attribute. 

HI Fabien 

a few examples for the syntax can be found here in the new doc.aris.com ARIS Documentation - Datasource JSON and a link to XQuery Syntax

for $processus in ?LIST-PROCESSUS?*
return (
 for $tache in $processus?LIST-TACHE?*
 return map {
   "T_ID": $tache?ID,
   "T_Name": $tache?Name,
   "P_ID": $processus?ID, 
   "P_Name": $processus?Name
 }
)

Hope this helps

Best

Monika

HI Fabien 

a few examples for the syntax can be found here in the new doc.aris.com ARIS Documentation - Datasource JSON and a link to XQuery Syntax

for $processus in ?LIST-PROCESSUS?*
return (
 for $tache in $processus?LIST-TACHE?*
 return map {
   "T_ID": $tache?ID,
   "T_Name": $tache?Name,
   "P_ID": $processus?ID, 
   "P_Name": $processus?Name
 }
)

Hope this helps

Best

Monika

Thanx, it works fine. 
Just another question.
Is it possible to add "user param" in the Repeating Object ? 

For example if I want to work with only the "P01" processus 

Something like that but this doesn't work. 

And this works

My second option if to add an operator filtering all the map entry. 

Regards

I would not recommend to use a variable during the parsing , this may cause a reload of the file for every filter change.

I would do a filter step afterwards and filter the processes with the defined user variable.

This has the effect that you load your file once and that you can set approbiate datafeed cache setings.