cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

How to add Max function QuerySpec

adev-2
4-Participant

How to add Max function QuerySpec

Hello,

 

I trying to create a QuerySpec to retrieve highest branchIditerationInfo (using MAX function) value to get the latest most object

 

Thanks

 

Ankit

2 REPLIES 2
jmomber
9-Granite
(To:adev-2)

You do something similar to the following:

 

QuerySpec subSelect = new QuerySpec();
subSelect.setAdvancedQueryEnabled(true);

ClassAttribute versionSortId = new ClassAttribute(WTPart.class, "versionInfo.identifier.versionSortId");
SQLFunction maxFunction = SQLFunction.newSQLFunction(SQLFunction.MAXIMUM, versionSortId);

subSelect.appendSelect(maxFunction, new int[]{wtPartIndex}, false);

 

This should get you headed in the right direction.

Hello Ankit,

Windchill help center has nice elaboration about SQLFunction here at

http://support.ptc.com/cs/help/windchill_hc/wc102_hc/index.jspx?id=WCCG_Serv_AdvQuery_SearchCondition&action=show

 

This contains an example of SQLFunction.MINIMUM but it will more or less identical for SQLFunction.MAXIMUM.

 

I hope this will help you in what you want to achieve.

 

Regards,

Shirish

Top Tags