XML XPath Subquery 1

[duggied]

Hello folks. I'm fairly new to xml, so I'm not sure if what I am try to do is even possible.

Basicallly I have the following XML (see below) and I'm trying to filter all the fields where the attribute dependatforms = the forms id attribute.
Attempted XPath query: autoforms/fields/*[autoforms/forms/form/(@id=@dependantforms)]

<?xml version="1.0" encoding="utf-8" ?> 
<autoforms>
	<forms>
		<form text="Server Name Request Form" id="ServerName" showdependantfields="No" showduplicatefieldsacrossforms="No" columns="2" />
		<form text="Server Checklist Request Form" id="ServerChecklist" showdependantfields="No" showduplicatefieldsacrossforms="No" columns="2" />
	<fields>
		<textbox id="sname" text="Server Name: " required="Yes" requirederrormessage="* Required"  dependantforms="ServerName" />
		<textbox id="testfield" text="Test Field: " required="Yes" requirederrormessage="* Required"  dependantforms="ServerName" />
	</fields>
</autoforms>

 

[JontyMC]

It's not clear what nodeset you are looking for. Do you want to select all <textbox> that have @dependantforms = any of the form/@id ? If so, this will do it:

autoforms/fields/textbox[@dependantforms = ../../forms/@id]

Jon

"I don't regret this, but I both rue and lament it.

 

[duggied]

Thanks Jon,

Would it work to do a contains in the filter expression?

autoforms/fields/textbox[contains(@dependantforms,../../forms/@id)]

The reason being, although not clear in my posted xml, the dependant forms attribute could be

dependantforms="ServerName,ServerChecklist"

 

[duggied]

I tested contains with an XPath query analyzer and it works! Great!

Ok, last question how do I combine two filter expressions?

autoforms/fields/*[contains(@dependantforms,../../forms/@id)]and[contains(@memberforms,'ServerName')]

 

[JontyMC]

Two ways:

autoforms/fields/*[contains(@dependantforms,../../forms/@id) and contains(@memberforms,'ServerName')]

Or:

autoforms/fields/*[contains(@dependantforms,../../forms/@id)][contains(@memberforms,'ServerName')]

Jon

"I don't regret this, but I both rue and lament it.

 

[duggied]

Why isn't this query working? It's returning all three nodes, but should only be returning 1.

autoforms/fields/*[not(contains(../../forms/@id,@dependantforms)) and contains(@memberforms,'JoinDomain')]

It should return the fields nodes where the memberforms attribute contains JoinDomain, but it's dependantforms attribute does not match any ids in the forms node.

<?xml version="1.0" encoding="utf-8" ?> 
<autoforms>
	<forms>
		<form text="Server Name Request Form" id="ServerName" />
		<form text="Join Domain Request Form" id="JoinDomain" />
	</forms>
	<fields>
		<textbox id="sname" text="Server Name: " memberforms="JoinDomain" dependantforms="ServerName" />
		<dropdownlist id="OU" text="OU: " memberforms="JoinDomain" dependantforms="---" />
		<textbox id="password" text="Domain Password: " memberforms="JoinDomain" dependantforms="ServerName" />
	</fields>
</autoforms>

 

[JontyMC]

Your XPath is incorrect:

autoforms/fields/*[not(contains(../../forms/[COLOR=#ff0000]form/[/color]@id,@dependantforms)) and contains(@memberforms,'JoinDomain')]

Jon

"I don't regret this, but I both rue and lament it.