Question
2
Replies
70
Views
Posted: July 8, 2019
Last activity: July 9, 2019
Closed
com.pega.pegarules.priv.database.sqlgen.constants.OperatorType options
From a guide I see that there's the .EQ, .GT, .LTE options. Is there any documentation or a way to find out all the options? Looking for a 'LIKE' property for this SQL query.
***Edited by Moderator Marissa to update SR Details***
Posted: 1 year ago
Hi Kevin,
Just making sure that this will help the customer out for SR-D28518. In the attached doc, in section 'Updating records using Native SQL', it describes com.pega.pegarules.priv.database.sqlgen.constants.OperatorType.EQ and .GT and .LTE shorthand options, so I wonder what the shorthand for 'LIKE' would be?
public static final String EQUALS = "=";
public static final String NOTEQUALS = "!=";
public static final String GREATER = ">";
public static final String GREATER_EQUAL = ">=";
public static final String LESSER = "<";
public static final String LESSER_EQUAL = "<=";
public static final String STARTSWITH = "startswith";
public static final String NOTSTARTSWITH = "notstartswith";
public static final String ENDSWITH = "endswith";
public static final String NOTENDSWITH = "notendswith";
public static final String CONTAINS = "contains";
public static final String NOTCONTAINS = "notcontain";
public static final String LIKE = "like";