AnsweredAssumed Answered

Time Spans in doSelect where clause

Question asked by Gutis Champion on Jul 3, 2015
Latest reply on Jul 4, 2015 by Gutis

Hello, I would like to use time spans in my doSelect WS query e.g.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://www.ca.com/UnicenterServicePlus/ServiceDesk">
   <soapenv:Header/>
   <soapenv:Body>
      <ser:doSelect>
         <sid>12069673</sid>
         <objectType>in</objectType>
         <whereClause>open_date = StartAtTime('PAST_WEEK') AND nb</whereClause>
         <maxRows>-1</maxRows>
         <attributes>
            <!--1 or more repetitions:-->
            <string>id</string>
         </attributes>
      </ser:doSelect>
   </soapenv:Body>
</soapenv:Envelope>

 

It is sad but each time I get empty results. Nevertheless I would like to get some more information about time spans. As I understand thy are evaluated by some SDM process according to configured schedule. Maybe someone knows where those evaluated values are stored in files, memory or database? Maybe there is some spel method that can be called to get time span values?

Outcomes