Skip to main content
New Participant
Mar 6, 2023 1:57 PM UTC
Solved

how do I drill down to the values highlighted

dimitriss5700
Participating Frequently
Mar 6, 2023 3:10 PM UTC

a!forEach(

items: property(local!value, "value", "result", "values", {}), 

expression: todate(index(fv!item, 3, null)) = today() 

) 

 

8 replies

sanchitg0002
Inspiring
Mar 6, 2023 2:47 PM UTC

You need to index the keys of dictionary in order.

To index the values you have highlighted use it like:

index(local!value,"result",2,"values",null)

dimitriss5700
Participating Frequently
Mar 6, 2023 2:47 PM UTC

index(local!value, "value", "result", "values", 2, null)

New Participant
Mar 6, 2023 3:01 PM UTC

i am able to drill down with suggestions. I am looking to loop up these values and check if the dates are matching to today. I am struggling a bit in referencing them in foreach

dimitriss5700
Participating Frequently
Mar 6, 2023 3:10 PM UTC

a!forEach(

items: property(local!value, "value", "result", "values", {}), 

expression: todate(index(fv!item, 3, null)) = today() 

)