How to use regular expression in queryspec search condition.

tale a look at https://www.ptc.com/en/support/article/CS173492 

Hi @Gajendra 

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.

Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,

Try this

// Constant expression using LIKE pattern to match leading zeros
ConstantExpression ce = new ConstantExpression("%66"); // matches 66, 066, 0066, etc.
ce.setUseEscape(true);

// Create search condition
SearchCondition sc1 = new SearchCondition(ca, SearchCondition.LIKE, ce);

Hi @Gajendra 

Generally, queryspec does not support regular expressions. You have to combinate the substitute sql characters as "_" for one character or "%" for multiple characters. 

PetrH