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:)

[S Goutham]

@Snow Tomcal : can you elaborate the requirement why and what is it functionality which it will serve because sys_dictionary will be impact on almost all the table of instance

[Snow Tomcal]

On my change request form in the back Office, I want to add a regex (string) column so I can query all the fields with regex and check them in 1 script instead of multiple onChange scripts.

[S Goutham]

@Snow Tomcal : I get your requirement I feel this would be a great idea to put up to the ServiceNow idea portal to implement it as an OOB feature I see this already built on the catalog variables.

I see your implementation will be to run a BR and query the dictionary entries of the change table to get the regex column and approriate field to validate and avoid the update or clear out the field value on before update or insert rule 

My suggestion is to have a custom property as this will only be used on the change table for now with key value pair of  { field_name : "regex_to_check"} I know this is not a tidy approach but it is better than customising a OOB table which will impact the whole instance

[Snow Tomcal]

Thanks 🙂