February 9, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...How to query the feedback data of the workflowHow to query the feedback data of the workflow
Previous Previous
 
Next Next
New Post
 8/29/2008 12:52 PM
 

Hi Experts,

I met a problem. I created a workflow on a list by applying Sharepoint's workflow template - "Collect User Feedback". On this workflow, I could trigger a task to collect the user's feedback. But while I query the task list on SSRS, why couldn't I see the user's feedback data on this list, but could only see the workflow initiator's request data on it.

Do you have the idea how to query the user's feedback data on this workflow in Sharepoint?

Thanks in advance,

2008/8/29

Steve Wang

New Post
 8/29/2008 4:02 PM
 
 Modified By Frédéric LATOUR  on 8/29/2008 3:04:34 PM

Hi,

I have written a new complete KB article available here. It explains how to get user's feedback or any other extended properties from OOTB workflows.

Let me know if this helps.

Regards,

 


Frederic LATOUR
ENESYS
New Post
 9/1/2008 11:58 AM
 

Hi Frederic,

Thanks for your KB article share, it looks cool and almost fits my need. Because while I use your sample RDL to query my own workflow data, I found the comment field will show on the report while the content of this filed is single line data, but failed to show while it is multi lines data. Take below 2 cases for example, the 1st one works and the 2nd one fails. I wonder if it is because the match function you used on your custom code, which cannot parse the complicated data like this. Any of your comment is much appreciated.

Case 1: 'This is a test workflow'

Case 2: 'Hi pals,

We got an issue  and submitted to LLS.
Let's have a cross-project check with the current projects.
Please feed back your check comment/result, like any ITS#/risk.

Thank you in advance for your help in this matter.

Sincerely,
Steve
I will discuss with you later.
'

Steve Wang 2008/09/01

New Post
 9/2/2008 2:39 PM
 

Hi,

Using Singleline RegexOptions should do the trick:

Public Function GetExtendedPropertyValue(ByVal s As String, ByVal propertyName As String) As String

    Dim myMatch As System.Text.RegularExpressions.Match = _
        System.Text.RegularExpressions.Regex.Match(s, "ows_" & propertyName & "=[\'](.*?)[\']", System.Text.RegularExpressions.RegexOptions.Singleline )
    If myMatch.Success Then
        return myMatch.Groups(1).ToString()
    Else
        return ""
    End If
End Function

I will update the report in the KB article.

Let me know if it works for you.

Regards,


Frederic LATOUR
ENESYS
New Post
 9/2/2008 3:26 PM
 

Hi Frederic,

It works like a charm.Thanks a lot, and it did great help.

Thanks,

Steve Wang 2008/09/02

Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...How to query the feedback data of the workflowHow to query the feedback data of the workflow

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement