how to add hyperlink to column value in table with an url provided by another event and colour quote depending on status

[deruvara]

above ones is the talbe and query for the same is index="wtqlty" source=pdf-fc-002-rh sourcetype="release_pdf_results_json" |table pdf_name pdf_url pdf_state

please help

[johnhuang]

For color formatting:

<format type="color" field="pdf_state">
<colorPalette type="expression">case (like(value,"accepted"), "#037FFC", like(value,"denied"), "#FC030F", like(value,"pending"), "#FFFF00")</colorPalette>
</format>

[deruvara]

this worked.thank you

[ITWhisperer · Accepted solution]

        <drilldown>
          <condition field="pdf_url">
            <link target="_blank">$click.value2|n$</link>
          </condition>
        </drilldown>