Question regarding validation rules for textbox

You could try substituting save!value for ri!module.serialNumber in your validations argument (in both places).

can you try passing the value of save!value instead of the ri!module.serialNumber
variable to validation rule?

Hi, I tried the same earlier, are you referring like below? It gives me an error stating it does not recognizes the variable save!value

a!textField(
label: "Serial Number",
value: ri!module.serialNumber,
saveInto: ri!module.serialNumber,
required: true,
validations: if(
rule!APN_isBlank(
save!value
),
{},
if(
rule!ICAMS_checkDuplicateSerialNumber(
ri!module.serialNumber
),
"Serial Number Already Exists",
{}
)
)
/*validationGroup: "Duplicate"*/
)

Sorry this is the snippet, previous one is wrong
a!textField(
label: "Serial Number",
value: ri!module.serialNumber,
saveInto: ri!module.serialNumber,
required: true,
validations: if(
rule!APN_isBlank(
ri!module.serialNumber
),
{},
if(
rule!ICAMS_checkDuplicateSerialNumber(
save!value
),
"Serial Number Already Exists",
{}
)
)
/*validationGroup: "Duplicate"*/
)

Yes was referring to the second code snippet.
Try using the instructions property to display the value of the ri!module.serialNumber, this will give us the value been passed to rule ICAMS_checkDuplicateSerialNumber

@saileshd: Which version of Appian your are in ? I believe in versions older than 7.6 the special variable save!value did not exist

@saileshd - We cannot use save!value in validations. It can be used in saveInto and a!save.
Please attach the code snippet of ICAMS_checkDuplicateSerialNumber so that we can get an idea of whats happening inside the expression.

#sidhantb, here is the code for rule expression checkDuplicateSerialNumber

load(
local!module: a!queryEntity(
entity: cons!ICAMS_MODULES_DATASTORE_ENTITY,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "OR",
logicalExpressions: {
a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "serialNumber",
operator: "=",
value: ri!serialNumber
),
a!queryFilter(
field: "isSystem",
operator: "=",
value: false
)
}
),
a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "serialNumber",
operator: "=",
value: ri!serialNumber
),
a!queryFilter(
field: "isSystem",
operator: "is null"
)
}
)
}
),
pagingInfo: a!pagingInfo(
1,
- 1
)
)
),
if(
local!module.totalCount > 0,
true,
false
)
)

Try the below,
1. As other practitioner told, map ri!module.serialNumber to instructions property to make sure the recent value is always passed to the validation rule. I am sure this would not be the issue but still to ensure.

2. Check if the data type of ri!module.serialNumber and ri!serialNumber in child rule are same (in your case i guess its integer). If ri!serialNumber is Text or any other data type, it may go always as null because it cannot hold your integer value passed from parent rule. In that case if your dB has some rows with null values for serialNumber it always returns those rows and hence the rule returns true().

@saileshd- As suggested by kumaraveln, can you check whether ri!serialNumber in checkDuplicateSerialNumber expression rule is Text or Integer. If it is Integer and you are passing Text from the parent, it trims the text(aplhabets,special characters) and retains only the numerics. The trimmed number might be present in the DB and this might cause a problem.
Please attach some screenshots of your test cases.

@kumaraveln - If ri!serialNumber is Text in parent and Integer in the child rule, then it does not go in as null but the alphabets and special characters are trimmed. Attaching screenshots.