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