windchill查詢忽略大小寫

/**
	 * @description 忽略大小寫查詢
	 * @author Lin
	 * @date 2020年10月15日
	 * @param partNum
	 * @throws Exception
	 */
	public static void ignoreCaseSelect(String partNum) throws Exception {
		QuerySpec qs = new QuerySpec(WTPartMaster.class);
		ClassAttribute classAttribute = new ClassAttribute(WTPartMaster.class, WTPartMaster.NUMBER);
		ColumnExpression expression = ConstantExpression.newExpression(partNum.toLowerCase());// partNum.toUpperCase()
		SearchCondition searchCondition = new SearchCondition(
				SQLFunction.newSQLFunction(SQLFunction.LOWER, classAttribute), SearchCondition.LIKE, expression);// SQLFunction.UPPER
		qs.appendWhere(searchCondition, new int[] { 0 });
		System.out.println(qs.toString());
		QueryResult qr = PersistenceHelper.manager.find((StatementSpec) qs);
		while (qr.hasMoreElements()) {
			WTPartMaster partMaster = (WTPartMaster) qr.nextElement();
			WTPart latestPart = (WTPart) VersionControlHelper.service.allVersionsOf(partMaster).nextElement();//擷取最新版本
			System.out.println(latestPart);
		}
	}