Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
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
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
Hi SarinaS,
Thank you for your answer. Using unnested variables is indeed the solution I have found for now.
Best,
JJC
Hello,
It's been two years since this questions got answered. Is there a way to get the nested variables in the sql now?
Hi @timchen,
Indeed, nested variables can be retrieved through the parseJSON function:
โ
Thanks,
Sarina
Is it possible to do the same in the SQL recipe?
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