Character Limits for Landmark Fields

Is there a way through Configuration Console to edit the character limits of a field? For example the Work Schedule value displayed on the Talent Requisition form is set to have a 20 character limit. Within the table of the database the data type is set to nvarchar(20). I am cognizant of the potential to edit the structure directly in the database however I worry that a future update/patch would just overwrite the value or that it would cause problems down the line.

Appreciate any feedback/advise

Find more posts tagged with

Infor Lawson Technology Group - Discussion

Comments

don-peterson

I recently posed a question like this to Landmark development and their answer was that the delivered fields are not able to be modified via Configuration Console. The way to do what you want, to avoid your noted concern with updates/patches, would be to create a user field to handle the larger size.

M3_Japan User Community Webinar_24Nov2022 - ???.zip

unknown

Interesting. So do I have to do this in LPL or can I use the GUI to create a user field and set the limit?

unknown

Nevermind. I didn't actually think about what you were saying. I can create a custom user field. Thank you I will attempt.

don-peterson

I read your original posting as wanting to increase the size of the field from 20 to 25, for example. With your first response referring to "limit" I am wondering if you wanted to leave the delivered field at 20, but have it so that users may not enter more than 15, for example. If it is the later, you could select the field in the form configuration and select Configure. Then enter a constraint in the form of a regular expression. An example would be limiting how a Social Security Number can be entered.

(EmployeeSSN matches "^[1-9]d{2}-d{2}-d{4}$")

Dr. Awesome

Wonder also if using the "size" TypeOperator works here as well.

WorkSchedule

constraint(WorkSchedule size <= 80)

"WorkSchedule_must_be_80_character_or_less."

Copyright © 2025 Infor. All rights reserved.