How to retrieve Change Activity Sequence without SQL (Windchill Change Planning)?

[SP_12330653]

Hello Team,

I need to programmatically retrieve the Sequence value of a Change Activity (WTChangeActivity2) as it appears in the Change Planning / Execution Plan. Currently, the only method that works is executing a direct SQL query on the CHANGEPLANACTIVITY table.

Example SQL (working):

SELECT parent.SEQUENCE

FROM WTCHANGEACTIVITY2MASTER cam

JOIN WTCHANGEACTIVITY2 ca

    ON ca.IDA3MASTERREFERENCE = cam.IDA2A2

JOIN CHANGEPLANNINGLINK cpl

    ON cpl.BRANCHIDA3B5 = ca.BRANCHIDITERATIONINFO

JOIN CHANGEPLANACTIVITY cpa

    ON cpa.IDA2A2 = cpl.IDA3A5

LEFT JOIN CHANGEPLANACTIVITY parent

    ON parent.IDA2A2 = cpa.IDA3PARENTREFERENCE

WHERE cam.WTCHGACTIVITYNUMBER = ?

However, this is not a supported API approach, and I want to avoid SQL.

I also tried using:

ChangePlanningHelper.modifyPlan(...)

Map<VersionableChangeItem, String> changeSeqMap

But this map only accepts sequence values for updates — it does not expose or return the current sequence.
changeSeqMap.get(ca) always returns null.

Question:

Is there any supported Windchill Java API (ChangePlanningHelper, ChangeHelper2, WTChangeActivity2, Info*Engine, etc.) that allows retrieving a Change Activity’s sequence number without using SQL?

If yes, please provide an example.
If not, can PTC confirm that SQL is the only available method?

Thanks in advance.

[Fadel]

Try this REST get : 

<Server>:443/Windchill/servlet/odata/v6/ChangeMgmt/ChangeTasks?%24select=ID%2CSequence&%24filter=Number%20eq%20'00509'&%24count=false 

[TDT]

Hi @SP_12330653,

There is a API getSequence() in ChangePlanActivity.

Could you check?

changePlanActivity.getSequence();

[SP_12330653]

There is no changePlanActivity.class in Windchill.

[TDT]

Which version are you using?

The Class is available in version 13.0

[HelesicPetr]

Hi @SP_12330653 

Yes there is .

You just need to install a Project Link. 

the class is definitely available in Windchill 11.+ I do not have earlier versions now 😄 

PetrH

[Imad_A · Accepted solution]

Hello @SP_12330653 

you can use this :

String sequenceNumber = (String) ChangePlanningHelper.getService().getExecutionValues(changeNotice).get(task);

        String CNNumber = "CHN00000001";
        String taskNumber = "00001";

        
        WTChangeActivity2 task =null;
        WTChangeOrder2 changeNotice = null;

        QuerySpec qs = new QuerySpec(WTChangeOrder2.class);
        qs.appendWhere(new SearchCondition(WTChangeOrder2.class, WTChangeOrder2.NUMBER, 
        		SearchCondition.EQUAL,CNNumber , false),new int[] { 0 });
        QueryResult results = PersistenceHelper.manager.find(qs);
        if (results.hasMoreElements()) {
        	changeNotice = (WTChangeOrder2) results.nextElement();
        }
        
        
        
     	QuerySpec qstask = new QuerySpec(WTChangeActivity2.class);
     	qstask.appendWhere(new SearchCondition(WTChangeActivity2.class,WTChangeActivity2.NUMBER, 
				SearchCondition.EQUAL, taskNumber),new int[] { 0 });
		
        QueryResult resultsTasks = PersistenceHelper.manager.find(qstask);
        if (resultsTasks.hasMoreElements()) {
        	task = (WTChangeActivity2) resultsTasks.nextElement();
        }
        
    
      String sequenceNumber = (String) ChangePlanningHelper.getService().getExecutionValues(changeNotice).get(task);
    

[SP_12330653]

Thanks, it Worked.