Lianja

Find XML Element where Attribute = Value

See more XML Examples

Finds an XML element at a particular location where an attribute has a specified value. Lianja

llSuccess = .F.

// We have the following XML and wish to find the value of the time attribute where msg = "alert-from".

// <cdr id="4e5d3e7f41bf6201ad81000c29703270" e164="6207">
//     <user>
//         <grp name="wfln" mode="active"/>
//     </user>
//     <event msg="setup-to" time="287069" e164="5034"/>
//     <event msg="alert-from" time="287069" e164="5034"/>
//     <event msg="rel-to" time="287079" e164="5034"/>
// </cdr>

// First, build the above XML:

loXml = createobject("CkXml")
loXml.Tag = "cdr"
loXml.AddAttribute("id","4e5d3e7f41bf6201ad81000c29703270")
loXml.AddAttribute("e164","6207")
loXml.UpdateAttrAt("user|grp",.T.,"name","wfln")
loXml.UpdateAttrAt("user|grp",.T.,"mode","active")
loXml.UpdateAttrAt("event",.T.,"msg","setup-to")
loXml.UpdateAttrAt("event",.T.,"time","287069")
loXml.UpdateAttrAt("event",.T.,"e164","5034")
loXml.UpdateAttrAt("event[1]",.T.,"msg","alert-from")
loXml.UpdateAttrAt("event[1]",.T.,"time","287069")
loXml.UpdateAttrAt("event[1]",.T.,"e164","5034")
loXml.UpdateAttrAt("event[2]",.T.,"msg","rel-to")
loXml.UpdateAttrAt("event[2]",.T.,"time","287079")
loXml.UpdateAttrAt("event[2]",.T.,"e164","5034")

// Show that we have the above XML
? loXml.GetXml()

// Find the element where msg = "alert-from"
// This updates the xml object's reference to the found element (if successful).
lcNotUsed = loXml.ChilkatPath("/A/event,msg,alert-from|$")
if (loXml.LastMethodSuccess = .F.) then
    ? "Not found."
    release loXml
    return
endif

// Get the value of the "time" attribute.
? "time = " + loXml.GetAttrValue("time")

// Restore the xml object's internal reference to the root of the XML document
loXml.GetRoot2()


release loXml