InfoPath Dev

I have a field called Assigned To and Assigned Date as fields in a form. And i have a repeating group Workflowhistories->WorkflowHistory(HistoryAssignedTo, HistoryAssignedDate)

When ever there is a change in Assigned To and Assigned Date , I want the changes stored in the HistoryAssignedTo, HistoryAssignedDate.

Kind of keeping track of the changes. Like Audit Trail.

Is there some code there to do this.

What will be the best design to implement this.

Appreciate any help.

Hi

View the following link.i hope this will help You.

http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2994&SearchTerms=History

Hi rajthayi,

You need to write one function in Onload to maintain history like audit trial. This function every time adds the WorkFlowHistory node.

AddWorkFlowHistoryNode()
{
//Get the first work flow history node
IXMLDOMNode previousWorkFlowHistoryNode = thisXDocument.DOM.selectSingleNode("my:myFields/my:WorkFlowHistories/my:WorkFlowHistory[1]");

//Get the work flow history node form sample data.
//You need to write code form this function to get the empty WorkFlowHistory node from Sample Data.
IXMLDOMNode workFlowHistoryNode = GetNodeFromSampleData("my:myFields/my:WorkFlowHistories/my:WorkFlowHistory");

//If You want to set the ‘Assigned To#%92 and ‘Assigned Date#%92 field values to ‘workFlowHistoryNode#%92 before inserting this node to WorkFlowHistoryNode.

previousWorkFlowHistoryNode.insertBefore(workFlowHistoryNode, previousWorkFlowHistoryNode);
}

Hi Rajthayi and welcome to our forum,
Madhuri and Shiva's replies are a good start. Audit Trails are also covered in Chapter 10 of our book - Developing Solutions with InfoPath. Our Database Accelerator suite includes Audit Trail support out of the box. Send me e-mail if you want more informaiton.

I did purchase the book that you mentioned. I will look at the example and try to implement this feature.

Thanks for your prompt response and help.