Related content:

Discussion com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.UNDEFINED Question Error: No enum constant com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.SERIAL Question com.pega.pegarules.priv.generator.LibrarySupport::resolveAndInvokeFunctionViaReflectionWithException Question com.pega.pegarules.pub.database.MultipleRuleVersionException Question com.pega.pegarules.priv.context.CookieDisabledException in IE11 Question java.lang.NoClassDefFoundError: com/pega/pegarules/priv/alert/AlertBuildContext$ParameterPageFilterType Question com.pega.pegarules.pub.database.BadTableMappingException: Database-General Question Report Definition error "No enum constant com.pega.pegarules.data.external.rd.constants.ColumnType.INT IDENTITY" Question com.pega.pegarules.pub.database.BadClassDefinitionException Question com.pega.pegarules.pub.database.AuthorizationException
Contact a Moderator

Question

2
Replies
60
Views
jiand1 Member since 2019 5 posts
PEGA
Posted: 1 year ago
Last activity: 1 year 2 months ago
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***

Data Integration SR Exists
Close popover
Moderation Team has archived post
Posted: 1 year ago

    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";

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?
Share this page LinkedIn
Copied!