This discussion is archived
0 Replies Latest reply: Nov 18, 2013 9:35 AM by oracle_saurabh RSS

PS Connected Query:How 2 Check Child Query Result

oracle_saurabh Newbie
Currently Being Moderated

Hi Gurus,

 

I am trying to Create a BI Report using PS Connected Query. Its a simple PS Connected Query where Child Query are sub total of various coloumn of Parent Query. I have observed that if a child query doesn't return value then XML file doesn't has tags related to child query. I need to check such condition to notify user that there was no value for a sub total.

 

PS Connected Query Data in XML with all child query:

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

- <ConnectedQuery name="BH_ESSEVNT_RPT_CQRY" preview="True" query_rows_limit="6" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">

- <BH_ESS_EVNT_INFO>

  <A.EVENT_DT>12/25/2013</A.EVENT_DT>

- <A.EVENT_NAME>

- <![CDATA[ SUSAN G. KOMEN RACE

  ]]>

  </A.EVENT_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1031

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1031

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ E

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ U

  ]]>

  </A.SEX>

  <A.AGE>21</A.AGE>

+ <A.FIRST_NAME>

- <![CDATA[ PER1031

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

  <A.ADDRESS1 />

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ miami

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 33173

  ]]>

  </A.POSTAL>

  <A.EMAIL_ADDR />

  <A.PHONE />

  <A.TIME_RQRMT_AMT>120</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ R

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ X

  ]]>

  </A.BH_ADLT_SHRT_SZ>

- <A.BH_YNG_SHRT_SZ>

- <![CDATA[ 3

  ]]>

  </A.BH_YNG_SHRT_SZ>

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

- <A.LOCATION2>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION2>

- <A.BH_LUNCH>

- <![CDATA[ T

  ]]>

  </A.BH_LUNCH>

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/14/2013 23:08:19</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1031

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1031

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ G

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ F

  ]]>

  </A.SEX>

  <A.AGE>21</A.AGE>

- <A.FIRST_NAME>

- <![CDATA[ guest

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ test5

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

  <A.ADDRESS1 />

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ miami

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 33173

  ]]>

  </A.POSTAL>

  <A.EMAIL_ADDR />

  <A.PHONE />

  <A.TIME_RQRMT_AMT>120</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ S

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ X

  ]]>

  </A.BH_ADLT_SHRT_SZ>

- <A.BH_YNG_SHRT_SZ>

- <![CDATA[ N

  ]]>

  </A.BH_YNG_SHRT_SZ>

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

- <A.LOCATION2>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION2>

- <A.BH_LUNCH>

- <![CDATA[ T

  ]]>

  </A.BH_LUNCH>

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/14/2013 23:08:19</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESSEVNT_YSHRT_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_YNG_SHRT_SZ>

- <![CDATA[ 3

  ]]>

  </A.BH_YNG_SHRT_SZ>

- <EXPR4_4>

- <![CDATA[ Youth Large

  ]]>

  </EXPR4_4>

  <EXPR3_3>1</EXPR3_3>

  </BH_ESSEVNT_YSHRT_CNT_QRY>

- <BH_ESSEVNT_YSHRT_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_YNG_SHRT_SZ>

- <![CDATA[ N

  ]]>

  </A.BH_YNG_SHRT_SZ>

- <EXPR4_4>

- <![CDATA[ NA

  ]]>

  </EXPR4_4>

  <EXPR3_3>1</EXPR3_3>

  </BH_ESSEVNT_YSHRT_CNT_QRY>

- <BH_ESSEVNT_ASHRT_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ X

  ]]>

  </A.BH_ADLT_SHRT_SZ>

- <EXPR1_1>

- <![CDATA[ Adult  X-Large

  ]]>

  </EXPR1_1>

  <EXPR3_3>2</EXPR3_3>

  </BH_ESSEVNT_ASHRT_CNT_QRY>

- <BH_ESSEVNT_METROPASS_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <EXPR3_3>2</EXPR3_3>

  </BH_ESSEVNT_METROPASS_QRY>

- <BH_ESSEVNT_TOTEE_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

  <EXPR3_3>1</EXPR3_3>

  </BH_ESSEVNT_TOTEE_QRY>

- <BH_ESSEVNT_TOTREG_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

  <EXPR3_3>2</EXPR3_3>

  </BH_ESSEVNT_TOTREG_QRY>

- <BH_ESSEVNT_LUNCH_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ TEST

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_LUNCH>

- <![CDATA[ T

  ]]>

  </A.BH_LUNCH>

- <EXPR4_4>

- <![CDATA[ Turkey

  ]]>

  </EXPR4_4>

  <EXPR3_3>2</EXPR3_3>

  </BH_ESSEVNT_LUNCH_CNT_QRY>

  </BH_ESS_EVNT_INFO>

  </ConnectedQuery>

 

PS Connected Query Data in XML with a missing child query(this is highlighted in bold in above query):

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

- <ConnectedQuery name="BH_ESSEVNT_RPT_CQRY" preview="True" query_rows_limit="6" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="">

