You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
when I use the following in an excel cell, the task pane just says "1 of 1 rows imported. Saving..." and never actually brings back the query result.
=JIRA.JQL("issuekey=QI-695","summary")
I get a momentary #BUSY! message in the cell, then an "Import started at..." message in the cell. That's all.
I'm just trying to insert the Summary field value into the excel cell, not bring back a table or a property for multiple issues.
Edit: I tried this a different way, using a blank workbook and the following was the result, using 4 cells -- the cell I used the formula in, plus the 3 cells below it. This is not what is expected. Why would the 1st 3 rows come back from this usage? It seems poorly implemented if this is what was expected.
Import started at November 14, 2019 2:25 PM by Rob Wickham |
1 rows imported in 2 seconds |
Summary |
Risk management and customer requirements embedded within each process definition |
@Rob Wickham , just looking to clean up old issues. Is this stigma question for you or did you find the answer?
I stopped using it altogether because it didn't feel ready for prime time. Has the code improved in the last 2 years?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Found myself looking for an answer to this and arrived here - still seems to be the same, i.e. 3 additional/unwanted/useless rows output - what is the point of these?!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The sharepoint which is supposed to be pointing to the documentation/examples no longer exists.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It's definitely been implemented with the expectation of returning a table of results, rather than a single field for a single entry. I see two ways to get round this...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.