Increase Table->Column Name length to 50 chars from Glide script. Default column name allowed seems to be 30 chars.

chandra mohan
Mega Contributor

Hi ,

Can you help me with code , to increase Table->Column Name size to 50 chars from Glide script. Default column name allowed seems to be 30 chars.  I have column name as 'rf1_assignment_group_prior_failure_rate' , when creating from script it truncates to 30 chars as 'rf1_asgmnt_grp_r_failure_rate'. 

 

var attrs = new Packages.java.util.HashMap();

var column_name="rf1_assignment_group_prior_failure_rate";

var column_attributes = new GlideColumnAttributes(column_name);
column_attributes.setType(string);
column_attributes.setUsePrefix(false);
attrs.put(column_name, column_attributes);
var table_create = new GlideTableCreator("abc", table_name);
table_create.setColumnAttributes(attrs);
table_create.update();

Thanks,

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Mohan,

if you are referring to the below screenshot then it has 80 as max length;

find_real_file.png

Are you referring same or something else? Also share screenshot?

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Ankur, 

 

Thanks for your response. I am running a script to create the column name. but, it truncates to 30 characters. 

for e.g , from above script ,  column name is created as shown in screenshot. (it's truncated to 30 characters) 

var column_name="rf1_assignment_group_prior_failure_rate";

 

find_real_file.png

Thanks ! 

 

Hi Mohan,

but in my case the column name has length as 80; what's the max length for it in your instance?

 

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

chandra mohan
Mega Contributor

Hi Ankur, 

Below is the screenshot for my column name. It seems max length is 80, and manually I can create column name with 80 characters. But, using script it truncates to 30 characters. [ display name is created with 40 characters from the script ] 

 

Thanks, 

Chandra Mohan .