Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 log dialog responses RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ,

    I'm trying to find where does CRM log responses of dialogs, I found a filtered view called "FilteredProcessSession" but there are no logs for response fields I write in dialog.

    for example: I have a prompt question that has a response of type Boolean (yes,no) where CRM asks me to log the response when creating dialog or not. 

    Does CRM log the response from CRM user if he/she chooses Yes or No for that prompt field?

    Thanks.

    Zarour

    Sunday, January 19, 2014 8:19 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Zarour,

    Here is some sql that might assist you. The dialog responses are in the FilteredWorkflowLog.interactionactivityresult column but its denormalised data.

    SELECT 	a.name as dialogname, a.processsessionid, a.startedbyname, a.startedonutc,
	a.regardingobjectidname, b.stepname, b.description, b.interactionactivityresult
FROM 	FilteredProcessSession a
	LEFT JOIN FilteredWorkflowLog b 
		ON a.processsessionid = b.asyncoperationid

    Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

    • Marked as answer by zarour Sunday, January 19, 2014 4:30 PM
    Sunday, January 19, 2014 10:14 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Zarour,

    Here is some sql that might assist you. The dialog responses are in the FilteredWorkflowLog.interactionactivityresult column but its denormalised data.

    SELECT 	a.name as dialogname, a.processsessionid, a.startedbyname, a.startedonutc,
	a.regardingobjectidname, b.stepname, b.description, b.interactionactivityresult
FROM 	FilteredProcessSession a
	LEFT JOIN FilteredWorkflowLog b 
		ON a.processsessionid = b.asyncoperationid

    Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

    • Marked as answer by zarour Sunday, January 19, 2014 4:30 PM
    Sunday, January 19, 2014 10:14 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks it works.

    Zarour

    Sunday, January 19, 2014 4:30 PM