Hi Renu,
If I'm following this correctly, first you would create an onChange Client Script when your 'Select the file type' field changes. The script will look something like this
function onChange(control, oldValue, newValue, isLoading){
if(isLoading || newValue == ''){
return;
}
g_form.clearOptions('u_file_path');//replace with your field name
var ga = new GlideAjax('fileAuthUtils');//name of Script Include
ga.addParam('sysparm_name', 'getFilePathChoices');//name of function in SI
ga.addParam('sysparm_fileType', newValue);
ga.getXML(setFilePath);
function setFilePath(response){
var answer = JSON.parse(response.responseXML.documentElement.getAttribute("answer"));
g_form.addOption('u_file_path','',' -- None --');//replace with your field name
for(var i=0;i<answer.length;i++){
g_form.addOption('u_file_path',answer[i].value,answer[i].label);//replace with your field name
}
}
}
If you only want this to trigger when the file type changes to File Share, you can add an if block. Next, create a Script Include using the same name as in the GlideAjax call, ensuring the Client callable box is checked. Your script will look similar to this
var fileAuthUtils = Class.create();
fileAuthUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getFilePathChoices : function(){
var optionsArray = [];
var processer = new JSON();
var fa = new GlideRecord('u_file_authorizations');//replace with your custom table name
fa.addQuery('u_share_type', this.getParameter('sysparm_fileType'));//replace with correct field name
fa.query();
while(fa.next()){
optionsArray.push({
'label' : fa.u_file_path.toString(),
'value' : fa.u_file_path.toString()
});//replace with the field name(s) for your choice list Label and Value
}
return processer.encode(optionsArray);
},
type: 'fileAuthUtils'
});
This will read the custom table and return to the client a list of labels and values which meet the query criteria. The client script uses this list to add each to the drop-down. This also assumes that the choice list Value for file type matches the label ('File Share') which matches the value in the share_type field in the custom table.
