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

[Ann Worley]

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.

[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