- <BH_ESS_EVNT_INFO>

  <A.EVENT_DT>11/22/2013</A.EVENT_DT>

- <A.EVENT_NAME>

- <![CDATA[ MIAMI MARATHON 2013

  ]]>

  </A.EVENT_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

+ <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1023

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1023

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ E

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ U

  ]]>

  </A.SEX>

  <A.AGE>21</A.AGE>

- <A.FIRST_NAME>

- <![CDATA[ PER1023

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

- <A.ADDRESS1>

- <![CDATA[ 3453 sw 242 street

  ]]>

  </A.ADDRESS1>

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ Miami

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 65454

  ]]>

  </A.POSTAL>

- <A.EMAIL_ADDR>

- <![CDATA[ christinn@baptisthealth.net

  ]]>

  </A.EMAIL_ADDR>

- <A.PHONE>

- <![CDATA[ 352/874-5424

  ]]>

  </A.PHONE>

  <A.TIME_RQRMT_AMT>0</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ R

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ X

  ]]>

  </A.BH_ADLT_SHRT_SZ>

  <A.BH_YNG_SHRT_SZ />

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <A.LOCATION2 />

  <A.BH_LUNCH />

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/15/2013 11:24:44</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1023

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1023

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ G

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ F

  ]]>

  </A.SEX>

  <A.AGE>25</A.AGE>

- <A.FIRST_NAME>

- <![CDATA[ Christina

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ Marie

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

- <A.ADDRESS1>

- <![CDATA[ 34134 sw 23 street

  ]]>

  </A.ADDRESS1>

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ Ft Lauderdale

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 33264

  ]]>

  </A.POSTAL>

- <A.EMAIL_ADDR>

- <![CDATA[ christinn@baptisthealth.net

  ]]>

  </A.EMAIL_ADDR>

- <A.PHONE>

- <![CDATA[ 506/545-5427

  ]]>

  </A.PHONE>

  <A.TIME_RQRMT_AMT>0</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ W

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ L

  ]]>

  </A.BH_ADLT_SHRT_SZ>

  <A.BH_YNG_SHRT_SZ />

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <A.LOCATION2 />

  <A.BH_LUNCH />

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/15/2013 11:24:44</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1023

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1023

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ G

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ M

  ]]>

  </A.SEX>

  <A.AGE>30</A.AGE>

- <A.FIRST_NAME>

- <![CDATA[ Bobby

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ Brown

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

- <A.ADDRESS1>

- <![CDATA[ 2324 sw 23 street

  ]]>

  </A.ADDRESS1>

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ Miami

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 33552

  ]]>

  </A.POSTAL>

- <A.EMAIL_ADDR>

- <![CDATA[ christinn@baptisthealth.net

  ]]>

  </A.EMAIL_ADDR>

- <A.PHONE>

- <![CDATA[ 654/654-6434

  ]]>

  </A.PHONE>

  <A.TIME_RQRMT_AMT>0</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ R

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ X

  ]]>

  </A.BH_ADLT_SHRT_SZ>

  <A.BH_YNG_SHRT_SZ />

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <A.LOCATION2 />

  <A.BH_LUNCH />

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/15/2013 11:24:50</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1023

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1023

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ G

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ M

  ]]>

  </A.SEX>

  <A.AGE>35</A.AGE>

- <A.FIRST_NAME>

- <![CDATA[ Mark

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ Haven

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

- <A.ADDRESS1>

- <![CDATA[ 135 sw 13 street

  ]]>

  </A.ADDRESS1>

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ MIami

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 33546

  ]]>

  </A.POSTAL>

- <A.EMAIL_ADDR>

- <![CDATA[ christinn@baptisthealth.net

  ]]>

  </A.EMAIL_ADDR>

- <A.PHONE>

- <![CDATA[ 352/642-6453

  ]]>

  </A.PHONE>

  <A.TIME_RQRMT_AMT>0</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ R

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ Z

  ]]>

  </A.BH_ADLT_SHRT_SZ>

  <A.BH_YNG_SHRT_SZ />

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <A.LOCATION2 />

  <A.BH_LUNCH />

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/15/2013 11:25:44</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1023

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1023

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ G

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ M

  ]]>

  </A.SEX>

  <A.AGE>35</A.AGE>

- <A.FIRST_NAME>

- <![CDATA[ Stephen

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ Travis

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

- <A.ADDRESS1>

- <![CDATA[ 654 sw 13 street

  ]]>

  </A.ADDRESS1>

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ Miami

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 33526

  ]]>

  </A.POSTAL>

- <A.EMAIL_ADDR>

- <![CDATA[ christinn@baptisthealth.net

  ]]>

  </A.EMAIL_ADDR>

- <A.PHONE>

