Import Jira data with query on key

[Dick Lokhorst]

I use the add-in Jira Cloud and I want to import issuekey's started with fe. BLT
I thougth i could use "issuekey ~ BLT", however that is not allowed
How should i do that?

[Jack Brickey]

Hi @Dick Lokhorst , Jira Cloud isn't an add-on app. Unsure if you are talking about Jira Cloud or some actual add-on here. that said I'm unsure what you are asking. Do you want to import issues via CSV and specify a specific key#? If so, I have seen it mentioned within the community others have been able to successfully influence the numbering sequence using CSV import. To be honest, I have never attempted that until just now and my one attempt was unsuccessful. I did not have the option to map the issue key, only the issue ID which is not the same thing. All that said you might search the community for this topic to see if someone details exactly how this is done. I may take a moment to see if I can find a solution as well and will share here if I do find one.

[Jack Brickey]

I found and commented on this thread requesting more info - How-do-I-change-the-starting-issue-key-number 

[Jack Brickey]

@Dick Lokhorst ,

My bet is that this isn't possible but would welcome being wrong here. 

With that said, maybe you could explain a bit more about what you're actually trying to accomplish and why as there could be a different approach to your requirement.

[Jack Brickey]

OK so this is about entirely different subject than I first assumed. It is about using the Excel for Jira extension. 

your screenshots are not coming through.

If you are talking about forming a JQL query from within Excel please provide the full JQL here and explain what your goal is and what is not working. Indeed the approximate symbol is not valid for the issue key. If you were just trying to find issues for a given project just use project = ABC. 

[Dick Lokhorst]

screenshot

[Dick Lokhorst]

screenshot

---

[Jack Brickey]

If you are trying to insert an image click the picture icon and upload/insert.

[Dick Lokhorst]

[Jack Brickey]

That is an invalid JQL. Is BLT the project key? If so use "project = BLT". If BLT is in fact an Issuetype then use type = BLT. The "~" operator is for text fields only. Based on what you have indicated I believe you want project = BLT.

[Dick Lokhorst]

Great Jack, that'ss the solution.
Thank you for your support

[Jack Brickey]

Please consider accepting the answer above if this solved your issue.

[Dick Lokhorst]

Thanxs for you support Jack.

I am using https://appsource.microsoft.com/en-us/product/office/WA200000556?tab=Overview

Attached 2 screenshots.

If I use "~" for field summary it works fine.
If I do the same for field Issuetype it results in an error
"The operator '~' is not supported by the 'issuetype' field"