Question
Noida Institute of Engineering & Technology
IN
Last activity: 22 Feb 2024 6:14 EST
Is there any way to restrict the value to be stored in datatype(Database)?
I have a requirement in which I need to set only if the status value is Active,expired or inactive in DB without the use of validate rule/Edit-validate rule. So, How can I Restrict values to be store.
***Edited by Moderator Rupashree to add Capability tags***
Accepted Solution
Updated: 22 Feb 2024 6:12 EST
NCS Pte. Ltd
SG
Hi @SANDBIT: Can you provide more details on the request? What are the possible values for the specific field?
You can add a prompt list / field value in the property table type which will implicitly help you to do the validations.
Thanks.
Noida Institute of Engineering & Technology
IN
Hi @ArulDevan, For example - In DB I need to store value for status field that only store value as Active,Inactive,Expired or Revoked. That DB maybe delegated to the authorized user which can change status as required in future so in that case it should not accept other inputs apart from them(I think of using picklist as field type but my TL said no).
Noida Institute of Engineering & Technology
IN
@ArulDevan. In property : Table type - field value.Thanks... It worked for me
Updated: 22 Feb 2024 6:12 EST
Maantic Inc
IN
@SANDBIT Use local list in property and give the mentioned status, when you map data into that property it will implicitly throw error if you try to put other values in DB.