nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Incorrect value in reporter, assignee and creator column in jiraissue table

Vishal Petkar_8pi2h6

Hello Everyone,

I am facing one issue with Jira

In reporter, assignee and creator columns of a jiraissue table getting invalid value like JIRAUSERXXXX.

These columns should have a value like vpetkar something like that username. This is happening for some of the records only.

These invalid values are showing correct username on view page of Jira but in gadget reports getting the invalid values.

Accepted answers

All comments

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

If they are showing the right name on view, then they are not wrong.

Why are you looking at the database? It is the worst possible way to do any reporting on Atlassian systems, precisely because of this sort of thing.

Vishal Petkar_8pi2h6

Reporting means, on Jira dashboard, while exporting report using gadgets that time I am getting the values of reporter as JIRAUSERXXXX.

I created a view where I map the reporter field to export the data in gadget report.

Nic Brough -Adaptavist-

OK, I'm not sure what you mean by "map the reporter field to export the data in gadget report".

A dashboard contains a load of gadgets. Some of them can display fields like the reporter and assignee. There's no mapping or export in there.

Could you explain a little further? Maybe a screenshot of a gadget doing this? (Include the header so we know what type of gadget it is if it is not obvious, like the pie chart, but feel free to obscure text we don't need to see)

Vishal Petkar_8pi2h6

its a custom gadget I created like a custom field using a script.

Using .xml file I created this gadget, while add gadget on dashboard, it shows in a list.

From there I am adding it on dashboard and in that gadget, selecting the dates from and to, then using download report button, its downloading the issues for that particular date range in a excel file.

So to download this report, I have created a view in database and using that to export the data in excel file of custom gadget.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

confluence-server

jira