Validation not working as expected after changing the field name

Hi sunus,

1.) please try this function for inserting code. It helps the reader a lot to understand your code

2.) What kind of behavior do you expect?  

a!textField(
label: "Purchase order (PO)/Sales order (SO)/STO/Requisition",
labelPosition: "ABOVE",
value: trim(
index(
ri!PF_Request,
"Order_Del_Number",
null
)
),
saveInto: {
a!save(
ri!PF_Request.Order_Del_Number,
/*if(ri!PF_Request.GBEID=18,*/
/*left(*/
/*trim(*/
/*save!value*/
/*),10),*/
/*trim(*/
/*save!value*/
/*))*/
trim(save!value)
)
},
required: true,
validations:if(ri!PF_Request.GBEID = 18, if(regexmatch("^([0-9]{1,10})$",ri!PF_Request.Order_Del_Number),null,"The number provided should not contain any special character and can have upto 10 digits"), null )


)

ok added the code as you advised,  but expected behaviour is validation should work.

sunus0001 said:

is validation should work.

love this answer  but what do you define as " should work". What is the target of your evaluation?
I can try to explain the general behavior of regexmatch()
if your string ri!pf_request.order_del_number contains all the signs of "^([0-9]{1,10})$" then the return value will be true. If one of them is not included, the returnvalue will be false.
simple examples:

• regexmatch("helo","Hello") = true
• regexmatch("h","Hello") = true
• regexmatch("heli","Hello") = false
• regexmatch("hal","Hello") =false

I think you can try the following:

if(
    or(
        len(ri!PF_Request.Order_Del_Number)>10,
        len(stripwith(ri!PF_Request.Order_Del_Number,"1234567890"))>0
    ),
    "The number provided should not contain any special character and can have upto 10 digits"), 
    {}
)

HI Richard ,

Thanks for the reply

You did not got what am asking for ?

Please go through below link to understand the datatype am using  and before changing datatype the same line of code that has regular expression validation has worked.

But now it is not working I want to know reason why that happened and what is the resolution.

https://community.appian.com/discussions/f/process/22377/how-can-i-just-give-a-display-name-to-columns-in-cdt-which-has-a-different-name-in-database-tables-also-i-have-more-questions-regarding-appian-features/87736#87736

thanks

Sunu Sam

your regex function is working fine for my example (click on the picture and it becomes bigger and more clear)

is your "ri!PF_Request.GBEID = 18" fine?

Hi Richard,

yes you are right problem is not regular expression but the column name change.

In the CDT used, display name is Order_DEL_Number and DB column name is purchaseordernumber. So Issue is that it is not reading the field.

In the earlier discussion with Appian team it is informed that different display name and DB column name for same field in CDT will work fine.

But I am facing the issue that validation is failing.

Thanks

Sunu Sam

Hi Richard,

yes you are right problem is not regular expression but the column name change.

In the CDT used, display name is Order_DEL_Number and DB column name is purchaseordernumber. So Issue is that it is not reading the field.

In the earlier discussion with Appian team it is informed that different display name and DB column name for same field in CDT will work fine.

But I am facing the issue that validation is failing.

Thanks

Sunu Sam

you can match your DB column name to your CDT parameter name via XSD import/Export?

Did you try that?

Example how a column definition can look like in a XSD 

      <xsd:element name="role" nillable="true" type="xsd:string">
        <xsd:annotation>
          <xsd:appinfo source="appian.jpa">@Column(name="ROLE", columnDefinition="VARCHAR2(12)")</xsd:appinfo>
        </xsd:annotation>
      </xsd:element>
   

ROLE was the name of the DB Column and "role" of the CDT Attribute

HI Richard ,

I am adding the cdt which i have used for datatype using XSD import/export.

 <xsd:element name="Order_Del_Number" nillable="true" type="xsd:string">
        <xsd:annotation>
          <xsd:appinfo source="appian.jpa">@Column(name="purchaseorder", length=255)</xsd:appinfo>
        </xsd:annotation>
      </xsd:element>

Let me know is that right or not?

Thanks

Sunu Sam

Hi sunus,

looks fine to me regarding names. But i am not sure regarding " columnDefinition" 

Perhaps check that again.

kind Regards,

Richard