Antonio, did you ever figure out the isLatestVersion issue in the where clause? I'm able to use it as an attribute to return, but not in my Where clause.
My error is identical to what you have in my infoengine task.
<%@page language="java" session="false"%>
<%@taglib uri="http://www.ptc.com/infoengine/taglib/core" prefix="ie"%>
<ie:webject name="Get-Properties" type="MGT">
<ie:param name="AUTHORIZATION" data="${@SERVER[]authorization[]}"/">
<ie:param name="ATTRIBUTE" data="wt.federation.ie.VMName"/">
<ie:param name="GROUP_OUT" data="properties"/">
</ie:webject>
<ie:webject name="Query-Objects" type="OBJ">
<ie:param name="INSTANCE" data="${properties[0]wt.federation.ie.VMName[0]}" valueseparator=";" delim=";"/>
<ie:param name="ATTRIBUTE" data="obid,number,isLatestVersion,name,lifeCycleTemplate.name,containerName,iterationInfo.latest" delim=","/">
<ie:param name="TYPE" data="wt.part.WTPart"/">
<ie:param name="WHERE" data="isLatestVersion.id=true"/">
<ie:param name="GROUP_OUT" data="myQuery"/">
</ie:webject>
Thx
Steve D.
In Reply to Antonio Villanueva:
I've been through the guides, can't seem to find an example of where
clause other than single clause. I am using dca-Query.xml and want to
find WTParts by a number, view and that are the latest version. Here is
my code:
task.addParam("search_type", "wt.part.WTPart"); //should get WTPart
task.addParam("where",
"number="+topLevelWTPart+",isLatestVersion="+"true"); //WTPart number
Task seems to indicate that where can have multiple entries and is comma
delimited.
<ie:param name="type" data="${@FORM[]search_type[]}"/">
<ie:param name="where" data="${@FORM[]where[*]}"<br"/>delim="," default="()"/>
Does someone have an example of multiple where expressions? What about
AND and OR expressions?
I looked up the logical names and it does show that isLatestVersion is
available but returned following message.
com.infoengine.util.IEException:
com.ptc.core.meta.common.impl.LogicalAttributeFormatException: Unable to
find logical a
ttribute: "isLatestVer.id with context: "WCTYPE|wt.part.WTPart"
Nested exception is:
com.ptc.core.meta.common.impl.LogicalAttributeFormatException: Unable to
find logical attribute: "i
sLatestVer.id with context: "WCTYPE|wt.part.WTPart"; nested exception
is: com.ptc.core.command.common.CommandException:
com.ptc.core.meta.common.impl.LogicalAttributeFormatException: Unable
to find logical attribute: "isLatestVer.id with c
ontext: "WCTYPE|wt.part.WTPart"
Nested exception is:
com.ptc.core.meta.common.impl.LogicalAttributeFormatException: Unable to
find logical attribute: "i
sLatestVer.id with context: "WCTYPE|wt.part.WTPart"
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
com.infoengine.procunit.IEExceptionUtil.checkCollectionForErrors(IEExcep
tionUtil.java:137)
at
com.infoengine.procunit.IEExceptionUtil.checkCollectionForErrors(IEExcep
tionUtil.java:34)
at com.infoengine.SAK.Task.executeTaskRemotely(Task.java:2069)
at com.infoengine.SAK.Task.invoke(Task.java:1713)
Thanks in advance for any pointers.
