Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Where customer satisfaction rating is stored in database

Hello! I'd like to query satisfaction rating for issues using sql. Where do I find the "stars"?

BR,

-Juha

2 answers

In CUSTOMFIELD table I have two fields which are relatable with satisfaction rating.

First it is SATISFACTION field (in my version of database: id = 11102), second it is SATISFACTION DATE field (id = 11103).

In CUSTOMFIELDVALUE table, value of SATISFACTION field is in STRINGVALUE column, value of SATISFACTION DATE field is in DATEVALUE column.

Example:

select
    p.pkey,
    ji.issuenum,
    ji.assignee,
    cfv.stringvalue  as "star",
    cfv2.datevalue
from
    customfieldvalue cfv
    join jiraissue ji on cfv.issue = ji.id
    join project p on ji.project = p.id
    join customfieldvalue cfv2 on ji.id = cfv2.issue and cfv2.customfield = 11103  
where
    cfv.customfield = 11102

Hi, @Anita Dzik - this actually works for me! Thank you!

I replaced your customfield ID using the following and I was able to get the STAR rating.

Capture.PNG

I then got the Customer feedback/comment part using the below SQL:

select
    p.pkey, i.issuenum,
    i.reporter,
    ep.json_value
from
    entity_property ep
    join jiraissue i
    on (i.id = ep.entity_id)
    join project p
    on (i.project = p.id)
where
   ep.property_key = 'service-request-feedback-comment'

 

Joined the tables together and was able to re-create the data displayed in the Satisfaction report.

0 votes

It looks like you are using Ovyka Satisfaction for JIRA.

The satisfaction ratings seem to be in the "AO_A36E36_FIELD_ANSWER" table in the INT_ANSWER column.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...

1,626 views 7 30
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you