Getting the difference of dates between 1 custom date and due date using a JQL query

[Asha]

hi,

i have created a custom date called, Commit Date and I want to get the difference between commit date and due date . Can you let me know how this can be built using a jql query

[Bastian Stehmann · Accepted solution]

Hi @[deleted],

did you map the status-column in your csv to the status-field in Jira while import? Maybe you can try to check the "Map field value" box on the Mapping-Page of the Import Wizard, then you can do/check the Mapping for each status.

[Deleted user]

Hi @Bastian Stehmann,

thank you for your reply, yes i have mapped the "status-colum" from my csv-file to the jira.field "Status".

in the configuration backup i can also see that i have mapped this.

--- Konfig Backupfile ---

"state" : {
"jira.field" : "status"

--

and later i can see :

"state" : {
"Beauftragt" : "11021",
"Abgenommen" : "11021",
"Blockiert" : "11021",
"Erledigt" : "11021",
"Bewertung" : "11021",
"Neu" : "11021",
"In Bearbeitung" : "11021"
},

But i havent seen the check page. I will try again und check it out.

[Deleted user]

HI @Bastian Stehmann,

thank you for your help, that was the problem the mapping site was too full so that i did not saw this part :(

[Bastian Stehmann]

Hi @[deleted],

don't worry, we are glad if we can help you here. Good to hear that it works now as expected.