Can we increase the field length of a reference qual field in sys_dictionary table to 2000 ? Will it have any negative impact ?

[sandhya0682]

@

Hi All,

Currently we have the below reference qualifier defined for the Config Item field in Incident form. We need to add 5 more conditions as part of a new requirement and we are unable to do so because when we add more conditions and save, the changes are not getting saved.

We figured out that this could be because of the field length of the Reference Qualifier condition field in the Sys Dictionary table. However, when we tried increasing the Reference Qualifier condition field length to 1000 the changes are not getting saved in our instance. However the same solution works in personal developer instance. Should we not modify the field length of any field in sys_dictionary table ?

Will the HI portal team be able to help ? Any other suggestions /workaround for the above problem

[snehabinani26]

Hi Sandhya,

You can increase the field length, it would have any impact. But do remember once the length is increased, it cannot be decreased again.

Moreover why are you not using Class is one of condition instead of so many ors.

[Neeraj Sharma10]

Hi,

I think 'Class is one of condition' is not present   in serviceNow

I can be wrong.

Thanks and Regards

Neeraj Sharma

[Neeraj Sharma10]

Hi Sandhya Radhakrishnan

I faced a similar issue, So instead of trying to increase the limit of reference qualifier,   i come with a workaround that is

1>   Make customized check box in configuration item table

And In reference qualifier the condition is

Hope this will your problem, works well for me

Thanks And Regards

Neeraj Sharma

[liv_cp]

Hi Sandhya,

I know you've had responses already but thought I'd add another idea - whenever I find that my condition is too long for the field, I select 'Advanced' for the reference qualifier then put the condition into a script include that returns a list of sys ids of records and call the script include from the ref qualifier field.

That way, you can have as many conditions as you need in the script include but you only have to put 'javascript: new MyScriptInclude().myFunction()' into the reference qualifier field...

I've included a very simple example below where the script include returns all active groups but of course, the script include can contain as many conditions as required (within reason)!

Hope this helps,

Liv