topic Re: convert timeformat not responding in drilldown link search in simple xml in Dashboards & Visualizations

convert timeformat not responding in drilldown link search in simple xml

ssujin — Tue, 29 Sep 2020 11:22:34 GMT

convert timeformat not responding with drilldown link tag, as a result drilldown search keep on showing loading. Sample simple xml below

<row>
    <panel name="Job Statistics">
        <table>
            <title>Job Statistics</title>
            <search>
                <query>index=$index$ host=$host$ eventtype=et_job_timing | eval Time=_time | convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)| table Time, THROUGHPUT | chart values(THROUGHPUT) by Time</query>
            </search>
            <option name="drilldown">cell</option>
            <drilldown>
                <link>search?q=search index=$index$ host=$host$ eventtype=et_job_timing| eval Time=_time | convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)| table Time, THROUGHPUT | where Time = "$click.value$"</link>
            </drilldown>
        </table>
    </panel>
</row>

from above simple xml below mentioned search not responding.

search?q=search index=$index$ host=$host$ eventtype=et_job_timing| eval Time=_time | convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)| table Time, THROUGHPUT | where Time = "$click.value$"

kindly guide me on this error.

Re: convert timeformat not responding in drilldown link search in simple xml

HiroshiSatoh — Tue, 29 Sep 2020 11:22:36 GMT

convert command It looks like no good.
Workaround:
Macro the convert.

my_macro:convert timeformat="%d-%m-%Y:%H:%M:%S" ctime(Time)
↓
search?q=search index=$index$ host=$host$ eventtype=et_job_timing| eval Time=_time |‘my_macro‘| table Time, THROUGHPUT | where Time = "$click.value$"

Re: convert timeformat not responding in drilldown link search in simple xml

sundareshr — Thu, 13 Oct 2016 11:40:55 GMT

What are you trying to do? You cannot do an eval in link. Link requires a valid URL that will be launched. You can pass token values as querystring, but you will need to format them earlier. In short, what you have here will not work, but if you can explain what it is that you are trying to accomplish in your dashboard, we can help.

Re: convert timeformat not responding in drilldown link search in simple xml

ssujin — Tue, 25 Oct 2016 06:50:59 GMT

Thanks lot. It worked perfectly.