Displaying promoted-on date from maturity history only if the change notice in Resolved state in QML

I understand that you want to build a Query Builder report, which will display the WTChangeOrder2 ResolutionDate -- but only when the lifecycle state of the WTChangeOrder2 is RESOLVED.  One way is to follow the procedure for adding a Java method for use in QueryBuilder -

1) Documentation at https://support.ptc.com/help/wnc/r12.1.1.0/en/?#page/Windchill_Help_Center/customization/WCCG_BUSLogicCust_ReportGeneration_JavaMethods.html

2) Example file which takes a CN, and displays Resolution Date if lifecycle state is RESOLVED  -- otherwise it displays nothing -- at bottom - create java file and compile

3) Add this line to Windchill/conf/queryBuilderMethods.xml

<method class="ext.tsd.QueryBuilderHelper" name="getResolutionDateIfStateResolved" static="true"/>

4) Load application data (instructions in documentation above)

5) Select in Query Builder by passing CN

package ext.tsd;
import java.sql.Timestamp;
import wt.change2.WTChangeOrder2;
import wt.lifecycle.State;

public class QueryBuilderHelper {
	public static Timestamp getResolutionDateIfStateResolved(WTChangeOrder2 wtChangeOrder2) {
		if(wtChangeOrder2 != null && wtChangeOrder2.getLifeCycleState().equals(State.toState("RESOLVED"))) {
			return wtChangeOrder2.getResolutionDate();
		}
		return null;
	}
}