// the fields current value currentValue = attributes.currentValues[fqFieldName]; // the param structure which will hold all of the fields from the props dialog xparams = parameters[fieldQuery.inputID]; // overwrite the field ID to be unique xParams.fieldID = #fqFieldName#; // Set the defaults if( StructKeyExists(xParams, "forceScripts") AND (xParams.forceScripts EQ "1") ) xParams.forceScripts = true; else xParams.forceScripts = false; if( NOT StructKeyExists(xParams, "minSelections") ) xParams.minSelections = "0"; // 0 = selections are optional if( NOT StructKeyExists(xParams, "maxSelections") ) xParams.maxSelections = "0"; // 0 = infinite selections are possible if( NOT StructKeyExists(xParams, "loadAvailable") ) xParams.loadAvailable = "0"; // 0 = infinite selections are possible // find if we need to render the simple form field renderSimpleFormField = false; if ( (StructKeyExists(request, "simpleformexists")) AND (request.simpleformexists EQ 1) ) renderSimpleFormField = true; // Load the scripts application.ADF.scripts.loadJQuery(force=xParams.forceScripts); application.ADF.scripts.loadJQueryUI(force=xParams.forceScripts); application.ADF.scripts.loadADFLightbox(); application.ADF.scripts.loadCFJS(); // init Arg struct initArgs = StructNew(); initArgs.fieldName = fqFieldName; // Build the argument structure to pass into the Run Command selectionsArg = StructNew(); selectionsArg.item = currentValue; selectionsArg.queryType = "selected"; selectionsArg.csPageID = request.page.id; selectionsArg.fieldID = xParams.fieldID;

#xparams.label#:

#application.ADF.utils.runCommand(beanName=xParams.chooserCFCName, methodName="loadStyles", args=initArgs)#

#application.ADF.utils.runCommand(beanName=xParams.chooserCFCName, methodName="loadSearchBox", args=initArgs)#

#application.ADF.utils.runCommand(beanName=xParams.chooserCFCName, methodName="loadAddNewLink", args=initArgs)#

Select the records you want to include in the selections by dragging items into or out of the 'Available Items' list. Order the columns within the datasheet by dragging items within the 'Selected Items' field.

Available Items

Selected Items

// Set the query type flag before running the command selectionsArg.queryType = "notselected";

#application.ADF.utils.runCommand(beanName=xParams.chooserCFCName, methodName="getSelections", args=selectionsArg)#

// Set the query type flag before running the command selectionsArg.queryType = "selected"; #application.ADF.utils.runCommand(beanName=xParams.chooserCFCName, methodName="getSelections", args=selectionsArg)#