topic Re: How to (un)sort an input dropdown in dashboard studio in Dashboards & Visualizations

How to (un)sort an input dropdown in dashboard studio

ktn01 — Wed, 08 Nov 2023 13:06:15 GMT

I have the following search

index=dsi_splunk host=dev_splunkmanager script=backup | stats earliest(_time) as debut by pid | convert timeformat="%d/%m/%Y %H:%M" ctime(debut)

The result is sorted as I need:

I use this search as input for a dropdown on dashboard studio but de result is sorted differently:

It seems the list is sorted by "value".

How may I have an unsorted dropdown to conserve the result order?

Thanks

Re: How to (un)sort an input dropdown in dashboard studio

ITWhisperer — Wed, 08 Nov 2023 13:32:07 GMT

Which version of Splunk are you using as Studio is under active development and some improvements have been made.

Re: How to (un)sort an input dropdown in dashboard studio

ktn01 — Wed, 08 Nov 2023 13:37:15 GMT

I am using Splunk 9.1.1

Re: How to (un)sort an input dropdown in dashboard studio

ITWhisperer — Wed, 08 Nov 2023 15:03:40 GMT

This appears to work for me on 9.1.1. Please can you try cutting down your dashboard to isolate the issue, then post the source code.

Re: How to (un)sort an input dropdown in dashboard studio

ktn01 — Wed, 08 Nov 2023 17:53:02 GMT

{ "visualizations": {}, "dataSources": { "ds_6STCWAXt": { "type": "ds.search", "options": { "query": "index=dsi_splunk host=dev_splunkmanager script=backup \n| sort _time \n| stats earliest(_time) as debut by pid\n| convert timeformat=\"%d/%m/%Y %H:%M\" ctime(debut)" }, "name": "backupId" } }, "defaults": { "dataSources": { "ds.search": { "options": { "queryParameters": { "latest": "$global_time.latest$", "earliest": "$global_time.earliest$" } } } } }, "inputs": { "input_global_trp": { "type": "input.timerange", "options": { "token": "global_time", "defaultValue": "-24h@h,now" }, "title": "Période globale" }, "input_backup": { "options": { "items": ">frame(label, value) | prepend(formattedStatics) | objects()", "token": "backupId", "selectFirstSearchResult": true }, "title": "Backup", "type": "input.dropdown", "dataSources": { "primary": "ds_6STCWAXt" }, "context": { "formattedConfig": { "number": { "prefix": "" } }, "formattedStatics": ">statics | formatByType(formattedConfig)", "statics": [], "label": ">primary | seriesByName(\"debut\") | renameSeries(\"label\") | formatByType(formattedConfig)", "value": ">primary | seriesByName(\"pid\") | renameSeries(\"value\") | formatByType(formattedConfig)" }, "hideWhenNoData": true } }, "layout": { "type": "grid", "options": { "width": 1440, "height": 960 }, "structure": [], "globalInputs": [ "input_global_trp", "input_backup" ] }, "description": "", "title": "Backups Cloner" }

Re: How to (un)sort an input dropdown in dashboard studio

ITWhisperer — Wed, 08 Nov 2023 18:19:53 GMT

So, the one you currently have selected is at the top, the rest are in the order returned by the search. This behaviour is different to SimpleXML dropdowns.