Problem Report - Set Resolution Date

Question

We have a need to manually set the Resolution Date on some legacy problem reports. I don't see a way of doing it through the user interface. Has anybody done something like this either through an info*engine task, java code, or database manipulation?

Only looking to update <100 objects so want to find a simple solution.

avillanueva · Answer

This is a command line program I had to do this for an EC:

The bolded line can be swapped for a Problem Report version:

WorkflowProcessHelper.setPRResolutionDate(WTChangeIssue pr)

That code uses the current system Timestamp. If you need to back date
it, you need to call setResolutionDate(Timestamp t) on the PR and save
it (PersistenceHelper.manager.save(pr)).

package customization.cmdJobs;

import wt.auth.*;

import wt.httpgw.GatewayAuthenticator;

import java.io.*;

import java.util.*;

import wt.fc.*;

import wt.method.*;

import wt.query.QuerySpec;

import wt.util.*;

import wt.query.SearchCondition;

import java.util.*;

import com.ptc.windchill.cadx.common.util.ObjectDependencyUtility;

import java.util.*;

import wt.part.*;

import wt.change2.*;

import customization.dcc.*;

import customization.dcc.beans.*;

import java.net.URL;

import wt.workflow.*;

import wt.workflow.engine.*;

import wt.workflow.work.*;

import wt.inf.container.*;

/**

*

* @author Antonio.Villanueva

*/

public class FixEC{

//private static GoodrichECService helper=GoodrichECHelper.service;

/** Creates a new instance of MovePartstoDocsJob */

public FixEC() {

}

public static void main (String[] args) throws Exception

{

System.out.println("Connected to PDMLink!");

QuerySpec queryspec;

boolean done=false;

String ecNumber;

String choice;

try {

System.out.println("Enter EC number that released BOMs. Hit
just return to query by part number");

BufferedReader br = new BufferedReader(new
InputStreamReader(System.in));

System.out.print("EC Number (#####-PID): ");

choice = br.readLine();

ecNumber=choice;

queryspec = new QuerySpec(WTChangeOrder2.class);

queryspec.appendWhere(new
SearchCondition(WTChangeOrder2.class,WTChangeOrder2.NUMBER,SearchConditi
on.EQUAL,choice.toUpperCase()));

QueryResult
result=PersistenceHelper.manager.find(queryspec);

if (result.size()==1)

{

WTChangeOrder2 ec=(WTChangeOrder2)result.nextElement();

com.ptc.windchill.pdmlink.change.server.impl.WorkflowProcessHelper.setEC
NResolutionDate(ec);

}

else

System.out.println("EC not found by that number");

}

catch (IOException ioe) {

System.out.println("Error with input");

System.exit(1);

}

}

}

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded