cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Search-Objects webject based on timestamp

Highlighted

Search-Objects webject based on timestamp

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">

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

<ieSmiley Tonguearam name="DBUSER" data="wcadmin"/>

<ieSmiley Tonguearam name="GROUP_OUT" data="document"/>

<ieSmiley Tonguearam name="PASSWD" data="password"/>

<ieSmiley Tonguearam name="TYPE" data="wt.epm.EPMDocument"/>

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

<ieSmiley Tonguearam name="WHERE" data="CADName='*.xml'"/>

<ieSmiley Tonguearam name="VERSION" data="LATEST"/>

<ieSmiley Tonguearam name="ITERATION" data="LATEST"/>

<ieSmiley Tonguearam name="ATTRIBUTE" data="*"/>

</ie:webject>

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

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

<ieSmiley Tonguearam name="DBUSER" data="wcadmin"/>

<ieSmiley Tonguearam name="GROUP_IN" data="document"/>

<ieSmiley Tonguearam name="GROUP_OUT" data="documentx"/>

<ieSmiley Tonguearam name="PASSWD" data="password"/>

<ieSmiley Tonguearam name="TYPE" data="wt.epm.EPMDocument"/>

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

<ieSmiley Tonguearam name="WHERE" data="CADName='*.xml'"/>

<ieSmiley Tonguearam name="ATTRIBUTE" data="*"/>

</ie:webject>

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

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

<ieSmiley Tonguearam name="DBUSER" data="wcadmin"/>

<ieSmiley Tonguearam name="GROUP_IN" data="documentx"/>

<ieSmiley Tonguearam name="GROUP_OUT" data="documenty"/>

<ieSmiley Tonguearam name="PASSWD" data="password"/>

<ieSmiley Tonguearam name="TYPE" data="wt.epm.structure.EPMMemberLink"/>

<ieSmiley Tonguearam name="DIRECTION" data="uses"/>

<ieSmiley Tonguearam name="DEPTH" data="9999" />

<ieSmiley Tonguearam name="MODE" data="NESTED"/>

<ieSmiley Tonguearam name="SELECTBY" data="LATEST"/>

</ie:webject>