dimanche 28 juin 2015

How do I loop thought each DB field to see if range is correct

I have this response in soapUI:

 <pointsCriteria>
    <calculatorLabel>Have you registered for inContact, signed up for marketing news from FNB/RMB Private Bank, updated your contact details and chosen to receive your statements</calculatorLabel>
    <description>Be registered for inContact, allow us to communicate with you (i.e. update your marketing consent to 'Yes'), receive your statements via email and keep your contact information up to date</description>
    <grades>
       <points>0</points>
       <value>No</value>
    </grades>
    <grades>
       <points>1000</points>
       <value>Yes</value>
    </grades>
    <label>Marketing consent given and Online Contact details updated in last 12 months</label>
    <name>c21_mrktng_cnsnt_cntct_cmb_point</name>
 </pointsCriteria>

There are many many many pointsCriteria and I use the below xquery to give me the DB value and Range of what that field is meant to be:

<return>
{
for $x in //pointsCriteria
return <DBRange>
<db>{data($x/name/text())}</db> 
<points>{data($x//points/text())}</points>
</DBRange>
}
</return>

And i get the below response

<return><DBRange><db>c21_mrktng_cnsnt_cntct_cmb_point</db><points>0 1000</points></DBRange>

That last bit sits in a property transfer. I need SQL to bring back all rows where that DB field is not in that points range (field can only be 0 or 1000 in this case), my problem is I dont know how to loop through each DBRange/DBrange in this manner? please help

Aucun commentaire:

Enregistrer un commentaire