Hi Kaushik,
Above code is working perfect for Product, but for WTLibarary, i have create similar method, but i am getting "wt.query.QueryException: Attribute "containerReferene.key.id" is not a member of class "class wt.part.WTPart"
here is Program,
Please guide me to solve this error,
===========================================================
import wt.doc.WTDocument;
import wt.epm.EPMDocument;
import wt.fc.Persistable;
import wt.fc.PersistenceHelper;
import wt.fc.QueryResult;
import wt.inf.library.WTLibrary;
import wt.lifecycle.LifeCycleHelper;
import wt.lifecycle.LifeCycleState;
import wt.part.WTPart;
import wt.pdmlink.PDMLinkProduct;
import wt.pds.StatementSpec;
import wt.query.CompositeQuerySpec;
import wt.query.QueryException;
import wt.query.QuerySpec;
import wt.query.SearchCondition;
import wt.util.WTException;
public class ObjectFromContainer {
public static void main(String[] args) {
try{
WTPart part=null;
WTDocument doc=null;
EPMDocument epm=null;
Persistable[] pers=null;
String name="Test Lib";
// * Entering QuerySpec for multiple query statements by CompositeQuerySpec
CompositeQuerySpec cqs = new CompositeQuerySpec();
cqs.addComponent(statementspecGenerator(WTPart.class,"TestProduct"));
cqs.addComponent(statementspecGenerator(WTDocument.class,name));
cqs.addComponent(statementspecGenerator(EPMDocument.class, "TestProduct"));
QueryResult queryResult2 = PersistenceHelper.manager.find((StatementSpec)cqs);
System.out.println(queryResult2.size());
while(queryResult2.hasMoreElements())
{
pers=(Persistable[]) queryResult2.nextElement();
for(Persistable p:pers)
{
// * Changing the LifeCycleState of the objects As given
if(p instanceof WTPart)
{
part=(WTPart) p;
System.out.println("Parts are"+((WTPart) p).getName());
}
else if(p instanceof WTDocument)
{
doc=(WTDocument) p;
System.out.println("Documents are"+((WTDocument) p).getName());
}
else if(p instanceof EPMDocument)
{
epm=(EPMDocument) p;
System.out.println("EPM's are"+((EPMDocument) p).getName());
}
}
}
System.out.println("*******All Process Completed *********");
}
catch(QueryException e)
{
e.printStackTrace();
} catch (WTException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@SuppressWarnings("unchecked")
private static StatementSpec statementspecGenerator(Class c,String contName) throws WTException
{
QuerySpec queryspec = new QuerySpec(c);
queryspec.isAdvancedQueryEnabled();
int contIndex = queryspec.appendClassList(PDMLinkProduct.class,false);
SearchCondition sc1 = new SearchCondition(c, "containerReference.key.id",PDMLinkProduct.class, wt.util.WTAttributeNameIfc.ID_NAME);
queryspec.appendWhere(sc1, new int[] { 0, contIndex });
queryspec.appendAnd();
SearchCondition scSWPart = new SearchCondition(PDMLinkProduct.class ,"containerInfo.name",SearchCondition.EQUAL,contName,true);
queryspec.appendWhere(scSWPart, new int[] { contIndex });
return (StatementSpec)queryspec;
}
// For WTLiberyext.racing.ObjectFromContainer
@SuppressWarnings("unchecked")
private static StatementSpec statementspecGeneratorLibrary(Class c,String contName) throws WTException{
QuerySpec queryspec = new QuerySpec(c);
queryspec.isAdvancedQueryEnabled();
int contIndex = queryspec.appendClassList(WTLibrary.class, false);
SearchCondition sc1 = new SearchCondition(c,"containerReferene.key.id",WTLibrary.class,wt.util.WTAttributeNameIfc.ID_NAME);
queryspec.appendWhere(sc1, new int[]{ 0, contIndex });
queryspec.appendAnd();
SearchCondition scSWPart = new SearchCondition(WTLibrary.class,"conatinerInfo.name",SearchCondition.EQUAL,contName,true);
queryspec.appendWhere(scSWPart,new int[]{contIndex});
return (StatementSpec)queryspec;
}
}
=============================================================
// when i call statementspecGeneratorLibrary method i am getting error.
Please guide me.
Regards,
Vivek
