How to limit user displayname characters to 20 characters in insert query of DB connector

[harishyara]

Hi Team, We have a use case - while creating/inserting a new record into mysql database (DB connector) I need to check if user's displayname is more than 20 characters then I need to insert max upto 20 characters only. Please help to provide DB insert query syntax to limit username characters to 20. 

[rushikeshvartak]

${user.displayname.substring(0, 20)}

[NM]

@harishyara ${if (user.displayname.length>20){user.displayname.substring(0, 20)} else {user.displayname}}

[harishyara]

Hello @NM - could you please help me on above condition using conditional operator  ?

[rushikeshvartak]

${user.displayname ? user.displayname.substring(0, 20) : null}

[NM]

${(user.displayname.length>20)?user.displayname.substring(0, 20):user.displayname}

@harishyara 

[harishyara]

@NM - If I use above syntax getting this error: No such property: length for class: java.lang.String

[rushikeshvartak]

${(user.displayname.length()>20)?user.displayname.substring(0, 20):user.displayname}

length is mysql

length() is java