Controls

Re: Current Item in repeating group

Greg Collins — Tue, 28 Nov 2006 00:52:51 GMT

Is my:EmployeeSection a repeating node? If so, that's probably your troubles, as the value would be stored on a specific repeating node. Try having SetNamedNodeProperty store the value on the root node of your schema instead.

Re: Current Item in repeating group

spudy — Wed, 22 Nov 2006 23:18:30 GMT

I have tried the following expression within a rule on inserting a
new row in the master/detail table called 'hours'. I am trying to get
the value of UID from the other master/detail table called Employee.

The problem is that the default value (1)of the getnamednodeproperty
is being used. I have checked that the CTRLID is correct.

//my:EmployeeSection/my:Employee[(position() = xdXDocument:GetNamedNodeProperty
(../../my:External/my:EmployeeSection, "CTRL48_35",
1))]/my:EmployeeID

Any ideas?

Thanks Spudy

Re: Current Item in repeating group

spudy — Wed, 22 Nov 2006 11:33:15 GMT

I have the expression working fine now. Now I am trying to get that
value stored in some way that I can call on it elsewhere for
filtering and to insert a value from the row into another mster/detail table when a new row is inserted.

How can I store and reuse that row number as part of a filter and in
a rule?

I presume the way to do this would be to store the value as a global
variable through the oncontextchange event which I tried this but without success.

Thanks Spudy

Re: Current Item in repeating group

Greg Collins — Mon, 20 Nov 2006 17:55:32 GMT

Yes, once you have the position of the row, you can use that position in a filter (i.e. Table/Row[Number]/FieldOfInterest).

You are getting 1 back because somehow you are not connecting to the master table properly with your XPath, and you've specified 1 as teh default return value. When you look in your view .xsl file, you will find existing GetNamedNodeProperty methods for your master/detail controls. These existing methods can help you identify the correct XPath to get the row number you need.

Re: Current Item in repeating group

spudy — Fri, 17 Nov 2006 20:40:30 GMT

Having looked at another of your "how to" Select a Master Table Row via Code I got some more interesting pointers.

Using the expression :

xdXDocument:GetNamedNodeProperty(my:Members, "CTRL1_5", 1)

You were able to display the position of the currently selected row in the master data table.
I have found the control id for my table and replaced my:Members with my own group.
I tried the same but without success. What happens is that the expression always displays 1.
I am now thinking that if I can retrieve the position number in this way, when I insert a new row in my other master/detail table I can use the position reference to track down my UID.

It just feels like I am running about barking at all the trees in the wood now!

Re: Current Item in repeating group

spudy — Fri, 17 Nov 2006 19:02:52 GMT

Greg, Sorry I probably haven't conveyed very well what it is I need to do, and I appreciate your help with this.

I have a master/detail control which has a key field as a unique identifier.
There is then another master/detail control (pointing to a different repeating group) that stores the hours worked by individual employees and details about how those hours were spent.

When an employee is selected in the first master/detail control, I want to capture the UID for the current row.

Then when a new row is inserted in the other master/detail for hours, I can provide the UID for the employee added in order that I can cross reference the hours back to the employees.

Thanks Spudy

Re: Current Item in repeating group

Greg Collins — Fri, 17 Nov 2006 17:54:12 GMT

Hold on. Let's backtrack here. There's probably an easier way to do what you are doing built right into the master/detail control.

On the open the properties dialog for the detail section.
On the Master/Detail tab, you'll probably find that you have the relationship using the "position".
Change this relationship to use a "key field". Set the key field in both the master and detail to the the Employee node (or a more suitable node).
Be sure the check box is selected to copy the key field from the master when a new detail is inserted.

See if this gives you what you need.

Re: Current Item in repeating group

spudy — Fri, 17 Nov 2006 17:04:43 GMT

Greg,

I have tried without the slashes but it is still not working. I ventured further and a search of the website revealed one of your "how to" tutorials:

http://www.infopathdev.com/howto/tutorials/default.aspx?i=554349415b544aa18f2dff9a864bc9af

I suspect that this could be shaped somehow to resolve my problem.
Could you advise how I can set the value of a global variable to the acive fields actual value through using the oncontextchange event?

Thanks Spudy.

Re: Current Item in repeating group

Greg Collins — Thu, 16 Nov 2006 17:18:11 GMT

nodeName will never have slashes in it. You should check for .nodeName == "my:Employee".

Re: Current Item in repeating group

spudy — Thu, 16 Nov 2006 13:07:10 GMT

Greg,

I have a uid in field EmployeeID with parent node of Employee which is the master table. On selecting insert on the Hours master table I presume the oncontextchange event will be fired. In this code I am simply trying to place it in a node called CurrentEmployeeID - but it does not work.

Here is the code for the oncontextchange:

function XDocument::OnContextChange(eventObj)
{
var oContextNode = eventObj.Context;
	if (eventObj.Type == "ContextNode")
		{
		if (oContextNode.nodeName == "//my:Employee" )
		XDocument.DOM.selectSingleNode("//my:CurrentEmployeeID").nodeTypedValue = XDocument.DOM.selectSingleNode("//my:EmployeeID").nodeTypedValue ;
			return;
		}
}

thanks Spudy

Re: Current Item in repeating group

Greg Collins — Thu, 16 Nov 2006 00:42:00 GMT

Perhaps what you are looking for is the OnContextChange event.

Re: Current Item in repeating group

spudy — Wed, 15 Nov 2006 17:49:41 GMT

I tried that post, it has reference to the current() expression but I cannot get that working for me.

I have two master/detail controls. 'Employee' records personal information about staff. 'Hours' records information about the hours worked by the staff member selected in 'Employee'.

When the selection in 'Employee' has changed I need to capture the UID for the staff member so it can be used firstly to filter the 'Hours' master/detail control and then also as a key reference identifier if a new row is inserted into the 'Hours' master/detail control.

Spudy

Re: Current Item in repeating group

Shiva — Wed, 01 Nov 2006 06:55:33 GMT

Hi Spudy,

Can you check out this link get the more information,
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=47

Current Item in repeating group

spudy — Mon, 30 Oct 2006 08:35:40 GMT

I am looking to get the value of the current field in a master/detail repeating table from a different section of the form.

Can anyone help?

thanks SPudy