Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2018 05:50 PM
I am working with the background script below learning how to create a table using script. It is working great.
Re: the GlideColumnAttributes class or method, I only saw sample code that used the following:
columnAttributes.setType("string");
columnAttributes.setUsePrefix(false);
Is there a place where all the other options are documented that I can use? The main one I need is character length. But it'd be nice to know what else I can set if at all possible.
Thanks,
ER
// Create general table settings
var table_name = 'u_a_test_table_creation_by_background_script',
extends_table = 'undefined';
//Set table attributes container
var tableAttributes = new Packages.java.util.HashMap();
//Add columns via function call
addColumn('ORG_CODE');
addColumn('L2_DESC');
addColumn('L3_DESC');
addColumn('STAFF_NBR');
addColumn('POSITION_NBR');
//Create table and push in all attributes both table and column
var tableCreator = new GlideTableCreator(table_name , table_name);
tableCreator.setColumnAttributes(tableAttributes);
if(typeof extends_table != 'undefined') tableCreator.setExtends(extends_table);
tableCreator.update();
function addColumn(columnName){
var columnAttributes = new GlideColumnAttributes(columnName);
columnAttributes.setType("string");
columnAttributes.setUsePrefix(false);
tableAttributes.put(columnName, columnAttributes);
}
Solved! Go to Solution.