.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Windows Workflow Tracking User Data and fetching via SqlTrackingQueryOption

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :WPF

We are using WF in one of our application. We would like to track user data so that when we query via SqlTrackingQuery, we get the desired workflows only but the issue is that Activity.TrackData is not writing to the TrackingDataItem table instead it writes to the UserEvent table. When we use the SqlTrackingQueryOption and set the TrackingDataItems property it does not return any value as it makes a join to the TrackingDataItem table. This i have figured out by using Reflector.exe. Could u kindly tell us what we are doing wrong. We will be very gratefull.

P.S. I can also submit the code if requested.

View Complete Post

More Related Resource Links

Modify User in Collect Data from User Workflow


I've created a workflow with a Collect Data from User action that emails a Group when the task is created. Once the task is claimed by an individual, the Assigned To column in the task list is updated to display that person's name but once the task is completed the email variable for the action is not updated and the group is emailed instead of the person listed as Assigned To.

So the question is this: Is there a way to update the user varialbe in the workflow task once the task is completed, or would I need to build my own workflow and use the Send Email action?

Share Point Designer 2007 Workflow (Sequential) - multi-collect data from user

I am currently building a multi-step workflow using ShrePoint designer for MOSS2007. I am getting a bit confused as to if I have an error or if I am doing something incorrect. Here is what I have going. My workflow consists of something similar to the following New document comes in, a collect data from user routine is ran and assigned to a reviewer. My understanding when I create a collect data from user WorkFlow step is any data I request is saved in the "Tasks" list. Therefore I need to grab the workflow task ID in order to later lookup what the reviewer submitted... I understand this...   However, I have one more collect data from user workflow step and I have one more item to collect. Even though this is a brand new collect data from user workflow step - does the collected data still go into the "Tasks" list? In other words, if I have two steps in a workflow and both of these steps are "collect data from user", does the data from both steps go into the same "Tasks" list?  I could see how this might be possible as long as the Task list columns contain all the items for all the different "collect" data from user steps.  I don't see two different Tasks lists representing or named "Reviewer" or "Final" or anything, so I assume the items are all in "Tasks"   However..

How can I show data from a Workflow variable in a Collect Data from User form?



I have collected some data from a user in a SharePoint Designer workflow step and I now want to display that data in a second "Collect Data from User" form at a subsequent step in my workflow.  How can I add the content of my Workflow data variable in the Collect Data from user form?

This guy says he has done something similar but does not explain the detail: http://www.mstechblogs.com/paul/spd-workflow-collect-data-from-a-user-modify-the-generated-task-form

I'm keen to hack at the aspx form in SPD but I really need the particular line of code that will do it as I'm not a developer.

Your help is greatly appreciated!

How can I show data from a Workflow variable in a SharePoint Designer Collect Data from User form?



I have collected some data (a comment) from a user in a SharePoint Designer (SPD) workflow step and I now want to display that comment in a second "Collect Data from User" form at a subsequent step in my workflow.  How can I add the content of my Workflow data variable, or even data from my original item, in the Collect Data from user form?

The Collect Data from user form is generated out of the Workflow Tasks list and only contains the url of the item where I could store the comment and which has the workflow attached to it.

This guy says he has done something similar but he appears to only use the URL and static info and does not explain the detail in any case: http://www.mstechblogs.com/paul/spd-workflow-collect-data-from-a-user-modify-the-generated-task-form

I'm keen to hack at the aspx form in SPD but I really need the particular line of code that will do it as I'm not a developer.

Your help is greatly appreciated!

Linq - add data to database then email user the details


Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 


Thanks in advance for your help,




logged in user data


I'm using the defualt membership provider, i created a table and used the gridview on the logged in user page to show his information such as address e-mail phone zip code etc,, how can i do this without writing a code?

I am new to asp.net  i need simple help please?

Storing User Data



I'm trying to get the current logged in UserId Value, using this code

Protected Sub UserProfileDataSource_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles UserProfileDataSource.Selecting      ' Get a reference to the currently logged on user      Dim currentUser As MembershipUser = Membership.GetUser()      ' Determine the currently logged on user's UserId value      Dim currentUserId As Guid = CType(currentUser.ProviderUserKey, Guid)      ' Assign the currently logged on user's UserId to the @UserId parameter      e.Command.Parameters("@UserId").Value = currentUserId End Sub

But, I getting an error (NullReferenceException), I did set a url authorization on the page that i try to get the logged in user information, witch is info.aspx, and I made the login.aspx control to be redirected to the info.aspx after the login process, But the info.aspx  only shows me (access in denied), how can i make this page knows that i am already logged in?

Persist data in a dynamically populated ListBox in a user control


Hi All,

I am trying to persist data in a dynamically populated ListBox in a user control. Here are the details

I have a user control which contains a a listBox and button. On Page_Load of user control I am populating the ListBox control with some values. On Click of button, I am trying to fetch the values which I have selected in ListBox. Though this seems very simple and straight forward I am unable to fetch values.

My Page_Load Function

void Page_Load(object sender, EventArgs e)










My Click Function

Protected Void Button1_Click(object sender, EventArgs e)


       string strValue = listBox.SelectedValue



I have placed brake point at Page_Load and on click function, I am seeing that the moment the breakpoin

Fetching the Currently Logged in user Email


Hey Frnds,

I am using the System.DirectoryServices.UserPrincipal.Current.EmailAddress to fetch the Currently logged in users email from AD.

If  debug my sol am getting the Exact mail id of that Particular user for ex:john@in.domain.com.

If i host My Application on iis

And Access my App am getting some other Email id instead of the john@in.domain.com.

I have changed the Application Pool identity to NetWorkService.

Can any one tell what could be wrong




No ASPNET User in Windows Server 2008?


I have been looking everywhere online regarding this, but have not found a clear answer.


I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.


I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.


I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.


Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 

Data Points: Windows Azure Table Storage - Not Your Father's Database


Let go of your traditional relational database thinking if you want to understand how Windows Azure Table storage works, says Julie Lerman. Luckily for you, she's done the hard work to grasp the new concepts and help you get up to speed.

Julie Lerman

MSDN Magazine July 2010

Cloud Security: Crypto Services and Data Security in Windows Azure


Many early adopters cloud platforms have questions about security. We review some of the cryptography services and providers in Windows Azure along with some security implications for applications in the cloud.

Jonathan Wiggs

MSDN Magazine January 2010

Foundations: Windows Workflow Design Patterns


Design patterns provide a common, repeatable approach to solving software development tasks, and many different patterns can describe how to accomplish a certain goal in code. When developers begin working with Windows Workflow Foundation (WF), they often ask about how to accomplish common tasks with the technology. This month's column discusses several design patterns used in WF.

Matthew Milner

MSDN Magazine August 2009

Real-World WF: Best Practices For Windows Workflow Foundation Apps


The heart of Windows Workflow Foundation is its declarative programming model. Here are some best practices to consider when using WF to realize software solutions in the real world.

Josh Lane

MSDN Magazine December 2008

WF How-To: Building State Machines with Windows Workflow Foundation


State Machine workflows represent a different way of visualizing program logic. Rather than flowing from activity to activity like sequential workflows, State Machines transition from state to state. Learn about uses for State machines and see how to design and build a State Machine workflow with Windows Workflow Foundation.

Keith Pijanowski

MSDN Magazine February 2008

Least Privilege: Teach Your Apps To Play Nicely With Windows Vista User Account Control


User Account Control in Windows Vista keeps the OS safe from intentional and accidental configuration changes.

Chris Corio

MSDN Magazine January 2007

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend