Accessing a global variable in dictionary in Application Designer

jjc_al

Hi,

In my DSS application, I want to display a global variable that is inside a dictionary in my project variables using the "Variable Display" tile.

Global variables for my project look like this:

{

"editable_by_user": {
"data_start_date": "2022-09-01"

}

}

I can access the "editable_by_user" dictionary with ${editable_by_user}, however, how do I access editable_by_user["data_start_date"] in the Variable Display tile?

Thanks in advance!

---

Operating system used: Linux

Sarina

Hi @jjc_al
,

Indeed, you are correct that there isn't a way to access a nested variable value within DSS where the ${variable} syntax is required. I suggest posting this on the Product Ideas board. For now, the only option would be to create an unnested variable.

Thanks,
Sarina

jjc_al

Hi SarinaS,

Thank you for your answer. Using unnested variables is indeed the solution I have found for now.

Best,

JJC

timchen

Hello,

It's been two years since this questions got answered. Is there a way to get the nested variables in the sql now?

Sarina

Hi @timchen
,

Indeed, nested variables can be retrieved through the parseJSON function:

 

Thanks,
Sarina

timchen

Is it possible to do the same in the SQL recipe?

Sarina

Hi @timchen
,

Indeed it's not possible to use nested variables in a SQL Recipe. You would either need to use a Python recipe or a Visual recipe if you wish to use nested variables.

Thanks,
Sarina