A field Label is not getting displayed but its present in the the database

suprakash
Giga Expert

In incident form i have a field whose column name is u_is_enhancement and column label is is_enhancement.

The column Label is not getting displayed in the form and i think for that reason i cannot find the field in the incident form ,

i have checked in form layout also its not there

But in the back ground script i checked its displaying the label

If i update the filed label its getting updated but not visible.

var gr = new GlideRecord('sys_dictionary');

gr.addQuery('element','u_is_enhancement');

gr.query();

gr.next();

gs.print(gr.column_label);

Output : *** Script: is_enhancement

Its in the the database but its not visible.

I am attaching the image

8 REPLIES 8

No its not working. is there any way out other than deleting the column and creating a new one????


I would suggest to raise a HI ticket.   Dealing with dictionaries are pretty risky


Regards
Harish

nthumma
Giga Guru

this happens in two scenarios



1) One a delete a field and create the field again with same name.


2) if you actually hit SQL limit of number columns(storage) allowed on the table.


Archi
Kilo Expert

I had the same problem.

The number of fields in the table is limited due to the limitation of the maximum length of the SQL query row to the database. Exceeding this boundary value entails hiding the labels of newly created fields (in tables where there are a large number of fields). In this case, the table needs to create another table for additional fields.

I add the required fields not to the original table, but to the table for additional fields.

Using output these fields on the form of the original table.