0 Replies Latest reply: Mar 23, 2012 7:33 AM by JeffStevenson RSS

    Search-Objects webject based on timestamp

    JeffStevenson Bronze

      I'm trying to get to all of the files modified since a certain date along with the latest revision/iteration.  I'm running into inconsistencies between searching based in modifStamp between Search-Objects and Query-Objects.

       

      If I use Query-Objects, I can search based on timeStamp down to the minute or second.  However, Query-Objects doesn't allow me to get the latest revision/iteration of an object.

       

      Search-Objects allows me to get the latest revision iteration, however, Search-Objects only seems to search down to the day in the modifyStamp field.

       

      Example:

      If I am searching for all files modified since 2012-03-15 01:01:01 with Search-Objects, my results are including all files modified on 2012-03-15 regardless of the hh:mm:ss.

       

      Conversely, Query-Objects gives me all files modified since 1:01:01 on March 15.

       

      I'm trying to build a webject to get around this, but I'm having some trouble.  Is this the desired functionality of Search-Objects?  It seems as if I should be able to search via a WHERE clause the same in any webject that accepts WHERE as a parameter.

       

      Does anyone have a workaround for this or know what may be causing it?  Is this a setting within the search results properties for WC?

       

      I've included my latest webject for your review.

       

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

      <%@page language="java"%>

      <%@taglib uri="http://www.ptc.com/infoengine/taglib/core" prefix="ie"%>

      <!-- Task for query Windchill for new and release content since the creation of latest baseline -->

      <!-- Task is called by IEListContent.class -->

      <ie:webject name="Search-Objects" type="OBJ">

          <ie:param name="INSTANCE" data="com.mycompany.Windchill" delim="!" valueSeparator="!" default="<%=com.infoengine.au.NamingService.getVMName()%>"/>

              <ie:param name="DBUSER" data="wcadmin"/>

              <ie:param name="GROUP_OUT" data="document"/>

              <ie:param name="PASSWD" data="password"/>

              <ie:param name="TYPE" data="wt.epm.EPMDocument"/>

              <ie:param name="WHERE" data="thePersistInfo.modifyStamp>='$(@FORM[]moddate[])'"/>

              <ie:param name="WHERE" data="CADName='*.xml'"/>

              <ie:param name="VERSION" data="LATEST"/>

              <ie:param name="ITERATION" data="LATEST"/>

              <ie:param name="ATTRIBUTE" data="*"/>

      </ie:webject>

       

      <ie:webject name="Query-Objects" type="OBJ">

          <ie:param name="INSTANCE" data="com.mycompany.Windchill" delim="!" valueSeparator="!" default="<%=com.infoengine.au.NamingService.getVMName()%>"/>

              <ie:param name="DBUSER" data="wcadmin"/>

              <ie:param name="GROUP_IN" data="document"/>

              <ie:param name="GROUP_OUT" data="documentx"/>

              <ie:param name="PASSWD" data="password"/>

              <ie:param name="TYPE" data="wt.epm.EPMDocument"/>

              <ie:param name="WHERE" data="thePersistInfo.modifyStamp>='$(@FORM[]moddate[])'"/>

              <ie:param name="WHERE" data="CADName='*.xml'"/>

              <ie:param name="ATTRIBUTE" data="*"/>

      </ie:webject>

       

      <ie:webject name="Query-Tree" type="OBJ">

          <ie:param name="INSTANCE" data="com.mycompany.Windchill" delim="!" valueSeparator="!" default="<%=com.infoengine.au.NamingService.getVMName()%>"/>

              <ie:param name="DBUSER" data="wcadmin"/>

              <ie:param name="GROUP_IN" data="documentx"/>

              <ie:param name="GROUP_OUT" data="documenty"/>

              <ie:param name="PASSWD" data="password"/>

              <ie:param name="TYPE" data="wt.epm.structure.EPMMemberLink"/>

              <ie:param name="DIRECTION" data="uses"/>   

              <ie:param name="DEPTH" data="9999" />

              <ie:param name="MODE" data="NESTED"/>

              <ie:param name="SELECTBY" data="LATEST"/>

      </ie:webject>