Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

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  ||  10x 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  ||  10x 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 .