CODEWITHSUNDEEP
dynamics-crm-2011dynamics-crmdynamics-crm-2013dynamics-crm-onlinedynamics-crm-2015
Mani
Mani

Reputation: 379

Export/See Dynamics CRM dialog responses

I have a customer survey dialog associated to the case entity. Is it possible to see/export the responses recorded through dialogs in Dynamics CRM?

Upvotes: 1

Views: 221

Answers (1)

Piotr Gaszewski
Piotr Gaszewski

Reputation: 343

Dialog responses are stored in CRM Database. You can access this data with the following query:

SELECT
fps.name
,fps.processsessionid
,fps.startedbyname
,fps.startedonutc
,fps.regardingobjectidname
,fwl.stepname
,fwl.description
,fwl.interactionactivityresult
FROM dbo.FilteredProcessSession fps
LEFT JOIN dbo.FilteredWorkflowLog fwl ON fps.processsessionid = fwl.asyncoperationid

Unfortunately, answers are stored as XML formatted text so it will require some extra effort to access required information.

Example:

<interactionResponse promptText="How do you do?" label="I am well. Thank you!" type="string" value=" I am well. Thank you!" />

Above mentioned information may be also accessed using Dynamics 365/CRM SDK.

My recommendation is to use custom entity (ex. “Interview Answer”) to log required information. If you do this, you will be able to query dialog results just from the CRM UI.

Upvotes: 1

Related Questions