Configure The Dictionary Entry Table

[Snow Tomcal]

Hi All,

I want to add a column to the 'sys_dictionary' table.

Are there any bad consequences that can be cased by this?

Thanks:)

[Anurag Tripathi]

I would not recommend doing that.

You can filter and get to the table and identify any task record, you can come up with any logic that runs for change request.

[Snow Tomcal]

But where should I store the regex for each field?

[Community Alums]

I would suggest to create a new table to store your regex in. Add a table and field_name fields. Maybe, depending on your requirements even add a condition field.

This way you can use it on every table and field without having to touch the dictionary, or even another OOTB table in the system.

[Community Alums]

@Snow Tomcal ,

Here i suggest to strongly use system property which is very efficient , you can create a key:value pairs and update the sys properties when every you have a new entry. You can call this sys property anywere in your code easily...

i hope this help...