JIRA Service Desk: Customer Satisfaction Surveys

[Renee' Finlay]

Can JIRA Customer Satisfaction Survey results be pushed back to an "on-premise instance" of Microsoft Dynamics CRM and tied to the original Case that generated the survey??

[Brant Schroeder]

Renee,

Unfortunately there is no way of doing this without building your own service that hits or is triggered by the DB.  The current JIRA Service Desk API does not have any support for accessing customer satisfaction.  You could query the DB and use a batch load to your CRM or create your own service to pull the information you are looking for until Atlassian adds customer satisfaction to their API.

You can also check the marketplace as there are a number of add-ons for surveys that may provide the functionality you are seeking.

The following DB query will give you all issues (and the issues project) that have a Satisfaction Comment added.

select p.pkey, 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'

[Anita Dzik]

Hi Brant,

Do you know how can I get from database all issues with number of satisfaction stars?

[kembles05]

I'm also interested in how to grab the satisfaction number from the db