Article - CS173492
Underscore in SearchCondition.LIKE "XXX_%" ignored by QuerySpec query in Windchill PDMLink
Modified: 27-Sep-2022
Applies To
- Windchill PDMLink 10.1 M040 to 12.0
Description
- Underscore "XXX_%" in SearchCondition.LIKE ignored by QuerySpec query
- A search for "XXX_*" with the Windchill UI with criteria "Keyword=XXX_*; Type=CAD Document; Context=All Contexts" returns 9 objects all prefixed with "XXX_" e.g.: XXX_BASE.ASM, XXX_NOZZLES.ASM,
qs = new QuerySpec(wt.epm.EPMDocument.class);
SearchCondition sc1 = new SearchCondition(EPMDocument.class, EPMDocument.NUMBER, SearchCondition.LIKE, "XXX_%");
qs.appendWhere(sc1);
qr = PersistenceHelper.manager.find(qs);
System.out.println("qr.size()= " + qr.size());
- Unable to search WTGroup with leading "_" using QuerySpec criteria SearchCondition.LIKE, "\\_"
This is a printer-friendly version of Article 173492 and may be out of date. For the latest version click CS173492