- <![CDATA[ 352/849-5424

  ]]>

  </A.PHONE>

  <A.TIME_RQRMT_AMT>0</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ R

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ M

  ]]>

  </A.BH_ADLT_SHRT_SZ>

  <A.BH_YNG_SHRT_SZ />

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <A.LOCATION2 />

  <A.BH_LUNCH />

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/15/2013 11:26:34</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESS_EVNT_EE_DATA>

- <A.EMPLID>

- <![CDATA[ 1023

  ]]>

  </A.EMPLID>

- <B.FIRST_NAME>

- <![CDATA[ PER1023

  ]]>

  </B.FIRST_NAME>

- <B.LAST_NAME>

- <![CDATA[ HRC013

  ]]>

  </B.LAST_NAME>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_EVNT_REG_TYPE>

- <![CDATA[ G

  ]]>

  </A.BH_EVNT_REG_TYPE>

- <A.SEX>

- <![CDATA[ M

  ]]>

  </A.SEX>

  <A.AGE>40</A.AGE>

- <A.FIRST_NAME>

- <![CDATA[ John

  ]]>

  </A.FIRST_NAME>

- <A.LAST_NAME>

- <![CDATA[ Smith

  ]]>

  </A.LAST_NAME>

- <A.LOCATION>

- <![CDATA[ PWCTEST

  ]]>

  </A.LOCATION>

- <A.ADDRESS1>

- <![CDATA[ 2498 sw 23 street

  ]]>

  </A.ADDRESS1>

  <A.ADDRESS2 />

- <A.CITY>

- <![CDATA[ Miami

  ]]>

  </A.CITY>

- <A.STATE>

- <![CDATA[ FL

  ]]>

  </A.STATE>

- <A.POSTAL>

- <![CDATA[ 33562

  ]]>

  </A.POSTAL>

- <A.EMAIL_ADDR>

- <![CDATA[ christinn@baptisthealth.net

  ]]>

  </A.EMAIL_ADDR>

- <A.PHONE>

- <![CDATA[ 352/849-5424

  ]]>

  </A.PHONE>

  <A.TIME_RQRMT_AMT>0</A.TIME_RQRMT_AMT>

- <A.BH_WALK_RUN>

- <![CDATA[ S

  ]]>

  </A.BH_WALK_RUN>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ M

  ]]>

  </A.BH_ADLT_SHRT_SZ>

  <A.BH_YNG_SHRT_SZ />

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <A.LOCATION2 />

  <A.BH_LUNCH />

- <A.BH_BC_SURVIVOR>

- <![CDATA[ Y

  ]]>

  </A.BH_BC_SURVIVOR>

  <A.DATETIME_STAMP>11/15/2013 11:27:58</A.DATETIME_STAMP>

  </BH_ESS_EVNT_EE_DATA>

- <BH_ESSEVNT_ASHRT_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ L

  ]]>

  </A.BH_ADLT_SHRT_SZ>

- <EXPR1_1>

- <![CDATA[ Adult Large

  ]]>

  </EXPR1_1>

  <EXPR3_3>1</EXPR3_3>

  </BH_ESSEVNT_ASHRT_CNT_QRY>

- <BH_ESSEVNT_ASHRT_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ M

  ]]>

  </A.BH_ADLT_SHRT_SZ>

- <EXPR1_1>

- <![CDATA[ Adult Medium

  ]]>

  </EXPR1_1>

  <EXPR3_3>2</EXPR3_3>

  </BH_ESSEVNT_ASHRT_CNT_QRY>

- <BH_ESSEVNT_ASHRT_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ X

  ]]>

  </A.BH_ADLT_SHRT_SZ>

- <EXPR1_1>

- <![CDATA[ Adult  X-Large

  ]]>

  </EXPR1_1>

  <EXPR3_3>2</EXPR3_3>

  </BH_ESSEVNT_ASHRT_CNT_QRY>

- <BH_ESSEVNT_ASHRT_CNT_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_ADLT_SHRT_SZ>

- <![CDATA[ Z

  ]]>

  </A.BH_ADLT_SHRT_SZ>

- <EXPR1_1>

- <![CDATA[ Adult  XX-Large

  ]]>

  </EXPR1_1>

  <EXPR3_3>1</EXPR3_3>

  </BH_ESSEVNT_ASHRT_CNT_QRY>

- <BH_ESSEVNT_METROPASS_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

- <A.BH_METRORAIL_PASS>

- <![CDATA[ Y

  ]]>

  </A.BH_METRORAIL_PASS>

  <EXPR3_3>6</EXPR3_3>

  </BH_ESSEVNT_METROPASS_QRY>

- <BH_ESSEVNT_TOTEE_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

  <EXPR3_3>1</EXPR3_3>

  </BH_ESSEVNT_TOTEE_QRY>

- <BH_ESSEVNT_TOTREG_QRY>

- <A.EVENT_3CS_ID>

- <![CDATA[ MIAMAR13

  ]]>

  </A.EVENT_3CS_ID>

  <EXPR3_3>6</EXPR3_3>

  </BH_ESSEVNT_TOTREG_QRY>

  </BH_ESS_EVNT_INFO>

  </ConnectedQuery>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points