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??
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 epjoin jiraissue ion (i.id = ep.entity_id)join project pon (i.project = p.id)where ep.property_key = 'service-request-feedback-comment'
Hi Brant,
Do you know how can I get from database all issues with number of satisfaction stars?
I'm also interested in how to grab the satisfaction number from the db
It looks like you're new here. Sign in or register to get started.
