I have created a filter in Jira and download the excel. But couple of issue type field which are in the screen tab are appearing in the issue type all view in the browser. But when I download the excel file, those screen tab fields are not appearing.
Could you please tell how to resolve this issue?
Tabs only apply to the screens an issue uses. They do no affect the issue navigator or excel output.
Could you check that the "missing" field is definitely appearing in the issue navigator and is not shown when you downloadd ALL fields?
And, again, could you tell us what type of fields they are?
Ok, which type of date is it? Updated, Created, Due, or is it a custom field you have added? If it is a custom field, then what exactly is the type (go to custom fields, and look in the "type" column - it'll say something like "date picker")
Also, could you go to the issue navigator with your search. Make sure that at least one issue in the results has the date field set, and that it is showing in the navigator. Then choose the "XML" view from near the Excel view link at the top. Either save it and open it, or view it in the browser - it's a bit horrible for a human to read the xml, but we're looking to see if the data comes out in plain xml at all.
Thanks for your reply.
According to your suggestions, I have got the following findings.
1. The filed is custom filed "type" column - it'll say something like "date picker".
2. I have downloaded the XML and the field is avaialble there.
3. I am using Jira 4.02 - in case that could help you out to find a solution.
4. I have created a new filter again and downloaded the excel but still the date field is missing.
Thanks for your prompt reply.
You problem is probably due to the field not being available for all issues types in your filter results. If a field is not available for all issue types in the results, then it gets hidden. Try to change your filter to only include a specific issue type that has the field first.
Hmm, so what does it actually say in the type column? (I think you've pasted in my question and not typed an answer over)
So, the same filter gives us results on-screen and in XML, but not excel. That implies the field doesn't have an XML output template or is deliberately surpressed (which is why I keep asking about the type - there's no way to know without knowing the exact type)
Jira 4.02 shouldn't be a problem, unless there is a bug in the Excel output related to date outputs. I do remember one from Jira 3.3 which did exactly this with one type of field, but I know it was fixed by 3.6. I've also managed to write plugins that do the same, but I doubt you're suffering from my coding!
New filter - good test, worth a try!
Thanks for your reply.
In the tab there are couple of fields:
1. Text Field - Type: Text Field (< 255 characters)
2. Date field - Type: Date Time
3. Check box: Multi Checkboxes
Besically, values of tab fields are missing.
If you have any other query please let me know.
Thanks in advance
I don't know why you keep talking about tabs - they have nothing to do with the issue navigator.
Anyway, these three fields are all standard custom field types and should appear in an excel export if they are appearing in the navigator before you click one of the excel export links.
So I'm a bit stuck. They should be there. The only things I can think of that might be breaking it are customisations - do you have any 3rd party plugins or code changes?
Could you also read the log file and check there are no errors in there when you run one of the excel downloads.
I've had the same issue just now where the custom field appears on the issue navigator but doesn't output to excel. Only if I put the customfield is not empty then I get the values come up on excel. Just to confirm the number of issues for the two searches are the same:
search 1 - project = XYZ and "Customfield" is not EMPTY
search 2 - project = XYZ
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs