topic Re: Checking for document creation before allow task completion in Windchill

Checking for document creation before allow task completion

GregOlson — Wed, 02 May 2018 12:13:56 GMT

I need assistance creating a code for a conditional node that will check to make sure the task has been complete. The task for this particular node is that the user creates a service request within windchill. How I see this working would be the system would look at the PBO of the

Re: Checking for document creation before allow task completion

GregOlson — Thu, 01 Oct 2015 15:18:26 GMT

This code might be closer to what I need....this one looks at an attribute of the PBO and compares it to any change notices that are out in the system...then makes a routing decision based on the return.

Object pbo=primaryBusinessObject;

boolean shootEmail=false;

wt.doc.WTDocument myDoc=null;

Object SONumber = null;

String SONumberValue=null;

Object ECNSONumber =null;

String ECNSONumberValue =null;

if(pbo.getClass().isAssignableFrom(wt.doc.WTDocument.class)){

//System.out.println("\n\n\t\t********PBO is a WTDocument!");

myDoc=(wt.doc.WTDocument)primaryBusinessObject;

//System.out.println("\n\n\t\t********PBO is a WTDocument with numaber "+myDoc.getNumber());

com.ptc.core.lwc.server.PersistableAdapter obj = new com.ptc.core.lwc.server.PersistableAdapter(myDoc,null,java.util.Locale.ENGLISH,null);

obj.load("Sales_Order_Number");

SONumber = obj.get("Sales_Order_Number");

if(SONumber!=null){

SONumberValue=SONumber.toString();

}else{

//System.out.println("\n\n\t\t********SONumber is Null.Please check the Attribute Internal Name!");

}

//we have the SONumber for WTDocument now. We will now search for CNs

wt.query.QuerySpec qs= new wt.query.QuerySpec(wt.change2.WTChangeOrder2.class);

wt.fc.QueryResult qr= wt.fc.PersistenceHelper.manager.find(qs);

while (qr.hasMoreElements()) {

wt.change2.WTChangeOrder2 CN = (wt.change2.WTChangeOrder2) qr.nextElement();

com.ptc.core.lwc.server.PersistableAdapter obj2 = new com.ptc.core.lwc.server.PersistableAdapter(CN,null,java.util.Locale.ENGLISH,null);

obj2.load("Sales_Order_Number");

ECNSONumber = obj2.get("Sales_Order_Number");

if(ECNSONumber!=null){

ECNSONumberValue=ECNSONumber.toString();

//if we find a CN with matching SON

if(ECNSONumberValue.contains(SONumberValue)){

String ECNState=CN.getState().toString();

if(!ECNState.equalsIgnoreCase("RESOLVED")){

shootEmail=true;

}

}else{

//System.out.println("\n\n\t\t********ECNSONumber is Null.Please check the Attribute Internal Name!");

}

if(shootEmail){

//System.out.println("\n\n\t\t********Result is Shoot email!");

result="shootEmail";

}else{

result="go";

}

Re: Checking for document creation before allow task completion

kpritchard — Thu, 01 Oct 2015 22:57:50 GMT

From what I can see, you would need to create an InfoEngine Task to query based on an IBA (custom attribute)

Re: Checking for document creation before allow task completion

LoriSood — Fri, 13 Nov 2015 23:52:02 GMT

Hi Greg, any luck using Keir's suggestion here?

Re: Checking for document creation before allow task completion

GregOlson — Mon, 16 Nov 2015 15:15:38 GMT

With PTCs help I was able to get code working in a conditional node...see below:

Object pbo = primaryBusinessObject;

boolean createSRQ = false;

wt.doc.WTDocument myDoc = null;

String QSNValue = null;

Object QSN = null;

String SRQSNValue = null;

Object SRQSN = null;

if(pbo.getClass().isAssignableFrom(wt.doc.WTDocument.class)){

System.out.println("\n\t******** PBO is a WTDocument!");

myDoc = (wt.doc.WTDocument) primaryBusinessObject;

System.out.println("\n\t******** PBO number " + myDoc.getNumber());

com.ptc.core.lwc.server.PersistableAdapter obj = new com.ptc.core.lwc.server.PersistableAdapter(myDoc,null,java.util.Locale.ENGLISH,null);

obj.load("Serial.Number");

QSN = obj.get("Serial.Number");

if(QSN != null){

QSNValue = QSN.toString();

System.out.println("\n\tSerial Number IBA on Sales Questionnaire is: " + QSNValue);

}else{

System.out.println("\n\t********Serial Number is Null. Please check the Attribute Internal Name!");

}

// Below is second part, this is querying only "Service Request" WTDocuments and checking matching IBA value

com.ptc.core.meta.common.IdentifierFactory IDENTIFIER_FACTORY = (com.ptc.core.meta.common.IdentifierFactory) wt.services.ServiceProviderHelper.getService(com.ptc.core.meta.common.IdentifierFactory.class, "logical");

com.ptc.core.meta.common.TypeIdentifier tid = null;

try {

tid = (com.ptc.core.meta.common.TypeIdentifier) IDENTIFIER_FACTORY.get("com.M_BCO.CORP.Service_Request");

} catch (com.ptc.core.meta.common.IllegalFormatException e) {

e.printStackTrace();

}

Class qc = wt.doc.WTDocument.class;

wt.query.QuerySpec qs = null;

try {

qs = new wt.query.QuerySpec();

} catch (wt.query.QueryException e) {

e.printStackTrace();

}

int idx = 0;

try {

idx = qs.addClassList(qc, true);

} catch (wt.query.QueryException e) {

e.printStackTrace();

}

wt.query.SearchCondition sc = null;

try {

sc = wt.type.TypedUtilityServiceHelper.service.getSearchCondition(tid, true);

} catch (wt.util.WTException e1) {

e1.printStackTrace();

}

try {

qs.appendWhere(sc, new int[] { idx });

} catch (wt.query.QueryException e1) {

e1.printStackTrace();

}

// System.out.println("*** Printing QS: " + qs);

wt.fc.QueryResult qr = null;

try {

qr = wt.fc.PersistenceHelper.manager.find((wt.pds.StatementSpec)qs);

} catch (wt.util.WTException e) {

e.printStackTrace();

}

// Iterate through all "Service Request" WTDocuments & check if it has matching QSNValue == SRQSNValue value

while (qr.hasMoreElements()) {

wt.fc.Persistable[] ar = (wt.fc.Persistable[]) qr.nextElement();

wt.doc.WTDocument doc = (wt.doc.WTDocument) ar[idx];

com.ptc.core.lwc.server.PersistableAdapter obj2 = new com.ptc.core.lwc.server.PersistableAdapter(doc,null,java.util.Locale.ENGLISH,null);

obj2.load("Serial_Number");

SRQSN = obj2.get("Serial_Number");

if(SRQSN != null){

SRQSNValue = SRQSN.toString();

System.out.println("\n\tSerial Number IBA on Service Request is: " + QSNValue);

if (QSNValue.contains(SRQSNValue)) {

System.out.println("\n\t Hurreyyyyy... We found matching Serial Number!!!");

createSRQ = true;

}

else {

System.out.println("\n\t Bad luck, no matching Serial Number found. Create one to proceed further...");

createSRQ = false;

}

}else{

System.out.println("\n\n\t\t********SRQSN is Null.Please check the Attribute Internal Name!");

}

if(createSRQ){

result="go";

}else{

result="reroute";

}