XPath query help with getting parent nodes

[mike]

Hello,
I am new to XPATH and am having a hard time selecting some nodes.
I want to select all the record nodes where Status = 'Unprocessed' or
'Queued' (that part I can get) but additionally I only want the ones
where the Field/Fieldname ='ChangeType' and Field/Value = 'SN'
I have //ExtractInfo/Record[Status='UnProcessed' or
Status='Queued']/Field[Fieldname='ChangeType' and Value='SN'] but that
gets the field nodes, I need the record nodes.
Below is a snippet of the abbreviated XML doc:
<Extract>
<ExtractInfo>
<Status>UnProcessed</Status>
<Record>
<RecordNumber>1</RecordNumber>
<Status>UnProcessed</Status>
<Field>
<Fieldname>ChangeType</Fieldname>
<Value>SM</Value>
</Field>
</Record>
<Record>
<Record>
<RecordNumber>2</RecordNumber>
<Status>UnProcessed</Status>
<Field>
<Fieldname>ChangeType</Fieldname>
<Value>SN</Value>
</Field>
</Record>
<Record>
</ExtractInfo>
</Extract>

Any help would be graetly appreciated

Thanks

 

[Martin Honnen]

I am new to XPATH and am having a hard time selecting some nodes.
I want to select all the record nodes where Status = 'Unprocessed' or
'Queued' (that part I can get) but additionally I only want the ones
where the Field/Fieldname ='ChangeType' and Field/Value = 'SN'
I have //ExtractInfo/Record[Status='UnProcessed' or
Status='Queued']/Field[Fieldname='ChangeType' and Value='SN'] but that
gets the field nodes, I need the record nodes.

//ExtractInfo/Record[
Status='UnProcessed' or Status='Queued' and
Field[Fieldname='ChangeType' and Value='SN']]

 

[Bjoern Hoehrmann]

* (e-mail address removed) wrote in comp.text.xml:

I am new to XPATH and am having a hard time selecting some nodes.
I want to select all the record nodes where Status = 'Unprocessed' or
'Queued' (that part I can get) but additionally I only want the ones
where the Field/Fieldname ='ChangeType' and Field/Value = 'SN'

You have to formulate these extra conditions as predicates like so:

//Record[ (Status = 'UnProcessed' or Status = 'Queued') and
Field[Fieldname = 'ChangeType' and Value = 'SN'] ]

 

[mike]

Thanks,
I was dancing all around it. the nested [] is what was tripping me up.

I am new to XPATH and am having a hard time selecting some nodes.
I want to select all the record nodes where Status = 'Unprocessed' or
'Queued' (that part I can get) but additionally I only want the ones
where the Field/Fieldname ='ChangeType' and Field/Value = 'SN'
I have //ExtractInfo/Record[Status='UnProcessed' or
Status='Queued']/Field[Fieldname='ChangeType' and Value='SN'] but that
gets the field nodes, I need the record nodes.

//ExtractInfo/Record[
Status='UnProcessed' or Status='Queued' and
Field[Fieldname='ChangeType' and Value='SN']]