Lot of time we have requirement which involves restricting user input to certain length. Most common way to do that is to specify the Text Length property of the field. I used to do that until recently when I came to know that even after specifying field length user was able to enter more than the allowed limit.

Going through the bookshelf I read a note which said

“Text Length property is usually ignored and the length is retrieved from the underlying column definition”

So, that in effect means that whatever is the column length at the database level is limit at the BC level too. But that is not what we wanted so after further exploration we came across a user property that could help us to limit length without modifying the column at database level.

  • Text Length Override

Text Length Override and it can have a value as TRUE which means enforce the Text Length field property or it can have a different value such as 10 or 20 which means that will become the new limit.

Here is a step by step procedure on how to use this user property.

  • Query for the BC in which the desired field is present
  • Select the field on which you want to enforce the limit
  • In object explorer click on the + sign against field and select User Property option as shown below
    Siebel tools Object explorer screenshot
  • Create a new record in the Field User Property area
  • Enter the following information

    Name: Text Length Override
    Value: TRUE
    OR
    Name: Text Length Override
    Value: 10

Where the number is the limit that you want to enforce and you are done. Compile and see the changes.

Note: This user property can only be used with text type fields.

Happy Configuration :))  !!!

OkAvarageGoodVery GoodExcellent (3 votes, average: 4 out of 5)
Loading ... Loading ...

Related Posts