Hi All, I have a doubt, someone know how I can validate that a field that only accepts Strings no numbers?
Best Answer
S
Stéphanie FOURRIER
said
over 2 years ago
you can create your own SemQLValidation in your entity and use a REGEXP_LIKE condition in it, like this :
NOT REGEXP_LIKE(FirstName, '[0-9]')
Then you have to make sure of when the SemQLValidation is triggered, and I would recommend having a look at this community post about possible options (the post mentions a Mandatory validation, but all the trigger options are the same for all Validations).
Don't hesitate to have a look at our SemQL Reference Guide for more information about REGEXP_LIKE and other available functions for the database you are running on.
1 Comment
S
Stéphanie FOURRIER
said
over 2 years ago
Answer
you can create your own SemQLValidation in your entity and use a REGEXP_LIKE condition in it, like this :
NOT REGEXP_LIKE(FirstName, '[0-9]')
Then you have to make sure of when the SemQLValidation is triggered, and I would recommend having a look at this community post about possible options (the post mentions a Mandatory validation, but all the trigger options are the same for all Validations).
Don't hesitate to have a look at our SemQL Reference Guide for more information about REGEXP_LIKE and other available functions for the database you are running on.
Stéphanie FOURRIER
Hi All, I have a doubt, someone know how I can validate that a field that only accepts Strings no numbers?
you can create your own SemQL Validation in your entity and use a REGEXP_LIKE condition in it, like this :
Then you have to make sure of when the SemQL Validation is triggered, and I would recommend having a look at this community post about possible options (the post mentions a Mandatory validation, but all the trigger options are the same for all Validations).
Don't hesitate to have a look at our SemQL Reference Guide for more information about REGEXP_LIKE and other available functions for the database you are running on.
Stéphanie FOURRIER
you can create your own SemQL Validation in your entity and use a REGEXP_LIKE condition in it, like this :
Then you have to make sure of when the SemQL Validation is triggered, and I would recommend having a look at this community post about possible options (the post mentions a Mandatory validation, but all the trigger options are the same for all Validations).
Don't hesitate to have a look at our SemQL Reference Guide for more information about REGEXP_LIKE and other available functions for the database you are running on.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 263 topics