Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,774
Community Members
 
Community Events
168
Community Groups

Flagged status in the Jira Database Schema

I am trying to determine time in "Flagged" status as well as including the flagged comment. Where can I find this information in the Jira Database Schema? We're on 8.13...

 

 

1 answer

0 votes

@claw

 

Flagged is just a custom field, so it would be in the customfieldvalue table. For the comment added with a Flag, I'm not sure how to gather that from the database. It looks like they are just stored comment formatted as "(flag) Flag added... the rest of the comment". 

 

I guess you could search the comments to try and find those that match the format I gave above.

Thanks @Kian Stack Mumo Systems , I wasn't able to find anything in the table customfieldvalue in the field textvalue where like "(flag)", but it may be an internal issue.

I wasn't able to find anything like "flag" or "impediment" in the customfield table under cfname. is it possible we aren't passing the information to the jira database? Do settings need to be altered?

@claw

You would need to look in the table where comments are stored (jiraaction I believe), not in the customfieldvalue table.

@Kian Stack Mumo Systems 

Thanks again for your efforts here. I did find the notes in jiraaction. 

We're still struggling to find when it entered a flagged status or exited. We're not seeing a CFNAME "Flagged" or anything like it in customfield. 

We see it in the UI under "History" (EG "Flagged  -   Impediment [ 10000 ]" with a timestamp). Also in "Activity"

Ideally it would be in the CHANGEITEM table, or something like it....

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

4,955 views 18 31
Read article

Atlassian Community Events