Incorrect 'assignee' and 'creator' values in 'jiraissue' table

[Vadim Shtukan]

Hello. I have some weird values in table 'jiraissue' for one of users.

It doesnt show his username, but his id.

screenshot-1.png

Although this ID isnt the same id, as id for this user from cwd_user table.

[Nic Brough -Adaptavist- · Accepted solution]

Yes, that's a function of older data and can happen in cases where users are being moved around (renamed, deleted, directories etc)

This is one of many reasons that you should not be reading the database.  It's not built for reporting.

[Vadim Shtukan]

Thanks for the answer. Can you suggest somethink that will be usable for reporting?

[Nic Brough -Adaptavist-]

Use the API - internal if you're on server and happy to code in there, or REST if you are on Cloud, or don't want to code internally.  Or take a look in the marketplace for add-ons that can do what you want to report on.