Drop Down based on its filename

[Azwaliyana]

I have a filename like this

-11112021_MOS.csv

-12112021_MOS.csv

-13112021_MOS.csv

I want to create drop down based on the date. How can I do that?

[kamlesh_vaghela]

@Azwaliyana 

As per my understanding, you need to filter dropdown values (files) on the basis of the date defined in the file name on. change of  timerange. then try below search in your dropdown.

YOUR_SEARCH
| eval file_date= strptime(Filename,"%d%m%Y_MOS.csv") 
| addinfo 
| where file_date>=info_min_time and file_date<info_max_time

My Sample Search :

| makeresults 
| eval _raw="Filename
11112021_MOS.csv
12112021_MOS.csv
13112021_MOS.csv" 
| multikv forceheader=1 
| table Filename 
| rename comment as "Upto now is for sample data only" 
| eval file_date= strptime(Filename,"%d%m%Y_MOS.csv") 
| addinfo 
| where file_date>=info_min_time and file_date<info_max_time

You have have different use case then please share more details on it.

Thanks
KV
▄︻̷̿┻̿═━一   😉

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.