How to access attributes using ExtractValue Function

[Wane cooper]

Hi..

The following is my xml file which i store it in column doc_content.
I am trying to fetch the attributes on any tag example( EventActionCode="C" EventDateTime="2001-12-17T09:30:47" EventOutcomeIndicator="0")....

How can i do this using ExtractValue function or is it even possible with mysql XML functions.

or do i have the change the XML structure or is there any other way.....

Please help...Any advice or suggestion is much needed and appreciated...


+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| doc_content | blob | NO | | NULL | |
| comment | varchar(100) | NO | | | |
+-------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

<?xml version="1.0" encoding="UTF-8"?>

<AuditMessage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="D:\data\DICOM\security\supplement95-schema.xsd">

<EventIdentification EventActionCode="C" EventDateTime="2001-12-17T09:30:47" EventOutcomeIndicator="0">
<EventID code="110104" codeSystemName="DCM" displayName="DICOM Instances Transferred" />
</EventIdentification>

<ActiveParticipant UserID="123" AlternativeUserID="AETITLE=AEFOO" UserIsRequestor="true"
NetworkAccessPointID="192.168.1.2" NetworkAccessPointTypeCode="2">
<RoleIDCode code="110153" codeSystemName="DCM" displayName="Source"/>
</ActiveParticipant>

<ActiveParticipant UserID="67562" AlternativeUserID="AETITLE=AEPACS" UserIsRequestor="false"
NetworkAccessPointID="192.168.1.5" NetworkAccessPointTypeCode="2">
<RoleIDCode code="110152" codeSystemName="DCM" displayName="Destination"/>
</ActiveParticipant>

<ActiveParticipant UserID="[e-mail]"
AlternativeUserID="smith@nema" UserName="Dr. Smith"
UserIsRequestor="true" NetworkAccessPointID="192.168.1.2"
NetworkAccessPointTypeCode="2">
<RoleIDCode code="110153" codeSystemName="DCM" displayName="Source"/>
</ActiveParticipant>

<AuditSourceIdentification AuditEnterpriseSiteID="Hospital" AuditSourceID="ReadingRoom">
<AuditSourceTypeCode code="1"/>
</AuditSourceIdentification>

<ParticipantObjectIdentification ParticipantObjectID="1.2.840.10008.2.3.4.5.6.7.78.8"
ParticipantObjectTypeCode="2" ParticipantObjectTypeCodeRole="3"
ParticipantObjectDataLifeCycle="1">
<ParticipantObjectIDTypeCode code="110180" codeSystemName="DCM" displayName="Study Instance
UID"/>

<ParticipantObjectDescription>
<MPPS UID="1.2.840.10008.1.2.3.4.5"/>
<Accession Number="12341234" />
<SOPClass UID="1.2.840.10008.5.1.4.1.1.2" NumberOfInstances="1500"/>
<SOPClass UID="1.2.840.10008.5.1.4.1.1.11.1" NumberOfInstances="3"/>
</ParticipantObjectDescription>

</ParticipantObjectIdentification>

<ParticipantObjectIdentification ParticipantObjectID="ptid12345" ParticipantObjectTypeCode="1" ParticipantObjectTypeCodeRole="1">
<ParticipantObjectIDTypeCode code="2" />
<ParticipantObjectName>John Doe</ParticipantObjectName>
</ParticipantObjectIdentification>

</AuditMessage>

Thanks