cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bfsmith9
Frequent Visitor

Infopath database form extract field - XPath bug!

I have a (many) InfoPath database form that is also submitted to a form library. Having trouble getting the syntax/code correct to extract some field. Although there are many repeating rows from table, I am only interested in the one table that does not have repeating rows. And for starters just the ClassName field. In bold in the xml file below.  I am using a "Get file content using path" component to retrieve the xml file...which appears to work

 

Here is my xpath (from InfoPath Designer) : /dfs:myFields/dfs:dataFields/d:tblCourse/@ClassName

 

Here is my xpath expression that does not work : xpath("@{body('Get_file_content_using_path_course_xml')}","/dfs:myFields/dfs:dataFields/d:tblCourse/@ClassName"

 

Here is the xml file:

<?xml version="1.0" encoding="UTF-8"?><?mso-infoPathSolution solutionVersion="1.0.0.184" productVersion="15.0.0" PIVersion="1.0.0.0" href="http://cme/scma/InfoPath/CourseMaintenance.xsn" name="urn:schemas-microsoft-com:office:infopath:CourseMaintenance:-dataFormSolution" ?><?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.3"?><dfs:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields" xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:xdado="http://schemas.microsoft.com/office/infopath/2003/adomapping" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-06-07T17:19:34" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us">
<dfs:queryFields>
<q:tblCourse CourseID="" ClassID="" CourseDateTime="" Venue="" City="" State="" Zip="" Notes="" ClassHours="" ClassName="" ActivityType="" JointSponsorshipOrganization="" ActivityTypeDescription="" Coordinator="" ClassHours_ControlledSubstanceTraining="" OnlineRegistration=""></q:tblCourse>
<q:tblCourseRates RateID="" CourseID="" RateNumber="" Rate="" Notes="" MemberRate="" ExpirationDate=""></q:tblCourseRates>
<q:tblCourseLectures LectureID="" CourseID="" LectureNumber="" LectureName="" LectureDescription="" DurationHours=""></q:tblCourseLectures>
<q:tblCourseLectureInstructors InstructorsID="" CourseID="" LectureID="" PersonID="" InstructorNumber="" FullName="" Notes=""></q:tblCourseLectureInstructors>
<q:tblCourseLectureObjectives ObjectiveID="" CourseID="" LectureID="" ObjectiveNumber="" Objective=""></q:tblCourseLectureObjectives>
</dfs:queryFields>
<dfs:dataFields>
<d:tblCourse CourseID="2120" ClassID="482" CourseDateTime="2019-08-02T07:00:00" Venue="Marriott Grande Dunes" City="Myrtle Beach" State="SC" Zip="" Notes="" ClassHours="4.5" ClassName="2019 SC/NC Societies of Otolaryngology Annual Meeting - Day 1" ActivityType="C" JointSponsorshipOrganization="SC Society of Otolaryngology" ActivityTypeDescription="Live Course" Coordinator="Pam Pendleton" ClassHours_ControlledSubstanceTraining="" OnlineRegistration="" xdado:OZtwZgb="0">
<d:tblCourseRates RateID="1277" CourseID="2120" RateNumber="1" Rate="0" Notes="" MemberRate="" ExpirationDate="" xdado:OZtwZgb="1"></d:tblCourseRates>
<d:tblCourseLectures LectureID="2136" CourseID="2120" LectureNumber="1" LectureName="Sialendoscopy With Introductal Steriod Irrigation In Patients With Sialadentis Without Sialadentis" LectureDescription="" DurationHours="" xdado:OZtwZgb="2">
<d:tblCourseLectureInstructors InstructorsID="2811" CourseID="2120" LectureID="2136" PersonID="57020" InstructorNumber="1" FullName="Torrey L. Fourrier, MD" Notes="" xdado:OZtwZgb="3"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5479" CourseID="2120" LectureID="2136" ObjectiveNumber="1" Objective="Review current literature on the uses of sialendoscopy with an emphasis on recent research on its use with autoimmune presentations." xdado:OZtwZgb="4"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2137" CourseID="2120" LectureNumber="2" LectureName="Voice Outcomes Following Surgical Intervention Involving the Upper Esophageal Sphincter" LectureDescription="" DurationHours="" xdado:OZtwZgb="5">
<d:tblCourseLectureInstructors InstructorsID="2812" CourseID="2120" LectureID="2137" PersonID="57022" InstructorNumber="1" FullName="Gabriella M. DeVries, MD" Notes="" xdado:OZtwZgb="6"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5480" CourseID="2120" LectureID="2137" ObjectiveNumber="1" Objective="Review pre-operative and post-operative assessments including RSI, VHI-10 and how EAT-10 demonstrates improvement regarding quality of voice following surgical intervention involving the upper esophageal sphincter." xdado:OZtwZgb="7"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2138" CourseID="2120" LectureNumber="3" LectureName="Perinatal Surgical Intervention In Pierre Robin Sequence" LectureDescription="" DurationHours="" xdado:OZtwZgb="8">
<d:tblCourseLectureInstructors InstructorsID="2813" CourseID="2120" LectureID="2138" PersonID="57023" InstructorNumber="1" FullName="Brian Hernandez, MD" Notes="" xdado:OZtwZgb="9"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5481" CourseID="2120" LectureID="2138" ObjectiveNumber="1" Objective="Present experience in the multidisciplinary treatment of children with Pierre Robin Syndrome since 2012 with the aim of presenting data correlating prenatal raqdiograqphic measures and the need for airway interventions." xdado:OZtwZgb="10"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2139" CourseID="2120" LectureNumber="4" LectureName="Clinician Adherence to the Clinical Practice Guideline: Acute Otis Externa" LectureDescription="" DurationHours="" xdado:OZtwZgb="11">
<d:tblCourseLectureInstructors InstructorsID="2814" CourseID="2120" LectureID="2139" PersonID="57024" InstructorNumber="1" FullName="Nicholas Mildenhall, MD" Notes="" xdado:OZtwZgb="12"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5482" CourseID="2120" LectureID="2139" ObjectiveNumber="1" Objective="Discuss the role and efficacy of clinical practice guidelines, specifically related to the guideline for acute otitis externa, as well as considerations for improved distribution and adherence." xdado:OZtwZgb="13"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2140" CourseID="2120" LectureNumber="5" LectureName="SNOT-22 Subdomain Outcomes After Endonasal Endoscopic Skull Base Surgery" LectureDescription="" DurationHours="" xdado:OZtwZgb="14">
<d:tblCourseLectureInstructors InstructorsID="2815" CourseID="2120" LectureID="2140" PersonID="56949" InstructorNumber="1" FullName="Feras Ackall, MD" Notes="" xdado:OZtwZgb="15"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5483" CourseID="2120" LectureID="2140" ObjectiveNumber="1" Objective="Understand SNOT-22 Subdomain outcomes following endonasal endoscopic skull base surgery." xdado:OZtwZgb="16"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2141" CourseID="2120" LectureNumber="6" LectureName="Factors Influencing Time to Cochlear Implantation" LectureDescription="" DurationHours="" xdado:OZtwZgb="17">
<d:tblCourseLectureInstructors InstructorsID="2816" CourseID="2120" LectureID="2141" PersonID="53086" InstructorNumber="1" FullName="James Robert Dornhoffer MD" Notes="" xdado:OZtwZgb="18"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5484" CourseID="2120" LectureID="2141" ObjectiveNumber="1" Objective="Will be made aware of the impact of the risk status of non-white patients for delayed presentation for cochlear implantation and increased length of time before cochlear implantation." xdado:OZtwZgb="19"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2142" CourseID="2120" LectureNumber="7" LectureName="How Much Blood Could A JP Suck If A JP Could Suck Blood?" LectureDescription="" DurationHours="" xdado:OZtwZgb="20">

<d:tblCourseLectureInstructors InstructorsID="2817" CourseID="2120" LectureID="2142" PersonID="57025" InstructorNumber="1" FullName="Erin Mamuyac Lopez, MD" Notes="" xdado:OZtwZgb="21"></d:tblCourseLectureInstructors><d:tblCourseLectureObjectives ObjectiveID="5485" CourseID="2120" LectureID="2142" ObjectiveNumber="1" Objective="Present information that will change every day clinical prctice regarding the use of JP draqins in post-operative care." xdado:OZtwZgb="22"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2143" CourseID="2120" LectureNumber="8" LectureName="Development of A Novel Technique for Determining Angular Insertion Depth and Implications for Cochlear Implantation" LectureDescription="" DurationHours="" xdado:OZtwZgb="23">
<d:tblCourseLectureInstructors InstructorsID="2818" CourseID="2120" LectureID="2143" PersonID="57026" InstructorNumber="1" FullName="Michael Canfarotta, MD" Notes="" xdado:OZtwZgb="24"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5486" CourseID="2120" LectureID="2143" ObjectiveNumber="1" Objective="Understand the importance of angular insertion depth in cochlear implantation and its implictions in electrode array selection and speech outcomes." xdado:OZtwZgb="25"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2144" CourseID="2120" LectureNumber="9" LectureName="How Low Can You Go?: Expansion of the Nasopalatine Angle Through Palatal Drill-Out" LectureDescription="" DurationHours="" xdado:OZtwZgb="26">
<d:tblCourseLectureInstructors InstructorsID="2819" CourseID="2120" LectureID="2144" PersonID="57027" InstructorNumber="1" FullName="Andrew Pappa, MD" Notes="" xdado:OZtwZgb="27"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5487" CourseID="2120" LectureID="2144" ObjectiveNumber="1" Objective="Describe a new surgical technique/approach." xdado:OZtwZgb="28"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2145" CourseID="2120" LectureNumber="10" LectureName="Cochlear Implants: Who is A Candidate and When Should You Refer Your Patients for Evaluation?" LectureDescription="" DurationHours="" xdado:OZtwZgb="29">
<d:tblCourseLectureInstructors InstructorsID="2820" CourseID="2120" LectureID="2145" PersonID="20738" InstructorNumber="1" FullName="Theodore Richardson McRackan MD" Notes="" xdado:OZtwZgb="30"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5488" CourseID="2120" LectureID="2145" ObjectiveNumber="1" Objective="Identify patients in their practice who should be referred for cochlear implant evaluation." xdado:OZtwZgb="31"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2150" CourseID="2120" LectureNumber="11" LectureName="For the Love of General ENT" LectureDescription="" DurationHours="" xdado:OZtwZgb="32">
<d:tblCourseLectureInstructors InstructorsID="2827" CourseID="2120" LectureID="2150" PersonID="57031" InstructorNumber="1" FullName="William R. Blythe, MD" Notes="" xdado:OZtwZgb="33"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5499" CourseID="2120" LectureID="2150" ObjectiveNumber="1" Objective="Discuss the changing demographhics of current ENT Residency training." xdado:OZtwZgb="34"></d:tblCourseLectureObjectives>
<d:tblCourseLectureObjectives ObjectiveID="5500" CourseID="2120" LectureID="2150" ObjectiveNumber="2" Objective="Discuss the changing demographics of otolaryngology practice in the US." xdado:OZtwZgb="35"></d:tblCourseLectureObjectives><d:tblCourseLectureObjectives ObjectiveID="5501" CourseID="2120" LectureID="2150" ObjectiveNumber="3" Objective="Discuss the modern general otolaryngology in private prctice: SWOT Analysis." xdado:OZtwZgb="36"></d:tblCourseLectureObjectives><d:tblCourseLectureObjectives ObjectiveID="5502" CourseID="2120" LectureID="2150" ObjectiveNumber="4" Objective="Discuss the future of general otolaryngology and private practice." xdado:OZtwZgb="37"></d:tblCourseLectureObjectives></d:tblCourseLectures><d:tblCourseLectures LectureID="2156" CourseID="2120" LectureNumber="12" LectureName="Etiology and Current Treatment Approaches for Head/Neck Cancers" LectureDescription="" DurationHours="" xdado:OZtwZgb="38">
<d:tblCourseLectureInstructors InstructorsID="2833" CourseID="2120" LectureID="2156" PersonID="41099" InstructorNumber="1" FullName="David Michael Neskey MD" Notes="" xdado:OZtwZgb="39"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5510" CourseID="2120" LectureID="2156" ObjectiveNumber="1" Objective="Understand the risk factors and etiopathogenesis of oral and oropharyngeal cancers." xdado:OZtwZgb="40"></d:tblCourseLectureObjectives>
<d:tblCourseLectureObjectives ObjectiveID="5616" CourseID="2120" LectureID="2156" ObjectiveNumber="2" Objective="Assess the differences in etiology and treatment of oral versus oropharyngeal cancers." xdado:OZtwZgb="41"></d:tblCourseLectureObjectives><d:tblCourseLectureObjectives ObjectiveID="5617" CourseID="2120" LectureID="2156" ObjectiveNumber="3" Objective="Discuss the sequences and modalities of treatment for oral and oropharyngeal cancers." xdado:OZtwZgb="42"></d:tblCourseLectureObjectives></d:tblCourseLectures><d:tblCourseLectures LectureID="2161" CourseID="2120" LectureNumber="13" LectureName="A Practical Guide to Head and Neck Cancer Survivorship" LectureDescription="" DurationHours="" xdado:OZtwZgb="43">
<d:tblCourseLectureInstructors InstructorsID="2838" CourseID="2120" LectureID="2161" PersonID="47664" InstructorNumber="1" FullName="Evan Michael Graboyes MD" Notes="" xdado:OZtwZgb="44"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5516" CourseID="2120" LectureID="2161" ObjectiveNumber="1" Objective="Describe evidence-based strategies to care for head and neck cancer survivors." xdado:OZtwZgb="45"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2162" CourseID="2120" LectureNumber="14" LectureName="When the Textbook Yields No Answers: A Blue-Collar Pediatric Otolaryngologist's Perspective" LectureDescription="" DurationHours="" xdado:OZtwZgb="46">
<d:tblCourseLectureInstructors InstructorsID="2839" CourseID="2120" LectureID="2162" PersonID="19226" InstructorNumber="1" FullName="Kenneth Charles Iverson MD" Notes="" xdado:OZtwZgb="47"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5517" CourseID="2120" LectureID="2162" ObjectiveNumber="1" Objective="Analyze and debate the best course of action for unusual cases presented." xdado:OZtwZgb="48"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2163" CourseID="2120" LectureNumber="15" LectureName="Alternate Mechanism of HPV Carcinogenesis In HNSCC" LectureDescription="" DurationHours="" xdado:OZtwZgb="49">
<d:tblCourseLectureInstructors InstructorsID="2840" CourseID="2120" LectureID="2163" PersonID="57032" InstructorNumber="1" FullName="Wendell Yarbrough, MD" Notes="" xdado:OZtwZgb="50"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5518" CourseID="2120" LectureID="2163" ObjectiveNumber="1" Objective="Conclude that HPV-associated HNSCC can be categorized by molecular defects that correlate with HPV integration and survival." xdado:OZtwZgb="51"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2164" CourseID="2120" LectureNumber="16" LectureName="Neoadjuvant Presurgical Immunotherapy for Patients With Locally Advanced Oral Cavity Cancer" LectureDescription="" DurationHours="" xdado:OZtwZgb="52">
<d:tblCourseLectureInstructors InstructorsID="2841" CourseID="2120" LectureID="2164" PersonID="41099" InstructorNumber="1" FullName="David Michael Neskey MD" Notes="" xdado:OZtwZgb="53"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5519" CourseID="2120" LectureID="2164" ObjectiveNumber="1" Objective="Describe the efficacy of neoadjuvant presurgical immunotherapy for oral cancer patients." xdado:OZtwZgb="54"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2166" CourseID="2120" LectureNumber="17" LectureName="MRI In Otology: Be Not Afraid" LectureDescription="" DurationHours="" xdado:OZtwZgb="55">
<d:tblCourseLectureInstructors InstructorsID="2843" CourseID="2120" LectureID="2166" PersonID="20738" InstructorNumber="1" FullName="Theodore Richardson McRackan MD" Notes="" xdado:OZtwZgb="56"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5521" CourseID="2120" LectureID="2166" ObjectiveNumber="1" Objective="Increase participants understanding of how to interpret and properly order MRI's of the internal auditory canal and temporal bone." xdado:OZtwZgb="57"></d:tblCourseLectureObjectives>
</d:tblCourseLectures></d:tblCourse>
</dfs:dataFields>
<xdado:originalData IdCount="58"><xml xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"><s:Schema id="RowsetSchema"><s:ElementType content="eltOnly" rs:CommandTimeout="30" rs:updatable="true" rs:ReshapeName="tblCourse" name="tblCourse"><s:AttributeType rs:number="1" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="CourseID" rs:keycolumn="true" rs:autoincrement="true" name="CourseID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="2" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="ClassID" name="ClassID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="3" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="CourseDateTime" name="CourseDateTime"><s:datatype dt:type="dateTime" rs:dbtype="timestamp" dt:maxLength="16" rs:scale="3" rs:precision="23" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="4" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="Venue" name="Venue"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="5" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="City" name="City"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="6" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="State" name="State"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="7" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="Zip" name="Zip"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="8" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="Notes" name="Notes"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="9" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="ClassHours" name="ClassHours"><s:datatype dt:type="r4" dt:maxLength="4" rs:precision="7" rs:fixedlength="true"/></s:AttributeType><s:AttributeType rs:number="10" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="ClassName" name="ClassName"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="11" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="ActivityType" name="ActivityType"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="12" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="JointSponsorshipOrganization" name="JointSponsorshipOrganization"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="13" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="ActivityTypeDescription" name="ActivityTypeDescription"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="14" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="Coordinator" name="Coordinator"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="15" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="ClassHours_ControlledSubstanceTraining" name="ClassHours_ControlledSubstanceTraining"><s:datatype dt:type="r4" dt:maxLength="4" rs:precision="7" rs:fixedlength="true"/></s:AttributeType><s:AttributeType rs:number="16" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourse" rs:basecolumn="OnlineRegistration" name="OnlineRegistration"><s:datatype dt:type="boolean" dt:maxLength="2" rs:fixedlength="true"/></s:AttributeType><s:ElementType content="eltOnly" rs:CommandTimeout="30" rs:updatable="true" rs:ReshapeName="DSRowset2" rs:relation="010000000200000000000000" name="tblCourseRates"><s:AttributeType rs:number="1" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseRates" rs:basecolumn="RateID" rs:keycolumn="true" rs:autoincrement="true" name="RateID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="2" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseRates" rs:basecolumn="CourseID" name="CourseID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="3" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseRates" rs:basecolumn="RateNumber" name="RateNumber"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="4" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseRates" rs:basecolumn="Rate" name="Rate"><s:datatype dt:type="number" rs:dbtype="currency" dt:maxLength="8" rs:precision="10" rs:fixedlength="true"/></s:AttributeType><s:AttributeType rs:number="5" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseRates" rs:basecolumn="Notes" name="Notes"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="250"/></s:AttributeType><s:AttributeType rs:number="6" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseRates" rs:basecolumn="MemberRate" name="MemberRate"><s:datatype dt:type="boolean" dt:maxLength="2" rs:fixedlength="true"/></s:AttributeType><s:AttributeType rs:number="7" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseRates" rs:basecolumn="ExpirationDate" name="ExpirationDate"><s:datatype dt:type="dateTime" rs:dbtype="timestamp" dt:maxLength="16" rs:scale="0" rs:precision="16" rs:fixedlength="true"/></s:AttributeType><s:extends type="rs:rowbase"/></s:ElementType><s:ElementType content="eltOnly" rs:CommandTimeout="30" rs:updatable="true" rs:ReshapeName="DSRowset3" rs:relation="010000000200000000000000" name="tblCourseLectures"><s:AttributeType rs:number="1" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectures" rs:basecolumn="LectureID" rs:keycolumn="true" rs:autoincrement="true" name="LectureID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="2" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectures" rs:basecolumn="CourseID" name="CourseID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="3" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectures" rs:basecolumn="LectureNumber" name="LectureNumber"><s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="4" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectures" rs:basecolumn="LectureName" name="LectureName"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="5" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectures" rs:basecolumn="LectureDescription" name="LectureDescription"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:AttributeType rs:number="6" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectures" rs:basecolumn="DurationHours" name="DurationHours"><s:datatype dt:type="r4" dt:maxLength="4" rs:precision="7" rs:fixedlength="true"/></s:AttributeType><s:ElementType content="eltOnly" rs:CommandTimeout="30" rs:updatable="true" rs:ReshapeName="DSRowset4" rs:relation="020000000200000000000000010000000300000000000000" name="tblCourseLectureInstructors"><s:AttributeType rs:number="1" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureInstructors" rs:basecolumn="InstructorsID" rs:keycolumn="true" rs:autoincrement="true" name="InstructorsID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="2" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureInstructors" rs:basecolumn="CourseID" name="CourseID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="3" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureInstructors" rs:basecolumn="LectureID" name="LectureID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="4" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureInstructors" rs:basecolumn="PersonID" name="PersonID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="5" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureInstructors" rs:basecolumn="InstructorNumber" name="InstructorNumber"><s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="6" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureInstructors" rs:basecolumn="FullName" name="FullName"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="7" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureInstructors" rs:basecolumn="Notes" name="Notes"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255"/></s:AttributeType><s:extends type="rs:rowbase"/></s:ElementType><s:ElementType content="eltOnly" rs:CommandTimeout="30" rs:updatable="true" rs:ReshapeName="DSRowset5" rs:relation="020000000200000000000000010000000300000000000000" name="tblCourseLectureObjectives"><s:AttributeType rs:number="1" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureObjectives" rs:basecolumn="ObjectiveID" rs:keycolumn="true" rs:autoincrement="true" name="ObjectiveID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="2" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureObjectives" rs:basecolumn="CourseID" name="CourseID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="3" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureObjectives" rs:basecolumn="LectureID" name="LectureID"><s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="4" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureObjectives" rs:basecolumn="ObjectiveNumber" name="ObjectiveNumber"><s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" rs:maybenull="false"/></s:AttributeType><s:AttributeType rs:number="5" rs:writeunknown="true" rs:basecatalog="CME_SCMA" rs:baseschema="dbo" rs:basetable="tblCourseLectureObjectives" rs:basecolumn="Objective" name="Objective"><s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="255" rs:maybenull="false"/></s:AttributeType><s:extends type="rs:rowbase"/></s:ElementType><s:extends type="rs:rowbase"/></s:ElementType><s:extends type="rs:rowbase"/></s:ElementType></s:Schema><rs:data><d:tblCourse CourseID="2120" ClassID="482" CourseDateTime="2019-08-02T07:00:00" Venue="Marriott Grande Dunes" City="Myrtle Beach" State="SC" ClassHours="4.5" ClassName="2019 SC/NC Societies of Otolaryngology Annual Meeting - Day 1" ActivityType="C" JointSponsorshipOrganization="SC Society of Otolaryngology" ActivityTypeDescription="Live Course" Coordinator="Pam Pendleton" xdado:OZtwZgb="0">
<d:tblCourseRates RateID="1277" CourseID="2120" RateNumber="1" Rate="0" xdado:OZtwZgb="1"></d:tblCourseRates>
<d:tblCourseLectures LectureID="2136" CourseID="2120" LectureNumber="1" LectureName="Sialendoscopy With Introductal Steriod Irrigation In Patients With Sialadentis Without Sialadentis" xdado:OZtwZgb="2">
<d:tblCourseLectureInstructors InstructorsID="2811" CourseID="2120" LectureID="2136" PersonID="57020" InstructorNumber="1" FullName="Torrey L. Fourrier, MD" xdado:OZtwZgb="3"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5479" CourseID="2120" LectureID="2136" ObjectiveNumber="1" Objective="Review current literature on the uses of sialendoscopy with an emphasis on recent research on its use with autoimmune presentations." xdado:OZtwZgb="4"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2137" CourseID="2120" LectureNumber="2" LectureName="Voice Outcomes Following Surgical Intervention Involving the Upper Esophageal Sphincter" xdado:OZtwZgb="5">
<d:tblCourseLectureInstructors InstructorsID="2812" CourseID="2120" LectureID="2137" PersonID="57022" InstructorNumber="1" FullName="Gabriella M. DeVries, MD" xdado:OZtwZgb="6"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5480" CourseID="2120" LectureID="2137" ObjectiveNumber="1" Objective="Review pre-operative and post-operative assessments including RSI, VHI-10 and how EAT-10 demonstrates improvement regarding quality of voice following surgical intervention involving the upper esophageal sphincter." xdado:OZtwZgb="7"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2138" CourseID="2120" LectureNumber="3" LectureName="Perinatal Surgical Intervention In Pierre Robin Sequence" xdado:OZtwZgb="8">
<d:tblCourseLectureInstructors InstructorsID="2813" CourseID="2120" LectureID="2138" PersonID="57023" InstructorNumber="1" FullName="Brian Hernandez, MD" xdado:OZtwZgb="9"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5481" CourseID="2120" LectureID="2138" ObjectiveNumber="1" Objective="Present experience in the multidisciplinary treatment of children with Pierre Robin Syndrome since 2012 with the aim of presenting data correlating prenatal raqdiograqphic measures and the need for airway interventions." xdado:OZtwZgb="10"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2139" CourseID="2120" LectureNumber="4" LectureName="Clinician Adherence to the Clinical Practice Guideline: Acute Otis Externa" xdado:OZtwZgb="11">
<d:tblCourseLectureInstructors InstructorsID="2814" CourseID="2120" LectureID="2139" PersonID="57024" InstructorNumber="1" FullName="Nicholas Mildenhall, MD" xdado:OZtwZgb="12"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5482" CourseID="2120" LectureID="2139" ObjectiveNumber="1" Objective="Discuss the role and efficacy of clinical practice guidelines, specifically related to the guideline for acute otitis externa, as well as considerations for improved distribution and adherence." xdado:OZtwZgb="13"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2140" CourseID="2120" LectureNumber="5" LectureName="SNOT-22 Subdomain Outcomes After Endonasal Endoscopic Skull Base Surgery" xdado:OZtwZgb="14">
<d:tblCourseLectureInstructors InstructorsID="2815" CourseID="2120" LectureID="2140" PersonID="56949" InstructorNumber="1" FullName="Feras Ackall, MD" xdado:OZtwZgb="15"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5483" CourseID="2120" LectureID="2140" ObjectiveNumber="1" Objective="Understand SNOT-22 Subdomain outcomes following endonasal endoscopic skull base surgery." xdado:OZtwZgb="16"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2141" CourseID="2120" LectureNumber="6" LectureName="Factors Influencing Time to Cochlear Implantation" xdado:OZtwZgb="17">
<d:tblCourseLectureInstructors InstructorsID="2816" CourseID="2120" LectureID="2141" PersonID="53086" InstructorNumber="1" FullName="James Robert Dornhoffer MD" xdado:OZtwZgb="18"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5484" CourseID="2120" LectureID="2141" ObjectiveNumber="1" Objective="Will be made aware of the impact of the risk status of non-white patients for delayed presentation for cochlear implantation and increased length of time before cochlear implantation." xdado:OZtwZgb="19"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2142" CourseID="2120" LectureNumber="7" LectureName="How Much Blood Could A JP Suck If A JP Could Suck Blood?" xdado:OZtwZgb="20">

<d:tblCourseLectureInstructors InstructorsID="2817" CourseID="2120" LectureID="2142" PersonID="57025" InstructorNumber="1" FullName="Erin Mamuyac Lopez, MD" xdado:OZtwZgb="21"></d:tblCourseLectureInstructors><d:tblCourseLectureObjectives ObjectiveID="5485" CourseID="2120" LectureID="2142" ObjectiveNumber="1" Objective="Present information that will change every day clinical prctice regarding the use of JP draqins in post-operative care." xdado:OZtwZgb="22"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2143" CourseID="2120" LectureNumber="8" LectureName="Development of A Novel Technique for Determining Angular Insertion Depth and Implications for Cochlear Implantation" xdado:OZtwZgb="23">
<d:tblCourseLectureInstructors InstructorsID="2818" CourseID="2120" LectureID="2143" PersonID="57026" InstructorNumber="1" FullName="Michael Canfarotta, MD" xdado:OZtwZgb="24"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5486" CourseID="2120" LectureID="2143" ObjectiveNumber="1" Objective="Understand the importance of angular insertion depth in cochlear implantation and its implictions in electrode array selection and speech outcomes." xdado:OZtwZgb="25"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2144" CourseID="2120" LectureNumber="9" LectureName="How Low Can You Go?: Expansion of the Nasopalatine Angle Through Palatal Drill-Out" xdado:OZtwZgb="26">
<d:tblCourseLectureInstructors InstructorsID="2819" CourseID="2120" LectureID="2144" PersonID="57027" InstructorNumber="1" FullName="Andrew Pappa, MD" xdado:OZtwZgb="27"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5487" CourseID="2120" LectureID="2144" ObjectiveNumber="1" Objective="Describe a new surgical technique/approach." xdado:OZtwZgb="28"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2145" CourseID="2120" LectureNumber="10" LectureName="Cochlear Implants: Who is A Candidate and When Should You Refer Your Patients for Evaluation?" xdado:OZtwZgb="29">
<d:tblCourseLectureInstructors InstructorsID="2820" CourseID="2120" LectureID="2145" PersonID="20738" InstructorNumber="1" FullName="Theodore Richardson McRackan MD" xdado:OZtwZgb="30"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5488" CourseID="2120" LectureID="2145" ObjectiveNumber="1" Objective="Identify patients in their practice who should be referred for cochlear implant evaluation." xdado:OZtwZgb="31"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2150" CourseID="2120" LectureNumber="11" LectureName="For the Love of General ENT" xdado:OZtwZgb="32">
<d:tblCourseLectureInstructors InstructorsID="2827" CourseID="2120" LectureID="2150" PersonID="57031" InstructorNumber="1" FullName="William R. Blythe, MD" xdado:OZtwZgb="33"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5499" CourseID="2120" LectureID="2150" ObjectiveNumber="1" Objective="Discuss the changing demographhics of current ENT Residency training." xdado:OZtwZgb="34"></d:tblCourseLectureObjectives>
<d:tblCourseLectureObjectives ObjectiveID="5500" CourseID="2120" LectureID="2150" ObjectiveNumber="2" Objective="Discuss the changing demographics of otolaryngology practice in the US." xdado:OZtwZgb="35"></d:tblCourseLectureObjectives><d:tblCourseLectureObjectives ObjectiveID="5501" CourseID="2120" LectureID="2150" ObjectiveNumber="3" Objective="Discuss the modern general otolaryngology in private prctice: SWOT Analysis." xdado:OZtwZgb="36"></d:tblCourseLectureObjectives><d:tblCourseLectureObjectives ObjectiveID="5502" CourseID="2120" LectureID="2150" ObjectiveNumber="4" Objective="Discuss the future of general otolaryngology and private practice." xdado:OZtwZgb="37"></d:tblCourseLectureObjectives></d:tblCourseLectures><d:tblCourseLectures LectureID="2156" CourseID="2120" LectureNumber="12" LectureName="Etiology and Current Treatment Approaches for Head/Neck Cancers" xdado:OZtwZgb="38">
<d:tblCourseLectureInstructors InstructorsID="2833" CourseID="2120" LectureID="2156" PersonID="41099" InstructorNumber="1" FullName="David Michael Neskey MD" xdado:OZtwZgb="39"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5510" CourseID="2120" LectureID="2156" ObjectiveNumber="1" Objective="Understand the risk factors and etiopathogenesis of oral and oropharyngeal cancers." xdado:OZtwZgb="40"></d:tblCourseLectureObjectives>
<d:tblCourseLectureObjectives ObjectiveID="5616" CourseID="2120" LectureID="2156" ObjectiveNumber="2" Objective="Assess the differences in etiology and treatment of oral versus oropharyngeal cancers." xdado:OZtwZgb="41"></d:tblCourseLectureObjectives><d:tblCourseLectureObjectives ObjectiveID="5617" CourseID="2120" LectureID="2156" ObjectiveNumber="3" Objective="Discuss the sequences and modalities of treatment for oral and oropharyngeal cancers." xdado:OZtwZgb="42"></d:tblCourseLectureObjectives></d:tblCourseLectures><d:tblCourseLectures LectureID="2161" CourseID="2120" LectureNumber="13" LectureName="A Practical Guide to Head and Neck Cancer Survivorship" xdado:OZtwZgb="43">
<d:tblCourseLectureInstructors InstructorsID="2838" CourseID="2120" LectureID="2161" PersonID="47664" InstructorNumber="1" FullName="Evan Michael Graboyes MD" xdado:OZtwZgb="44"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5516" CourseID="2120" LectureID="2161" ObjectiveNumber="1" Objective="Describe evidence-based strategies to care for head and neck cancer survivors." xdado:OZtwZgb="45"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2162" CourseID="2120" LectureNumber="14" LectureName="When the Textbook Yields No Answers: A Blue-Collar Pediatric Otolaryngologist's Perspective" xdado:OZtwZgb="46">
<d:tblCourseLectureInstructors InstructorsID="2839" CourseID="2120" LectureID="2162" PersonID="19226" InstructorNumber="1" FullName="Kenneth Charles Iverson MD" xdado:OZtwZgb="47"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5517" CourseID="2120" LectureID="2162" ObjectiveNumber="1" Objective="Analyze and debate the best course of action for unusual cases presented." xdado:OZtwZgb="48"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2163" CourseID="2120" LectureNumber="15" LectureName="Alternate Mechanism of HPV Carcinogenesis In HNSCC" xdado:OZtwZgb="49">
<d:tblCourseLectureInstructors InstructorsID="2840" CourseID="2120" LectureID="2163" PersonID="57032" InstructorNumber="1" FullName="Wendell Yarbrough, MD" xdado:OZtwZgb="50"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5518" CourseID="2120" LectureID="2163" ObjectiveNumber="1" Objective="Conclude that HPV-associated HNSCC can be categorized by molecular defects that correlate with HPV integration and survival." xdado:OZtwZgb="51"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2164" CourseID="2120" LectureNumber="16" LectureName="Neoadjuvant Presurgical Immunotherapy for Patients With Locally Advanced Oral Cavity Cancer" xdado:OZtwZgb="52">
<d:tblCourseLectureInstructors InstructorsID="2841" CourseID="2120" LectureID="2164" PersonID="41099" InstructorNumber="1" FullName="David Michael Neskey MD" xdado:OZtwZgb="53"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5519" CourseID="2120" LectureID="2164" ObjectiveNumber="1" Objective="Describe the efficacy of neoadjuvant presurgical immunotherapy for oral cancer patients." xdado:OZtwZgb="54"></d:tblCourseLectureObjectives>
</d:tblCourseLectures><d:tblCourseLectures LectureID="2166" CourseID="2120" LectureNumber="17" LectureName="MRI In Otology: Be Not Afraid" xdado:OZtwZgb="55">
<d:tblCourseLectureInstructors InstructorsID="2843" CourseID="2120" LectureID="2166" PersonID="20738" InstructorNumber="1" FullName="Theodore Richardson McRackan MD" xdado:OZtwZgb="56"></d:tblCourseLectureInstructors>
<d:tblCourseLectureObjectives ObjectiveID="5521" CourseID="2120" LectureID="2166" ObjectiveNumber="1" Objective="Increase participants understanding of how to interpret and properly order MRI's of the internal auditory canal and temporal bone." xdado:OZtwZgb="57"></d:tblCourseLectureObjectives>
</d:tblCourseLectures></d:tblCourse></rs:data></xml></xdado:originalData></dfs:myFields>

2 REPLIES 2
bfsmith9
Frequent Visitor

I tested the XPath expression against the Xml file in FreeFormatter.com and got the result I was hoping for. 

XPathTest1.JPGXPathTest2.JPG

 

So I dont know why Automate is not giving me the Field value (attribute).

This is looking like a bug.

If I change the XPath expression to //@ClassName I do get some data back...but then I have to hack away to get what I really want.

FlowXPath1.PNGFlowXPath2.PNG

Hack away to get '2019 SC/NC Societies of Otolaryngology Annual Meeting - Day 1'!!!!

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (59,079)