How to refer date picker in Cascade field ?

[Alik]

Hi all,

I want to refer date picker field in my multi cascade custom field. How can I choose date/time in multi level cascade field and how I can write query in SQL?

For example I have date picker custom field and I want to refer it in SQL query. In atlassian SQL developer documentation I can't find any information how SQL store dates in date picker (no information about tables). I don't want to show list of dates for choose I need to give date picker field inside of multi cascade field.

I think query will be similar like this

select datevalue from customfieldvalue where customfieldconfig=10501;

Documenation

https://developer.atlassian.com/server/jira/platform/database-custom-fields/

Thanks in advance,

Regards,

Alik 

[Mark Kern [SaaSJet]]

Hi @Moshe Rosenberg 

You can try add-on Issue History for Jira Cloud.
It gathered data about all issues changes in the one grid.
So you will needn't any more to go through each issue and manually extract this from history.

Let me know if it fits you

[Nic Brough -Adaptavist-]

This seems to be a broken question - the answers above are logged at two years before the question was asked, and the question seems to be the same as https://community.atlassian.com/t5/JIRA-questions/JIRA-Cloud-Issues-still-not-shown-in-backlog-after-being-mapped/qaq-p/461051

[Moshe Rosenberg]

Anyone?

[Moshe Rosenberg]

I have the Cloud version of JIRA, this is not available.

Any other ideas?

[Andrey Markelov]

Hello, here https://marketplace.atlassian.com/plugins/ru.andreymarkelov.atlas.plugins.datacollector there is the report for this. But only report.