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

    Search-Objects webject based on timestamp

    JeffStevenson Silver

      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>