Where customer satisfaction rating is stored in database

[Juha Lastuniemi]

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

BR,

-Juha

[Anita Dzik]

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

[Mary Joycelyn Bunag]

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.

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.

[AnnWorley]

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.