- Can I use the same settings in visual builder markdown. Will this work?
Yes, visual builder supports handlebar templates in markdown, however, it does not use the same querying infrastructure that Canvas uses (so you won't be able to use the same Canvas expression with SQL to get your data).
If you are able to get the results you are looking for by configuring visual builder, then it should be possible to access the values from within the markdown. The data is just structured a bit differently.
- Since I am having result column(Success/failed) . I want to change the color for markdown to "Red " when it is failed and green when successful . Any idea how I can achieve it.
I don't think this exactly helps in your situation, but generally you can do this by editing the expression directly and using the if
statement inside of the font
argument:
markdown font={font color={if {getCell column="http.json_test.result" row=0 | eq "success"} then=green else=red}} "hello"
However, I don't think you can specify multiple color values within a single markdown element -- so if you were wanting to color each item in your list differently, I don't think that will work here.
In my example above I am using getCell
to pull from row 0
of the http.json_test.result
column -- so as you can see, you're limited on setting a single color.