topic Re: How to retrieve Change Activity Sequence without SQL (Windchill Change Planning)? in Windchill Customization

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

SP_12330653 — Tue, 10 Feb 2026 09:57:19 GMT

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.

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

Fadel — Tue, 10 Feb 2026 10:33:15 GMT

Try this REST get :

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

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

TDT — Tue, 10 Feb 2026 10:36:30 GMT

Hi @SP_12330653,

There is a API getSequence() in ChangePlanActivity.

Could you check?

changePlanActivity.getSequence();

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

SP_12330653 — Tue, 10 Feb 2026 13:12:33 GMT

There is no changePlanActivity.class in Windchill.

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

Imad_A — Tue, 10 Feb 2026 13:33:36 GMT

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);

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

TDT — Tue, 10 Feb 2026 14:03:07 GMT

Which version are you using?

The Class is available in version 13.0

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

HelesicPetr — Tue, 10 Feb 2026 14:25:35 GMT

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

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

SP_12330653 — Tue, 10 Feb 2026 17:41:32 GMT

Thanks, it Worked.