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

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

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 .