AnsweredAssumed Answered

Web Service - Know only Resolved tickets from Web Service

Question asked by carvato on Apr 10, 2018
Latest reply on Apr 11, 2018 by carvato

Hello everybody, I have an issue, I'm trying to know all ticket in resolved status and in SOAPUI I have this query

 

    <ser:doSelect>
     <sid>586393225</sid>
     <objectType>cr</objectType>
     <whereClause>
     group.last_name LIKE 'EUS_ZONA%'
     OR group.last_name like 'EUS_ Region%'
      OR group.last_name like 'EUS_ZSur%'
      OR group.last_name like 'EUS_Desktop%' AND status = 'RE' AND type='I' AND open_date > 1517454000 AND         open_date &lt; 1519786800</whereClause>
     <maxRows>-1</maxRows>
     <attributes>
<!--1 or more repetitions:-->
<string>ref_num</string>
<string>target_times.sym</string>
<string>support_lev.sym</string>
<string>open_date</string>
<string>agt.id</string>
<string>priority</string>
<string>tenant.id</string>
<string>tenant.name</string>
<string>log_agent</string>
<string>request_by.first_name</string>
<string>request_by.first_name</string>
<string>customer.first_name</string>
<string>customer.last_name</string>
<string>customer.id</string>
<string>category.id</string>
<string>category.sym</string>
<string>status</string>
<string>status.sym</string>
<string>group.id</string>
<string>group.last_name</string>
<string>zreporting_met.id</string>
<string>zreporting_met.sym</string>
<string>assignee.combo_name</string>
<string>open_date</string>
<string>close_date</string>
<string>description</string>
<string>summary</string>
</attributes>

</ser:doSelect>

 

And this always returns me all tickets in all status. In WhereClause I tried too (status.code IN ('%5200%', '%5208%', '%400202%')) because maybe with Resolved status doesn't work, I tried too status.sym LIKE '%Resol%', and my last try was status = 'RE' and it didn't work either. Someone can help me? Forwards thanks!!!

Outcomes