Skip to main content
March 6, 2023
Solved

how do I drill down to the values highlighted

  • March 6, 2023
  • 8 replies
  • 0 views

Best answer by dimitriss5700

a!forEach(

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

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

) 

 

8 replies

March 6, 2023

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
March 6, 2023

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

March 6, 2023

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
March 6, 2023

a!forEach(

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

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

)