search

guilhemmarchand / TA-jira-service-desk-simple-addon

Atlasian JIRA add-on for Splunk alert actions
11 stars 8 forks source link

Passing DateTime picker from Dashboard through to query #125

Open hackforfood-uk opened 2 years ago

hackforfood-uk commented 2 years ago

Hello,

Loving the TA!

We are using it to do visualisations in Splunk as well as alert actions. The query is about passing through the date time picker to the API query so only returning issues created during that period. Have you tested this? I had a quick look but didn't get very far but thought I would ask before expending a lot more effort.

Thanks Peter.

guilhemmarchand commented 2 years ago

Hi @petegriggs !

Many thanks, glad you like it ;-)

We are using it to do visualisations in Splunk as well as alert actions. The query is about passing through the date time picker to the API query so only returning issues created during that period. Have you tested this? I had a quick look but didn't get very far but thought I would ask before expending a lot more effort.

That sounds fair, I had worked on something very similar to query ElasticSearch earlier, so I might be able to reproduce the same behaviour.

Would you have a sample jquery I can look at which contains a time concept as expected by Jira?

hackforfood-uk commented 2 years ago

Hi @guilhemmarchand

Here is a sample query: jql=created%20>%3D%202021-11-01%20AND%20created%20<%3D%202021-11-29%20order%20by%20created%20DESC

Basically reporting in JIRA isn't great and we want create dashboard in Splunk to some stats on and pretty visualisations :-)

Thanks Peter.

guilhemmarchand commented 2 years ago

Thanks @petegriggs

I will give it a check when possible, I have the following example of a custom command for ElasticSearch which is able to parse the time range picker or earliest / latest as optional args, it would be possible to take inspiration of it and adapt it to Jira I believe.

essrest.py.txt