// Path to this CFT variables.cftPath = "/ADF/extensions/customfields/custom_element_datamanager"; var renderData = ''; #renderData# var renderData = ''; var inputPropStruct = arguments.propertiesStruct; var passthroughParamsStr = ""; var aParams = ""; var i = 0; if (structKeyExists(arguments.propertiesStruct, "passthroughParams") && arguments.propertiesStruct.passthroughParams != "") { aParams = listToArray(arguments.propertiesStruct.passthroughParams); for (i = 1; i <= arrayLen(aParams); i++) { if (structKeyExists(request.params, aParams[i])) passthroughParamsStr = "#passthroughParamsStr#&#aParams[i]#=#URLEncodedFormat(request.params[aParams[i]])#"; } } #renderAddExistingButton(argumentCollection=arguments, passthroughParamsStr=passthroughParamsStr)# #renderAddNewButton(argumentCollection=arguments, passthroughParamsStr=passthroughParamsStr)# #renderDeleteSelectedButton(argumentCollection=arguments)# #renderData# var renderData = ''; var inputPropStruct = arguments.propertiesStruct; var curValuesStruct = arguments.currentValues; var assocParameters = 'csAssoc_assocCE=#propertiesStruct.assocCustomElement#&csAssoc_ParentInstanceIDField=#propertiesStruct.parentInstanceIDField#&csAssoc_ChildInstanceIDField=#propertiesStruct.childInstanceIDField#&csAssoc_ChildUniqueField=#propertiesStruct.childUniqueField#'; var parentInstanceIDVal = 0; var linkedFieldName = ''; var extraParams = arguments.passthroughParamsStr; if (arguments.parentFormType EQ 'MetadataForm' AND inputPropStruct.parentUniqueField EQ '{{pageid}}') parentInstanceIDVal = arguments.pageID; else linkedFieldName = 'fic_#arguments.formID#_#inputPropStruct.parentUniqueField#'; if (linkedFieldName EQ '') { assocParameters = ListAppend(assocParameters, 'csAssoc_ParentInstanceID=#parentInstanceIDVal#', '&'); extraParams = '#extraParams#&linkedFieldValue=#parentInstanceIDVal#'; } assocParameters = ListAppend(assocParameters, 'csAssoc_ChildInstanceID=', '&'); #Server.CommonSpot.UDF.tag.input(type="button", class="clsPushButton", name="addNew", id="addNew", value=getAddNewButtonName(propertiesStruct=arguments.propertiesStruct), onclick="javascript:setCurrentValueAndOpenURL_#arguments.fieldID#('#Request.SubSite.DlgLoader#?csModule=controls/custom/submit-data&controlTypeID=#propertiesStruct.childCustomElement#&formID=#propertiesStruct.childCustomElement#&newData=1&dataPageID=0&dataControlID=0&linkageFieldID=#propertiesStruct.childLinkedField#&openFrom=datamanager&callbackFunction=loadData_#arguments.fieldID#&#assocParameters##extraParams#', '#linkedFieldName#', 'addnew')")# #renderData# var buttonLabel = 'Add New...'; var ceName = ""; var elementType = 'CustomElement'; if (StructKeyExists(arguments.propertiesStruct,"newOptionText") AND Len(arguments.propertiesStruct['newOptionText'])) { buttonLabel = arguments.propertiesStruct['newOptionText']; } else { if ( StructKeyExists(arguments.propertiesStruct,"childCustomElement") AND IsNumeric(arguments.propertiesStruct.childCustomElement) ) { if ( StructKeyExists(arguments.propertiesStruct,"assocCustomElement") AND IsNumeric(arguments.propertiesStruct.assocCustomElement) ) elementType = arguments.propertiesStruct.secondaryElementType; ceName = getCEName(elementID=arguments.propertiesStruct.childCustomElement,elementType=elementType); if ( LEN(TRIM(ceName)) ) buttonLabel = "Add New #ceName#..."; } } if (Right(buttonLabel,3) NEQ '...') buttonLabel = buttonLabel & '...'; return buttonLabel; var renderData = ''; var inputPropStruct = arguments.propertiesStruct; var curValuesStruct = arguments.currentValues; var parentInstanceIDVal = 0; var linkedFieldName = ''; var extraParams = arguments.passthroughParamsStr; if (arguments.parentFormType EQ 'MetadataForm' AND inputPropStruct.parentUniqueField EQ '{{pageid}}') parentInstanceIDVal = arguments.pageID; else linkedFieldName = 'fic_#arguments.formID#_#inputPropStruct.parentUniqueField#'; if (linkedFieldName EQ '') { extraParams = '#extraParams#&linkedFieldValue=#parentInstanceIDVal#'; } #Server.CommonSpot.UDF.tag.input(type="button", class="clsPushButton", name="addExisting", id="addExisting", value=getAddExistingButtonName(propertiesStruct=arguments.propertiesStruct), onclick="javascript:setCurrentValueAndOpenURL_#arguments.fieldID#('#Request.SubSite.DlgLoader#?csModule=controls/custom/submit-data&controlTypeID=#inputPropStruct.assocCustomElement#&formID=#inputPropStruct.assocCustomElement#&newData=1&dataPageID=0&dataControlID=0&linkageFieldID=#inputPropStruct.parentInstanceIDField#&openFrom=datamanager&callbackFunction=loadData_#arguments.fieldID##extraParams#', '#linkedFieldName#', 'addexisting')")# #renderData# var renderData = '';

Select All | Deselect All #Server.CommonSpot.UDF.tag.input( type="button", class="clsPushButton", name="deleteSelected", id="deleteSelected", value=getDeleteSelectedButtonName(propertiesStruct=arguments.propertiesStruct), onclick="doDeleteSelected_#arguments.fieldID#('Are you sure you want to delete the selected records? Note this action will permanently delete the records.', 'Please select one or more records to delete.');")#

#renderData# var buttonLabel = 'Add Existing...'; var ceName = ""; if (StructKeyExists(arguments.propertiesStruct,"existingOptionText") AND Len(arguments.propertiesStruct['existingOptionText'])) { buttonLabel = arguments.propertiesStruct['existingOptionText']; } else { if ( StructKeyExists(arguments.propertiesStruct,"assocCustomElement") AND IsNumeric(arguments.propertiesStruct.assocCustomElement) ) { ceName = getCEName(elementID=arguments.propertiesStruct.assocCustomElement,elementType='CustomElement'); if ( LEN(TRIM(ceName)) ) buttonLabel = "Add New #ceName#..."; } } if (Right(buttonLabel,3) NEQ '...') buttonLabel = buttonLabel & '...'; return buttonLabel; var buttonLabel = 'Delete Selected'; return buttonLabel; var inputPropStruct = arguments.propertiesStruct; var defaultSortColumn = ''; var defaultSortOrder = ''; var resultData = QueryNew(''); var parentObj = Server.CommonSpot.ObjectFactory.getObject(arguments.parentFormType); var childObj = ''; var colList = inputPropStruct.displayFields; var colArray = ArrayNew(1); var childFormFields = QueryNew(''); var fldName = ""; var allChildColList = ""; var allChildColNameList = ''; var childFormFieldsStruct = StructNew(); var childOrderColumnName = ""; var valueFieldName = ""; var assocFormFields = ""; var allAssocColList = ""; var allAssocColNameList = ''; var i = 0; var childColNameList = ''; var assocColNameList = ''; var assocFormFieldsStruct = StructNew(); var assocOrderColumnName = ""; var displayColNames = ""; var assocDisplayColNames = ''; var childDisplayColNames = ''; var statementsArray = ArrayNew(1); var childFilterExpression = ''; var assocFieldDetail = QueryNew(''); var assocReqFieldName = ''; var assocFilterExpression = ''; var assocStatementsArray = ArrayNew(1); var assocFilterArray = ArrayNew(1); var assocData = QueryNew('PageID'); var assocColumnList = ''; var childFilterArray = ArrayNew(1); var filteredData = ''; var childColumnList = ''; var returnStruct = StructNew(); var assocFormFieldsDetailedStruct = StructNew(); var childFormFieldsDetailedStruct = StructNew(); var formFieldsStruct = StructNew(); var returnData = QueryNew(''); var data = ''; var childColPos = 0; var assocColPos = 0; var displayColsArray = ArrayNew(1); var uniqueList = ''; var simpleValuesArray = ArrayNew(1); var j = 0; var parentInstanceIDVal = arguments.parentInstanceValue; var compareValueWithChild = ''; var ceObj = ''; var eData = StructNew(); var sessionUUID = ''; var sessionStruct = StructNew(); var cmdArgs = StructNew(); var nextIndex = 0; var csVersion = ListFirst(ListLast(request.cp.productversion," "),"."); var k = 0; var valuesWithCommaArray = ArrayNew(1); var stmtNewPos = 0; var operatorToUseStr = 'Equals'; var operatorToUseSymbol = '='; if( NOT StructKeyExists(inputPropStruct,'secondaryElementType') ) inputPropStruct.secondaryElementType = 'CustomElement'; childObj = Server.CommonSpot.ObjectFactory.getObject(inputPropStruct.secondaryElementType); if (arguments.parentFormType EQ 'CustomElement') ceObj = parentObj; else if (inputPropStruct.secondaryElementType EQ 'CustomElement') ceObj = childObj; else ceObj = Server.CommonSpot.ObjectFactory.getObject("CustomElement"); if(IsNumeric(inputPropStruct.assocCustomElement)) linkedFldDetails = ceObj.getFields(elementID=inputPropStruct.assocCustomElement,fieldID=inputPropStruct.parentInstanceIDField); else { if (inputPropStruct.secondaryElementType EQ 'CustomElement') linkedFldDetails = childObj.getFields(elementID=inputPropStruct.childCustomElement,fieldID=inputPropStruct.childLinkedField); else linkedFldDetails = childObj.getFields(formID=inputPropStruct.childCustomElement,fieldID=inputPropStruct.childLinkedField); } if (linkedFldDetails.type NEQ 'img') { compareValueWithChild = getLinkedFieldValue(fieldType=linkedFldDetails.type,fieldValue=parentInstanceIDVal); if (linkedFldDetails.type EQ 'csextendedurl') { operatorToUseStr = 'Contains'; operatorToUseSymbol = 'like'; } } else compareValueWithChild = parentInstanceIDVal; if (inputPropStruct.sortByType EQ 'auto') { defaultSortColumn = inputPropStruct.sortByField; defaultSortOrder = inputPropStruct.sortByDir; } else if (inputPropStruct.sortByType EQ 'manual') { defaultSortColumn = inputPropStruct.positionField; defaultSortOrder = "ASC"; } if(Len(inputPropStruct.displayFields)) { if (NOT ListFindNoCase(colList, defaultSortColumn)) colList = ListAppend(colList, defaultSortColumn); if (NOT ListFindNoCase(colList, inputPropStruct.childUniqueField)) colList = ListAppend(colList, inputPropStruct.childUniqueField); } colArray = ListToArray(colList); if (inputPropStruct.secondaryElementType EQ 'CustomElement') childFormFields = childObj.getFields(elementid=inputPropStruct.childCustomElement); else childFormFields = childObj.getFields(formID=inputPropStruct.childCustomElement); fldName = childFormFields.Name; if (FindNoCase("FIC_", fldName) eq 1) fldName = Mid(fldName, 5, 999); if (NOT ListFindNoCase(allChildColList, childFormFields.ID)) allChildColList = ListAppend(allChildColList, childFormFields.ID); if (NOT ListFindNoCase(allChildColNameList, fldName)) allChildColNameList = ListAppend(allChildColNameList, fldName); childFormFieldsStruct[childFormFields.ID] = fldName; childFormFieldsDetailedStruct[fldName] = StructNew(); childFormFieldsDetailedStruct[fldName]['FormID'] = inputPropStruct.childCustomElement; childFormFieldsDetailedStruct[fldName]['FieldID'] = childFormFields.ID; childFormFieldsDetailedStruct[fldName]['FieldType'] = childFormFields.Type; childFormFieldsDetailedStruct[fldName]['FieldLabel'] = childFormFields.Label; if ( StructKeyExists(childFormFields,"Label") AND LEN(TRIM(childFormFields.Label)) ) childFormFieldsDetailedStruct[fldName]['FieldLabel'] = childFormFields.Label; else childFormFieldsDetailedStruct[fldName]['FieldLabel'] = childFormFields.Name; if (defaultSortColumn EQ childFormFields.ID) childOrderColumnName = fldName; if (inputPropStruct.childUniqueField EQ childFormFields.ID) valueFieldName = fldName; fldName = assocFormFields.Name; if (FindNoCase("FIC_", fldName) eq 1) fldName = Mid(fldName, 5, 999); if (NOT ListFindNoCase(allAssocColList, assocFormFields.ID)) allAssocColList = ListAppend(allAssocColList, assocFormFields.ID); if (NOT ListFindNoCase(allAssocColNameList, fldName)) allAssocColNameList = ListAppend(allAssocColNameList, fldName); assocFormFieldsStruct[assocFormFields.ID] = fldName; assocFormFieldsDetailedStruct[fldName] = StructNew(); assocFormFieldsDetailedStruct[fldName]['FormID'] = inputPropStruct.assocCustomElement; assocFormFieldsDetailedStruct[fldName]['FieldID'] = assocFormFields.ID; assocFormFieldsDetailedStruct[fldName]['FieldType'] = assocFormFields.Type; if ( StructKeyExists(assocFormFields,"Label") AND LEN(TRIM(assocFormFields.Label)) ) assocFormFieldsDetailedStruct[fldName]['FieldLabel'] = assocFormFields.Label; else assocFormFieldsDetailedStruct[fldName]['FieldLabel'] = assocFormFields.Name; if (defaultSortColumn EQ assocFormFields.ID) assocOrderColumnName = fldName; if (ArrayLen(colArray)) { for (i = 1; i lte ArrayLen(colArray); i = i + 1) { if (ListFindNoCase(allChildColList, colArray[i])) { childColNameList = ListAppend(childColNameList, childFormFieldsStruct[colArray[i]]); if (ListFindNoCase(inputPropStruct.displayFields, colArray[i])) { if (ListFindNoCase(assocDisplayColNames, childFormFieldsStruct[colArray[i]])) { displayColNames = ListAppend(displayColNames, '#childFormFieldsStruct[colArray[i]]#_child'); childDisplayColNames = ListAppend(childDisplayColNames, '#childFormFieldsStruct[colArray[i]]#_child'); formFieldsStruct['#childFormFieldsStruct[colArray[i]]#_child'] = childFormFieldsDetailedStruct[childFormFieldsStruct[colArray[i]]]; childColPos = ListFindNoCase(displayColNames, childFormFieldsStruct[colArray[i]]); displayColNames = ListSetAt(displayColNames, childColPos, '#childFormFieldsStruct[colArray[i]]#_assoc'); assocColPos = ListFindNoCase(assocDisplayColNames, childFormFieldsStruct[colArray[i]]); assocDisplayColNames = ListSetAt(assocDisplayColNames, assocColPos, '#childFormFieldsStruct[colArray[i]]#_assoc'); formFieldsStruct['#childFormFieldsStruct[colArray[i]]#_assoc'] = formFieldsStruct['#childFormFieldsStruct[colArray[i]]#']; StructDelete(formFieldsStruct, childFormFieldsStruct[colArray[i]]); } else { displayColNames = ListAppend(displayColNames, childFormFieldsStruct[colArray[i]]); childDisplayColNames = ListAppend(childDisplayColNames, childFormFieldsStruct[colArray[i]]); formFieldsStruct[childFormFieldsStruct[colArray[i]]] = childFormFieldsDetailedStruct[childFormFieldsStruct[colArray[i]]]; } } } if (ListFindNoCase(allAssocColList, colArray[i])) { assocColNameList = ListAppend(assocColNameList, assocFormFieldsStruct[colArray[i]]); if (ListFindNoCase(inputPropStruct.displayFields, colArray[i])) { if (ListFindNoCase(childDisplayColNames, assocFormFieldsStruct[colArray[i]])) { displayColNames = ListAppend(displayColNames, '#assocFormFieldsStruct[colArray[i]]#_assoc'); assocDisplayColNames = ListAppend(assocDisplayColNames, '#assocFormFieldsStruct[colArray[i]]#_assoc'); formFieldsStruct['#assocFormFieldsStruct[colArray[i]]#_assoc'] = assocFormFieldsDetailedStruct[assocFormFieldsStruct[colArray[i]]]; assocColPos = ListFindNoCase(displayColNames, assocFormFieldsStruct[colArray[i]]); displayColNames = ListSetAt(displayColNames, assocColPos, '#assocFormFieldsStruct[colArray[i]]#_child'); childColPos = ListFindNoCase(childDisplayColNames, assocFormFieldsStruct[colArray[i]]); childDisplayColNames = ListSetAt(childDisplayColNames, childColPos, '#assocFormFieldsStruct[colArray[i]]#_child'); formFieldsStruct['#assocFormFieldsStruct[colArray[i]]#_child'] = formFieldsStruct['#assocFormFieldsStruct[colArray[i]]#']; StructDelete(formFieldsStruct, assocFormFieldsStruct[colArray[i]]); } else { displayColNames = ListAppend(displayColNames, assocFormFieldsStruct[colArray[i]]); assocDisplayColNames = ListAppend(assocDisplayColNames, assocFormFieldsStruct[colArray[i]]); formFieldsStruct[assocFormFieldsStruct[colArray[i]]] = assocFormFieldsDetailedStruct[assocFormFieldsStruct[colArray[i]]]; } } } } } returnData = QueryNew('AssocDataPageID,ChildDataPageID,#displayColNames#'); if(NOT IsNumeric(inputPropStruct.assocCustomElement)) { if( inputPropStruct.secondaryElementType EQ 'MetadataForm' ) { if (ListLen(compareValueWithChild,'||') GT 1) { if (csVersion GT 9) { statementsArray[1] = childObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childLinkedField,operator=operatorToUseStr,value=ListFirst(compareValueWithChild,'||')); statementsArray[2] = childObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childLinkedField,operator=operatorToUseStr,value=ListLast(compareValueWithChild,'||')); } else { statementsArray[1] = "metadata|#inputPropStruct.childCustomElement#_#inputPropStruct.childLinkedField#|#operatorToUseSymbol#|#ListFirst(compareValueWithChild,'||')#"; // Have to construct directly as metadataform has no command to create standard statement statementsArray[2] = "metadata|#inputPropStruct.childCustomElement#_#inputPropStruct.childLinkedField#|#operatorToUseSymbol#|#ListLast(compareValueWithChild,'||')#"; } childFilterExpression = '(1 OR 2)'; } else { if (csVersion GT 9) { statementsArray[1] = childObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childLinkedField,operator=operatorToUseStr,value=compareValueWithChild); } else { statementsArray[1] = "metadata|#inputPropStruct.childCustomElement#_#inputPropStruct.childLinkedField#|#operatorToUseSymbol#|#compareValueWithChild#"; // Have to construct directly as metadataform has no command to create standard statement } childFilterExpression = '1'; } } else { if (ListLen(compareValueWithChild,'||') GT 1) { statementsArray[1] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childLinkedField,operator=operatorToUseStr,value=ListFirst(compareValueWithChild,'||')); statementsArray[2] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childLinkedField,operator=operatorToUseStr,value=ListLast(compareValueWithChild,'||')); childFilterExpression = '(1 OR 2)'; } else { statementsArray[1] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childLinkedField,operator=operatorToUseStr,value=compareValueWithChild); childFilterExpression = '1'; } } if(Len(inputPropStruct.inactiveField) AND Len(inputPropStruct.inactiveFieldValue)) { nextIndex = ArrayLen(statementsArray)+1; if( inputPropStruct.secondaryElementType EQ 'MetadataForm' ) { if (csVersion GT 9) { statementsArray[nextIndex] = childObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.inactiveField,operator='Not Equal',value=inputPropStruct.inactiveFieldValue); } else { statementsArray[nextIndex] = "metadata|#inputPropStruct.childCustomElement#_#inputPropStruct.inactiveField#|<>|#inputPropStruct.inactiveFieldValue#"; // Have to construct directly as metadataform has no command to create standard statement } } else statementsArray[nextIndex] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.inactiveField,operator='Not Equal',value=inputPropStruct.inactiveFieldValue); childFilterExpression = '#childFilterExpression# AND #nextIndex#'; } else childFilterExpression = '#childFilterExpression#'; } else { assocFieldDetail = ceObj.getFields(elementID=inputPropStruct.assocCustomElement,fieldID=inputPropStruct.childInstanceIDField); assocReqFieldName = assocFieldDetail.Name; if (FindNoCase("FIC_", assocReqFieldName) eq 1) assocReqFieldName = Mid(assocReqFieldName, 5, 999); assocStatementsArray[1] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.assocCustomElement,fieldIDorName=inputPropStruct.parentInstanceIDField,operator='Equals',value=compareValueWithChild); if(Len(inputPropStruct.inactiveField) AND Len(inputPropStruct.inactiveFieldValue)) { assocStatementsArray[2] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.assocCustomElement,fieldIDorName=inputPropStruct.inactiveField,operator='Not Equal',value=inputPropStruct.inactiveFieldValue); assocFilterExpression = '1 AND 2'; } else assocFilterExpression = '1'; assocFilterArray = ceObj.createQueryEngineFilter(filterStatementArray=assocStatementsArray,filterExpression=assocFilterExpression); if(linkedFldDetails.type EQ 'img') { compareValueWithChild = getLinkedFieldValue(fieldType=linkedFldDetails.type,fieldValue=parentInstanceIDVal); assocFilterArray[1] = ReplaceNoCase(assocFilterArray[1], '| | #parentInstanceIDVal#|', '| | #compareValueWithChild#|'); } if (Len(assocColNameList)) assocColumnList = '#assocReqFieldName#,#assocColNameList#'; else assocColumnList = assocReqFieldName; data = ceObj.getRecordsFromSavedFilter(elementID=inputPropStruct.assocCustomElement,queryEngineFilter=assocFilterArray,columnList=assocColumnList,orderBy=assocReqFieldName, orderByDirection="ASC", limit=0); assocData = data.resultQuery; if (assocData.RecordCount) { assocColumnList = assocData.columnList; ids = assocData[assocReqFieldName]; // build list of values simpleValuesArray = ArrayNew(1); valuesWithCommaArray = ArrayNew(1); for( j=1; j lte assocData.recordCount; j = j+1 ) { if ( ArrayFindNoCase(simpleValuesArray, assocData[assocReqFieldName][j]) EQ 0 AND ArrayFindNoCase(valuesWithCommaArray, assocData[assocReqFieldName][j]) EQ 0 ) { if (ListLen(assocData[assocReqFieldName][j]) GT 1) ArrayAppend( valuesWithCommaArray, assocData[assocReqFieldName][j] ); else ArrayAppend( simpleValuesArray, assocData[assocReqFieldName][j] ); } } uniqueList = ArrayToList( simpleValuesArray ); if ( ListLen(uniqueList) ) { if( inputPropStruct.secondaryElementType EQ 'MetadataForm' ) { if (csVersion GT 9) { statementsArray[1] = childObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childUniqueField,operator='Value Contained In List',value=uniqueList); } else { statementsArray[1] = "metadata|#inputPropStruct.childCustomElement#_#inputPropStruct.childUniqueField#|inlist|#uniqueList#"; } } else statementsArray[1] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childUniqueField,operator='Value Contained In List',value=uniqueList); childFilterExpression = '1'; } if ( ArrayLen(valuesWithCommaArray) ) { for ( k=1; k LTE ArrayLen(valuesWithCommaArray);k=k+1 ) { stmtNewPos = ArrayLen(statementsArray) + 1; if( inputPropStruct.secondaryElementType EQ 'MetadataForm' ) { if (csVersion GT 9) { statementsArray[stmtNewPos] = childObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childUniqueField,operator='Equals',value=valuesWithCommaArray[k]); } else { statementsArray[stmtNewPos] = "metadata|#inputPropStruct.childCustomElement#_#inputPropStruct.childUniqueField#|=|#valuesWithCommaArray[k]#"; } } else statementsArray[stmtNewPos] = ceObj.createStandardFilterStatement(customElementID=inputPropStruct.childCustomElement,fieldIDorName=inputPropStruct.childUniqueField,operator='Equals',value=valuesWithCommaArray[k]); if ( Len(childFilterExpression) ) { childFilterExpression = '#childFilterExpression# OR '; } childFilterExpression = '#childFilterExpression##Int(stmtNewPos)#'; } } } } childFilterArray = ceObj.createQueryEngineFilter(filterStatementArray=statementsArray,filterExpression=childFilterExpression); if(NOT IsNumeric(inputPropStruct.assocCustomElement) AND linkedFldDetails.type EQ 'img') { compareValueWithChild = getLinkedFieldValue(fieldType=linkedFldDetails.type,fieldValue=parentInstanceIDVal); childFilterArray[1] = ReplaceNoCase(childFilterArray[1], '| | #parentInstanceIDVal#|', '| | #compareValueWithChild#|'); } childColumnList = '#childColNameList#,#valueFieldName#'; data = ceObj.getRecordsFromSavedFilter(elementID=inputPropStruct.childCustomElement,queryEngineFilter=childFilterArray,columnList=childColumnList, limit=0, currentOnly=0); eData.filtertype = 1; eData.serSrchArray = childFilterArray; sessionUUID = "op|#inputPropStruct.childCustomElement#|#inputPropStruct.childUniqueField#" & "_" & inputPropStruct.childUniqueField & "_" & inputPropStruct.childCustomElement & "_" & Request.User.ID; sessionStruct.filter = eData; sessionStruct.controlTypeID = inputPropStruct.childCustomElement; sessionStruct.defaultSortColumn = "#valueFieldName#|ASC"; cmdArgs.columnList = "#childColumnList#"; cmdArgs.filterID = sessionUUID; cmdArgs.id = inputPropStruct.childCustomElement; data = childObj.getRecordsFromFilter(argumentCollection=cmdArgs); filteredData = data.resultQuery; displayColsArray = ListToArray(displayColNames); SELECT assocData.PageID AS AssocDataPageID, assocData.ControlID AS AssocDataControlID, 0 AS AssocDataPageID, 0 AS AssocDataControlID, filteredData.PageID AS ChildDataPageID, filteredData.ControlID AS ChildDataControlID , filteredData.[#displayColsArray[i]#] filteredData.[#Mid(displayColsArray[i],1,Len(displayColsArray[i])-6)#] AS #displayColsArray[i]# assocData.[#displayColsArray[i]#] assocData.[#Mid(displayColsArray[i],1,Len(displayColsArray[i])-6)#] AS #displayColsArray[i]# , FROM filteredData ,assocData WHERE filteredData.[#valueFieldName#] = assocData.[#assocReqFieldName#] ORDER BY filteredData.[#childOrderColumnName#] #defaultSortOrder# ORDER BY assocData.[#assocOrderColumnName#] #defaultSortOrder# returnStruct['qry'] = returnData; returnStruct['fieldMapStruct'] = formFieldsStruct; returnStruct['fieldOrderList'] = '#displayColNames#'; returnStruct['errorMsg'] = "Error occurred while trying to retrieve data for the child element."; var inputPropStruct = arguments.propertiesStruct; var returnData = QueryNew(''); var childData = arguments.dataRecords; var dataColumnList = ListPrepend(arguments.fieldOrderList,'AssocDataPageID,ChildDataPageID'); var actionColumnArray = ArrayNew(1); var renderData = ''; var mappingStruct = arguments.fieldMapStruct; var dataColumnArray = ArrayNew(1); var i = 0; var formFieldType = ''; var formFieldID = 0; var formFieldValue = ''; var formFieldLabel = ''; var returnStruct = StructNew(); var convertedCols = StructNew(); var converted = 0; var convertedColumnList = ''; var pos = 0; var str = ''; var col = ''; var fieldUpdValue = ''; var dataColumnList_new = ''; var theListLen = 0; var actionColumnWidth = 0; var formattedDataColumnList = ''; var displayColumnList = ''; var dCols = ''; var dColName = ''; dataColumnArray = ListToArray(dataColumnList); // this will output the content actionColumnWidth = renderActionColumns( fieldID=arguments.fieldID, propertiesStruct=inputPropStruct, assocDataPageID=childData.AssocDataPageID, assocDataControlID=ChildData.AssocDataControlID, childDataPageID=childData.ChildDataPageID, childDataControlID=ChildData.ChildDataControlID); actionColumnArray[childData.currentRow] = renderData; for(i=1;i LTE ArrayLen(dataColumnArray);i=i+1) { col = dataColumnArray[i]; if (StructKeyExists(mappingStruct, dataColumnArray[i])) { formFieldType = mappingStruct[dataColumnArray[i]].fieldType; formFieldID = mappingStruct[dataColumnArray[i]].fieldID; formFieldLabel = mappingStruct[dataColumnArray[i]].fieldLabel; formFieldValue = childData[dataColumnArray[i]]; switch (formFieldType) { case 'Custom Element Select': case 'Custom Element Select Field': case 'CustomElementSelect': case 'CustomElement Select': case 'CE Select': if( len(formFieldValue) ) fieldUpdValue = getContent_ceSelect(fieldID=formFieldID,fieldValue='#formFieldValue#'); else fieldUpdValue = ''; if( NOT StructKeyExists(convertedCols, col) ) { QueryAddColumn(childData, '#col#_converted', 'varchar', ArrayNew(1) ); convertedCols[col] = StructNew(); } QuerySetCell(childData, '#col#_converted', fieldUpdValue, childData.CurrentRow); break; case 'select': if( len(formFieldValue) ) fieldUpdValue = getContent_select(fieldID=formFieldID,fieldValue='#formFieldValue#'); else fieldUpdValue = ''; if( NOT StructKeyExists(convertedCols, col) ) { QueryAddColumn(childData, '#col#_converted', 'varchar', ArrayNew(1) ); convertedCols[col] = StructNew(); } QuerySetCell(childData, '#col#_converted', fieldUpdValue, childData.CurrentRow); break; case 'csextendedurl': case 'cs_url': fieldUpdValue = getContent_csurl(fieldID=formFieldID,fieldValue='#formFieldValue#'); QuerySetCell(childData, col, fieldUpdValue, childData.CurrentRow); break; default: fieldUpdValue = getContent_genericCFT(fieldID=formFieldID,fieldType=formFieldType,fieldValue=formFieldValue); QuerySetCell(childData, col, fieldUpdValue, childData.CurrentRow); break; } /* try { QuerySetCell(childData, dataColumnArray[i], fieldUpdValue, childData.CurrentRow); } catch (any e) { // QuerySetCell(childData, dataColumnArray[i], '', childData.CurrentRow); logit('Error updating column:[#dataColumnArray[i]#] Row:[#childData.CurrentRow#] formFieldType:[#formFieldType#] fieldUpdValue:[#fieldUpdValue#] Message:[#e.message#] detail:[#e.detail#]'); } */ } } dataColumnList_new = dataColumnList; if (childData.RecordCount) { convertedColumnList = StructKeyList( convertedCols ); theListLen = ListLen(convertedColumnList); for( i=1; i lte theListLen; i=i+1 ) { str = ListGetAt( convertedColumnList, i ); pos = ListFindNoCase( dataColumnList, str ); if( pos ) dataColumnList_new = ListSetAt( dataColumnList_new, pos, str & '_converted' ); } QueryAddColumn(childData, 'Actions', 'varchar', actionColumnArray); } else { QueryAddColumn(childData, 'Actions', actionColumnArray); } dataColumnList_new = ListPrepend(dataColumnList_new, 'Actions'); // Logit('datacolumnlist:[#dataColumnList_new#]'); // Actions,AssocDataPageID,ChildDataPageID,ID,Name,ParentID dataColumnArray = ListToArray(dataColumnList_new); for(i=1;i LTE ArrayLen(dataColumnArray);i=i+1) formattedDataColumnList = ListAppend(formattedDataColumnList, '[' & Trim(dataColumnArray[i]) & ']'); SELECT #formattedDataColumnList# FROM childData // Build the displayColumnList using the Field Labels for the Column Headers displayColumnList = dataColumnList_new; displayColumnList = ReplaceNoCase(dataColumnList_new,'_converted','','ALL'); for ( dCol=1; dCol LTE ListLen(displayColumnList); dCol=dCol+1 ){ dColName = ListGetAt(displayColumnList,dCol); if ( StructKeyExists(mappingStruct,dColName) ) displayColumnList = ListSetAt(displayColumnList,dCol,mappingStruct[dColName].fieldLabel); } returnStruct['actionColumnWidth'] = '#actionColumnWidth#'; returnStruct['aoColumns'] = '#displayColumnList#'; // TODO: Remove - Use the code above to get the Field Labels for the Column Headers //returnStruct['aoColumns'] = '#dataColumnList_new#'; //returnStruct['aoColumns'] = '#ReplaceNoCase(dataColumnList_new,'_converted','','ALL')#'; returnStruct['aaData'] = QueryToArray(queryData=returnData, fieldOrderList=dataColumnList_new); returnData = QueryNew('ErrorMsg'); QueryAddRow(returnData, 1); QuerySetCell(returnData, 'ErrorMsg', "Error occurred while trying to retrieve data for the child element."); returnStruct['aoColumns'] = 'ErrorMsg'; returnStruct['aaData'] = QueryToArray(queryData=returnData,fieldOrderList='ErrorMsg'); var inputPropStruct = arguments.propertiesStruct; var renderData = ''; var actionColumnWidth = '';

#renderEditAssocIcon(propertiesStruct=arguments.propertiesStruct,dataPageID=arguments.assocDataPageID,dataControlID=arguments.assocDataControlID,fieldID=arguments.fieldID)# #renderEditChildIcon(propertiesStruct=arguments.propertiesStruct,dataPageID=arguments.childDataPageID,dataControlID=arguments.childDataControlID,fieldID=arguments.fieldID)# #renderDeleteIcon(propertiesStruct=arguments.propertiesStruct,assocDataPageID=arguments.assocDataPageID,childDataPageID=arguments.childDataPageID,fieldID=arguments.fieldID)#

#renderData# var inputPropStruct = arguments.propertiesStruct; var renderData = ''; var qryString = ''; var altText = "Edit Association Element '#Request.Site.availcontrols[inputPropStruct.assocCustomElement].shortdesc#'"; if (StructKeyExists(arguments.propertiesStruct,"editAssocOptionText") AND Len(arguments.propertiesStruct['editAssocOptionText'])) altText = arguments.propertiesStruct['editAssocOptionText']; qryString = 'formID=#inputPropStruct.assocCustomElement#&linkageFieldID=#inputPropStruct.parentInstanceIDField#'; #altText#

#renderData# var inputPropStruct = arguments.propertiesStruct; var renderData = ''; var qryString = ''; var needMFFormName = 0; var altText = ""; var formDetails = QueryNew(''); var mfObj = Server.CommonSpot.ObjectFactory.getObject('MetadataForm'); if( NOT StructKeyExists(inputPropStruct,'secondaryElementType') ) inputPropStruct.secondaryElementType = 'CustomElement'; if( StructKeyExists(inputPropStruct,"editChildOptionText") AND Len(inputPropStruct['editChildOptionText']) ) altText = inputPropStruct['editChildOptionText']; else { if( IsNumeric(inputPropStruct.assocCustomElement) ) { if( inputPropStruct.secondaryElementType EQ 'MetadataForm' ) needMFFormName = 1; else altText = "Edit Child Element '#Request.Site.availcontrols[inputPropStruct.childCustomElement].shortdesc#'"; } else altText = "Edit Child Element '#Request.Site.availcontrols[inputPropStruct.childCustomElement].shortdesc#'"; } if( needMFFormName EQ 1 ) { formDetails = mfObj.getForms(id=inputPropStruct.childCustomElement); altText = formDetails.FormName; } qryString = 'formID=#inputPropStruct.childCustomElement#&linkageFieldID=#inputPropStruct.childLinkedField#'; #altText#

#renderData# var inputPropStruct = arguments.propertiesStruct; var renderData = ''; var deleteFormID = 0; var dataPageID = 0; var altText = ""; if(NOT IsNumeric(inputPropStruct.assocCustomElement)) { deleteFormID = inputPropStruct.childCustomElement; dataPageID = arguments.childDataPageID; } else { deleteFormID = inputPropStruct.assocCustomElement; dataPageID = arguments.assocDataPageID; } altText = "Delete #Request.Site.availcontrols[deleteFormID].shortdesc#"; if (StructKeyExists(arguments.propertiesStruct,"deleteOptionText") AND Len(arguments.propertiesStruct['deleteOptionText'])) altText = arguments.propertiesStruct['deleteOptionText']; #altText#

#renderData# var ceObj = Server.CommonSpot.ObjectFactory.getObject("CustomElement"); var inputPropStruct = arguments.propertiesStruct; var dataFormID = 0; var getOrderForMovedRec = ''; var getOrderForEndRec = ''; var minPosValue = 0; var maxPosValue = 0; var returnStruct = StructNew(); var endPos = 0; var getNextRecord = QueryNew(''); var endDataPageID = 0; if (IsNumeric(inputPropStruct.assocCustomElement)) dataFormID = inputPropStruct.assocCustomElement; else dataFormID = inputPropStruct.childCustomElement; SELECT FieldValue AS OrderPosition, PageID FROM Data_FieldValue WHERE PageID = AND FormID = AND FieldID = AND VersionState = AND PageID > 0 SELECT FieldValue AS OrderPosition, PageID FROM Data_FieldValue WHERE PageID = AND FormID = AND FieldID = AND VersionState = AND PageID > 0 SELECT FieldValue AS OrderPosition, PageID FROM Data_FieldValue WHERE FieldValue > AND FormID = AND FieldID = AND VersionState = AND PageID > 0 ORDER BY OrderPosition endPos = getNextRecord.OrderPosition[1]; endPos = getOrderForEndRec.OrderPosition; endPos = 1; if( getOrderForMovedRec.OrderPosition GT endPos ) { minPosValue = endPos; maxPosValue = getOrderForMovedRec.OrderPosition; } else { minPosValue = getOrderForMovedRec.OrderPosition; maxPosValue = endPos; } minPosValue = 0; maxPosValue = 0; returnStruct['minPos'] = minPosValue; returnStruct['maxPos'] = maxPosValue; return returnStruct; var reqFormFields = ""; var ceObj = Server.CommonSpot.ObjectFactory.getObject("CustomElement"); var inputPropStruct = arguments.propertiesStruct; var childObj = ''; // Server.CommonSpot.ObjectFactory.getObject(inputPropStruct.secondaryElementType); var curValuesStruct = arguments.currentValues; var dataFormID = 0; var dataFieldID = 0; var getPageIDs = ''; var getRecsToChg = QueryNew('DataPageID,Pos'); var linkedFldDetails = QueryNew(''); var compareValueWithChild = ''; var dbType = Request.Site.SiteDBType; var intType = ''; var parentInstanceIDVal = 0; var compareValueWithChildArr = ArrayNew(1); var i = 0; if( NOT StructKeyExists(inputPropStruct,'secondaryElementType') ) inputPropStruct.secondaryElementType = 'CustomElement'; childObj = Server.CommonSpot.ObjectFactory.getObject(inputPropStruct.secondaryElementType); if (arguments.parentFormType EQ 'MetadataForm' AND inputPropStruct.parentUniqueField EQ '{{pageid}}') parentInstanceIDVal = arguments.pageID; else parentInstanceIDVal = curValuesStruct['fic_#arguments.formID#_#inputPropStruct.parentUniqueField#']; if(IsNumeric(inputPropStruct.assocCustomElement)) linkedFldDetails = ceObj.getFields(elementID=inputPropStruct.assocCustomElement,fieldID=inputPropStruct.parentInstanceIDField); else { if( inputPropStruct.secondaryElementType EQ 'CustomElement' ) linkedFldDetails = childObj.getFields(elementID=inputPropStruct.childCustomElement,fieldID=inputPropStruct.childLinkedField); else linkedFldDetails = childObj.getFields(formID=inputPropStruct.childCustomElement,fieldID=inputPropStruct.childLinkedField); } compareValueWithChild = getLinkedFieldValue(fieldType=linkedFldDetails.type,fieldValue=parentInstanceIDVal); compareValueWithChildArr = ListToArray(compareValueWithChild, '||'); switch (dbtype) { case 'Oracle': intType = 'number(12)'; break; case 'MySQL': intType = 'UNSIGNED'; break; case 'SQLServer': intType = 'int'; break; } if (IsNumeric(inputPropStruct.assocCustomElement)) { dataFormID = inputPropStruct.assocCustomElement; dataFieldID = inputPropStruct.parentInstanceIDField; } else { dataFormID = inputPropStruct.childCustomElement; dataFieldID = inputPropStruct.childLinkedField; } SELECT PageID FROM Data_FieldValue WHERE FormID = AND FieldID = AND ( FieldValue = OR ) AND VersionState = AND PageID > 0 SELECT FieldValue AS Pos, PageID AS DataPageID FROM Data_FieldValue WHERE FormID = AND FieldID = AND AND VersionState = AND CAST(FieldValue AS #intType#) >= AND CAST(FieldValue AS #intType#) <= AND PageID > 0 ORDER BY Pos getRecsToChg = QueryNew('ErrorMsg'); QueryAddRow(getRecsToChg, 1); QuerySetCell(getRecsToChg, 'ErrorMsg', "Error occurred while trying to retrieve range records. #cfcatch.message# #cfcatch.detail#"); return getRecsToChg; var inputPropStruct = arguments.propertiesStruct; var updateRec = ''; var qry = ''; var elementFormID = 0; var name = ''; UPDATE Data_FieldValue SET FieldValue = WHERE PageID = AND FieldID = AND VersionState = AND PageID > 0 UPDATE Data_FieldValue SET DateApproved = WHERE PageID = AND VersionState = AND PageID > 0 // if( qry.recordCount eq 1 ) // { // invalidate the element cache Application.CacheInfoCache.InvalidateByTypeList(arguments.FormID, Request.Constants.rphaseAllCache, 0, 0); // all levels, indirect change, don't limit to WIP if (StructKeyExists(request.site.availControls, arguments.FormID)) { request.site.availControls[arguments.FormID].lastUpdateSinceRestart = request.formattedTimestamp; name = request.site.availControls[arguments.FormID].shortDesc; request.site.availControlsByName['custom:#name#'].lastUpdateSinceRestart = request.formattedTimestamp; } // } var columnArray = ListToArray(arguments.fieldOrderList); var queryArray = ArrayNew(1); var i = 0; var rowStruct = StructNew(); var j = 0; var columnName = ''; var theArrayLen = 0; for ( i=1; i LTE arguments.queryData.RecordCount; i=i + 1 ) { rowStruct = StructNew(); theArrayLen = ArrayLen(columnArray); for(j=1; j LTE theArrayLen; j=j + 1) { columnName = columnArray[j]; rowStruct[j] = arguments.queryData[columnName][i]; } ArrayAppend(queryArray, rowStruct); } return queryArray; var result = QueryNew(''); var customElementObj = Server.CommonSpot.ObjectFactory.getObject('CustomElement'); var metadataFormObj = Server.CommonSpot.ObjectFactory.getObject('MetadataForm'); allMetadataForms = metadataFormObj.getForms(); allCustomElements = customElementObj.getList(type="All", state="Active"); SELECT ID, Name, LOWER(Type) AS Type FROM allCustomElements UNION ALL SELECT ID, CAST(FormName AS VARCHAR) AS Name, 'metadataform' AS Type FROM allMetadataForms result = QueryNew('ErrorMsg'); QueryAddRow(result, 1); QuerySetCell(result, 'ErrorMsg', "Error occurred while trying to retrieve the global custom elements."); var result = QueryNew(''); var formObj = Server.CommonSpot.ObjectFactory.getObject(arguments.elementType); var resultData = ''; var elementDetails = QueryNew(''); var nameField = ''; if (arguments.elementType EQ 'MetadataForm') { elementDetails = formObj.getForms(ID=arguments.elementID); resultData = formObj.getFields(formID=arguments.elementID); nameField = elementDetails.FormName; } else { elementDetails = formObj.getInfo(elementID=arguments.elementID); resultData = formObj.getFields(elementID=arguments.elementID); nameField = elementDetails.Name; } SELECT ID, Label AS Name, Name AS FieldName, Type, '#nameField#' AS CustomElementName FROM resultData if (Len(result.Name) EQ 0) result.Name = ReplaceNoCase(result.FieldName,'FIC_',''); result = QueryNew('ErrorMsg'); QueryAddRow(result, 1); QuerySetCell(result, 'ErrorMsg', "Error occurred while trying to retrieve data the fields for the element."); var result = QueryNew(''); var formObj = Server.CommonSpot.ObjectFactory.getObject(arguments.elementType); var resultData = ''; if (arguments.elementType EQ 'MetadataForm') resultData = formObj.getFields(formID=arguments.elementID); else resultData = formObj.getFields(elementID=arguments.elementID); result = ValueList(resultData.ID); result = 'Error'; var inputPropStruct = StructNew(); var curValuesStruct = StructNew(); var dataRecords = QueryNew(''); var displayData = QueryNew(''); var logError = false; var logErrorMsg = ''; try { if (IsJSON(arguments.propertiesStruct)) inputPropStruct = DeserializeJSON(arguments.propertiesStruct); else inputPropStruct = arguments.propertiesStruct; dataRecords = queryData(formID=arguments.formID,propertiesStruct=inputPropStruct,parentInstanceValue=arguments.parentInstanceValue, parentFormType=arguments.parentFormType,pageID=arguments.pageID); if (NOT StructKeyExists(dataRecords, 'errorMsg')) displayData = getDisplayData(fieldID=arguments.fieldID, propertiesStruct=inputPropStruct, dataRecords=dataRecords.qry, fieldMapStruct=dataRecords.fieldMapStruct, fieldOrderList=dataRecords.fieldOrderList, displayMode=arguments.displayMode); //application.ADF.utils.doDUMP(displayData,"displayData",1); return SerializeJSON(displayData); } catch (any e) { logError = true; logErrorMsg = "#e.message# #e.detail#"; } var orderOp = ''; var qOrderedResults = QueryNew(''); var loopStart = 0; var loopEnd = 0; var newOrderValue = 0; var newOrderValueForSelected = 0; var updateRec = ''; var updateCurRec = ''; var sResult = 'Success'; var inputPropStruct = StructNew(); var curValuesStruct = StructNew(); var dataFormID = 0; var posStruct = StructNew(); var rangeRecords = QueryNew(''); var i = 0; if ( IsJSON(arguments.propertiesStruct) ) inputPropStruct = DeserializeJSON(arguments.propertiesStruct); else if ( IsStruct(arguments.propertiesStruct) ) inputPropStruct = arguments.propertiesStruct; else { sResult = 'Failed to read the propertiesStruct value that was passed in to the Custom Element Datamanager onDrop method.'; application.ADF.utils.logAppend(msg=sResult,logFile="adf-custom-element-data-manager-cft.log"); return sResult; } if ( IsJSON(arguments.currentValues) ) curValuesStruct = DeserializeJSON(arguments.currentValues); else if ( IsStruct(arguments.currentValues) ) curValuesStruct = arguments.currentValues; else { sResult = 'Failed to read the currentValues value that was passed in to the Custom Element Datamanager onDrop method.'; application.ADF.utils.logAppend(msg=sResult,logFile="adf-custom-element-data-manager-cft.log"); return sResult; } posStruct = getReorderRange( propertiesStruct=inputPropStruct, movedDataPageID=arguments.movedDataPageID, dropAfterDataPageID=arguments.dropAfterDataPageID ); rangeRecords = getRangeRecords( formID=arguments.formID, currentValues=curValuesStruct, propertiesStruct=inputPropStruct, minPos=posStruct.minPos, maxPos=posStruct.maxPos, parentFormType=arguments.parentFormType, pageID=arguments.pageID ); if (rangeRecords.DataPageID[1] EQ arguments.movedDataPageID) { loopStart = 2; loopEnd = rangeRecords.RecordCount; newOrderValueForSelected = rangeRecords.Pos[rangeRecords.RecordCount]; newOrderValueForSelected = NumberFormat( newOrderValueForSelected, '000000009' ); orderOp = '-'; } else if (rangeRecords.DataPageID[rangeRecords.RecordCount] EQ arguments.movedDataPageID) { loopStart = 1; loopEnd = rangeRecords.RecordCount - 1; newOrderValueForSelected = rangeRecords.Pos[1]; newOrderValueForSelected = NumberFormat( newOrderValueForSelected, '000000009' ); orderOp = '+'; } // newOrderValue = Evaluate('#rangeRecords['Pos'][i]# #orderOp# 1'); if( orderOp eq '+' ) newOrderValue = val(rangeRecords['Pos'][i]) + 1; else newOrderValue = val(rangeRecords['Pos'][i]) - 1; newOrderValue = NumberFormat( newOrderValue, '000000009' ); changePosition( formID=arguments.formID, propertiesStruct=inputPropStruct, dataPageID=rangeRecords['DataPageID'][i], newPos=newOrderValue); changePosition( formID=arguments.formID, propertiesStruct=inputPropStruct, dataPageID=arguments.movedDataPageID, newPos=newOrderValueForSelected); sResult = rangeRecords.ErrorMsg[1]; sResult = 'Could not determine the position range for the moved element.'; var result = QueryNew(''); var formObj = Server.CommonSpot.ObjectFactory.getObject(arguments.elementType); var elementDetails = QueryNew(''); if (arguments.elementType EQ 'MetadataForm') { elementDetails = formObj.getForms(ID=arguments.elementID); result = elementDetails.FormName; } else { elementDetails = formObj.getInfo(elementID=arguments.elementID); result = elementDetails.Name; } result = 'Error'; var paramsData = ''; var passthroughParamsStruct = StructNew(); var returnString = arguments.fieldValue; var ceDataArray = ArrayNew(1); var ceDataArrayLen = 0; var valueIndex = 0; var i = 0; var displayString = ''; var key = '#fieldID#'; var build = 1; var theArrayLen = 0; var valueFld = 0; var displayFld = 0; var ceObj = Server.CommonSpot.ObjectFactory.getObject('CustomElement'); var cfmlFilterCriteria = StructNew(); var ceFormID = 0; var fieldList = ''; var sortColumn = ''; var sortDir = ''; var filterArray = ArrayNew(1); var statementsArray = ArrayNew(1); var fldsQry = QueryNew(''); var index = 1; var valueWithoutParens = ''; var hasParens = 0; var ceData = QueryNew(''); var formIDColArray = ''; var formNameColArray = ''; var start = 0; var end = 0; if( NOT StructKeyExists(request,'getContent_ceSelect') ) request['getContent_ceSelect'] = structNew(); if( NOT StructKeyExists(request['getContent_ceSelect'],fieldID ) ) { request['getContent_ceSelect'][fieldID] = structNew(); build = 1; } else build = 0; SELECT Params FROM FormInputControl WHERE ID = passthroughParamsStruct = Server.CommonSpot.UDF.util.WDDXDecode(paramsData.Params); // build structures to cache the ceDataArray results request['getContent_ceSelect'][fieldID] = StructNew(); request['getContent_ceSelect'][fieldID].valueField = passthroughParamsStruct.valueField; request['getContent_ceSelect'][fieldID].displayField = passthroughParamsStruct.displayField; request['getContent_ceSelect'][fieldID].displayFieldBuilder = passthroughParamsStruct.displayFieldBuilder; // If Multi-select - no display value look up if( StructKeyExists(passthroughParamsStruct,"MultipleSelect") AND passthroughParamsStruct.MultipleSelect eq 1 ) { request['getContent_ceSelect'][fieldID].assocArray = ''; } // single select. Display Value can be returned else { // // Get Results of ALL applicable records. // /*if( StructKeyExists(passthroughParamsStruct,"activeFlagField") AND Len(passthroughParamsStruct.activeFlagField) AND StructKeyExists(passthroughParamsStruct,"activeFlagValue") AND Len(passthroughParamsStruct.activeFlagValue) ) { if((TRIM(LEFT(passthroughParamsStruct.activeFlagValue,1)) EQ "[") AND (TRIM(RIGHT(passthroughParamsStruct.activeFlagValue,1)) EQ "]")) { passthroughParamsStruct.activeFlagValue = MID(passthroughParamsStruct.activeFlagValue, 2, LEN(passthroughParamsStruct.activeFlagValue)-2); passthroughParamsStruct.activeFlagValue = Evaluate(passthroughParamsStruct.activeFlagValue); } ceDataArray = application.ADF.ceData.getCEData(passthroughParamsStruct.customElement,passthroughParamsStruct.activeFlagField,passthroughParamsStruct.activeFlagValue); } else { // No filter, get all records ceDataArray = application.ADF.ceData.getCEData(passthroughParamsStruct.customElement); }*/ if (StructKeyExists(passthroughParamsStruct,"customElement") and Len(passthroughParamsStruct.customElement)) ceFormID = application.ADF.cedata.getFormIDByCEName(passthroughParamsStruct.customElement); if ( StructKeyExists(passthroughParamsStruct,"activeFlagField") AND Len(passthroughParamsStruct.activeFlagField) AND StructKeyExists(passthroughParamsStruct,"activeFlagValue") AND Len(passthroughParamsStruct.activeFlagValue) ) { if ( (TRIM(LEFT(passthroughParamsStruct.activeFlagValue,1)) EQ "[") AND (TRIM(RIGHT(passthroughParamsStruct.activeFlagValue,1)) EQ "]")) { valueWithoutParens = MID(passthroughParamsStruct.activeFlagValue, 2, LEN(passthroughParamsStruct.activeFlagValue)-2); hasParens = 1; } else { valueWithoutParens = passthroughParamsStruct.activeFlagValue; } statementsArray[1] = ceObj.createStandardFilterStatement(customElementID=ceFormID,fieldIDorName=passthroughParamsStruct.activeFlagField,operator='Equals',value=valueWithoutParens); filterArray = ceObj.createQueryEngineFilter(filterStatementArray=statementsArray,filterExpression='1'); if (hasParens) { filterArray[1] = ReplaceNoCase(filterArray[1], '| #valueWithoutParens#| |', '#valueWithoutParens#| ###valueWithoutParens###| |'); } cfmlFilterCriteria.filter = StructNew(); cfmlFilterCriteria.filter.serSrchArray = filterArray; cfmlFilterCriteria.defaultSortColumn = passthroughParamsStruct.activeFlagField & '|asc'; } if ( StructKeyExists(passthroughParamsStruct,"sortByField") and passthroughParamsStruct.sortByField NEQ '--') { cfmlFilterCriteria.defaultSortColumn = passthroughParamsStruct.sortByField & '|asc'; } if (NOT StructIsEmpty(cfmlFilterCriteria)) passthroughParamsStruct.filterCriteria = Server.CommonSpot.UDF.util.WDDXEncode(cfmlFilterCriteria); if (StructKeyExists(passthroughParamsStruct, 'filterCriteria') AND IsWDDX(passthroughParamsStruct.filterCriteria)) { cfmlFilterCriteria = Server.CommonSpot.UDF.util.WDDXDecode(passthroughParamsStruct.filterCriteria); if ( StructKeyExists(cfmlFilterCriteria,"filter") ) filterArray = cfmlFilterCriteria.filter.serSrchArray; sortColumn = ListFirst(cfmlFilterCriteria.defaultSortColumn,'|'); sortDir = ListLast(cfmlFilterCriteria.defaultSortColumn,'|'); } if (StructKeyExists(passthroughParamsStruct,"customElement") and Len(passthroughParamsStruct.customElement)) { fldsQry = ceObj.GetFields(ceFormID); fieldList = ValueList(fldsQry.Name); if( StructKeyExists(passthroughParamsStruct, "displayField") AND LEN(passthroughParamsStruct.displayField) AND passthroughParamsStruct.displayField neq "--Other--" ) fieldList = '#passthroughParamsStruct.displayField#,#passthroughParamsStruct.valueField#'; else if( passthroughParamsStruct.displayField eq "--Other--" AND passthroughParamsStruct.DisplayFieldBuilder neq '' ) { start = 1; fieldList = ''; while( true ) { start = FindNoCase( Chr(171), passthroughParamsStruct.DisplayFieldBuilder, start ); if( start ) { end = FindNoCase( Chr(187), passthroughParamsStruct.DisplayFieldBuilder, start ); if( end ) { fld = Mid( passthroughParamsStruct.DisplayFieldBuilder, start + 1, (end - (start+1)) ); if( NOT FindNoCase( fld, fieldList ) ) fieldList = ListAppend( fieldList, fld ); start = end; } else break; } else break; } // if value field not already in list, add it to the list if( NOT FindNoCase( passthroughParamsStruct.valueField, fieldList ) ) fieldList = ListAppend( fieldList, passthroughParamsStruct.valueField ); } else { fieldList = passthroughParamsStruct.valueField; } if (NOT Len(sortColumn) AND NOT Len(sortDir)) { sortColumn = ListFirst(fieldList); sortDir = 'asc'; } if( NOT ListFindNoCase(fieldList, sortColumn) ) fieldList = ListAppend(fieldList, sortColumn); if (NOT ArrayLen(filterArray)) filterArray[1] = '| element_datemodified| element_datemodified| <= | | c,c,c| | '; ceData = ceObj.getRecordsFromSavedFilter(elementID=ceFormID,queryEngineFilter=filterArray,columnList=fieldList,orderBy=sortColumn,orderByDirection=sortDir, limit=0); formIDColArray = ArrayNew(1); formNameColArray = ArrayNew(1); if (ceData.ResultQuery.RecordCount) { ArraySet(formIDColArray, 1, ceData.ResultQuery.RecordCount, ceFormID); ArraySet(formNameColArray, 1, ceData.ResultQuery.RecordCount, passthroughParamsStruct.customElement); } QueryAddColumn(ceData.ResultQuery, 'formID', formIDColArray); QueryAddColumn(ceData.ResultQuery, 'formName', formIDColArray); } ceDataArray = application.ADF.cedata.buildCEDataArrayFromQuery(ceData.ResultQuery); // cache the results ceDataArrayLen = ArrayLen(ceDataArray); request['getContent_ceSelect'][fieldID].ceDataArray = ceDataArray; // Custom element selects can 'Build' the display value. Handle that case if( passthroughParamsStruct.displayField eq "--Other--" and Len(passthroughParamsStruct.displayFieldBuilder) ) { // store the offset into the ceDataArray request['getContent_ceSelect'][fieldID].assocArray = StructNew(); for(i=1; i LTE ceDataArrayLen; i=i+1 ) { valueFld = ceDataArray[i].Values['#passthroughParamsStruct.valueField#']; request['getContent_ceSelect'][fieldID].assocArray[valueFld] = i; } } // Normal case - display value is just another field, no building display value from multiple fields. // So store name value pairs. else if( passthroughParamsStruct.displayField neq "" ) { // store value and display field request['getContent_ceSelect'][fieldID].assocArray = StructNew(); for(i=1; i LTE ceDataArrayLen; i=i+1 ) { valueFld = ceDataArray[i].Values['#passthroughParamsStruct.valueField#']; displayFld = ceDataArray[i].Values['#passthroughParamsStruct.displayField#']; request['getContent_ceSelect'][fieldID].assocArray[valueFld] = displayFld; } } // No display value, just return the value else { request['getContent_ceSelect'][fieldID].assocArray = ''; } } // the Structure request['getContent_ceSelect'][fieldID] is built at this point. // Display Value is built from one or more fields if( arguments.fieldValue neq '' ) { if( request['getContent_ceSelect'][fieldID].displayField eq "--Other--" AND Len(request['getContent_ceSelect'][fieldID].displayFieldBuilder) AND StructKeyExists(request['getContent_ceSelect'][fieldID], 'assocArray') AND isStruct( request['getContent_ceSelect'][fieldID].assocArray ) AND StructKeyExists( request['getContent_ceSelect'][fieldID].assocArray, arguments.fieldValue) ) { i = request['getContent_ceSelect'][fieldID].assocArray[arguments.fieldValue]; returnString = application.ADF.forms.renderDataValueStringfromFieldMask( request['getContent_ceSelect'][fieldID].ceDataArray[i].Values, request['getContent_ceSelect'][fieldID].displayFieldBuilder ); } // Display Value is another field, simple lookup else if( isStruct( request['getContent_ceSelect'][fieldID].assocArray ) AND StructKeyExists( request['getContent_ceSelect'][fieldID].assocArray, arguments.fieldValue) ) { returnString = request['getContent_ceSelect'][fieldID].assocArray[arguments.fieldValue]; } // Fall back, just pass back the value. else { returnString = arguments.fieldValue; } } var paramsData = ''; var passthroughParamsStruct = StructNew(); var selectOptions = StructNew(); var returnString = arguments.fieldValue; var i = 0; var theArrayLen = 0; var build = 1; var valueText = ''; var displayText = ''; if( NOT StructKeyExists(request,'getContent_select') ) request['getContent_select'] = structNew(); if( NOT StructKeyExists(request['getContent_select'],fieldID ) ) { request['getContent_select'][fieldID] = structNew(); build = 1; } else build = 0; SELECT Params FROM FormInputControl WHERE ID = passthroughParamsStruct = Server.CommonSpot.UDF.util.WDDXDecode(paramsData.Params); request['getContent_select'][fieldID].assocArray = StructNew(); theArrayLen = ArrayLen(selectOptions.optionValues); for( i=1; i lte theArrayLen; i=i+1 ) { valueText = selectOptions.optionValues[i]; displayText = selectOptions.optionText[i]; request['getContent_select'][fieldID].assocArray[valueText] = displayText; } // the Structure request['getContent_select'][fieldID] is built at this point. // Display Value is another field, simple lookup if( StructKeyExists(request['getContent_select'][fieldID],'assocArray') AND isStruct( request['getContent_select'][fieldID].assocArray ) AND StructKeyExists( request['getContent_select'][fieldID].assocArray, arguments.fieldValue ) ) { returnString = request['getContent_select'][fieldID].assocArray[arguments.fieldValue]; } // Fall back, just pass back the value. else { returnString = arguments.fieldValue; } var returnString = arguments.fieldValue; var cgiServerProtocol = ''; var refererURL = ''; returnString = REReplaceNoCase(returnString, " return arguments.fieldValue; var ceObj = ''; var dataPageID = ''; var FormID = 0; if(NOT IsNumeric(arguments.propertiesStruct.assocCustomElement)) FormID = arguments.propertiesStruct.childCustomElement; else FormID = arguments.propertiesStruct.assocCustomElement; if( val(arguments.dataPageIDList) eq 0 OR val(formID) eq 0 ) return; ceObj = Server.CommonSpot.ObjectFactory.getObject("CustomElement"); for( i=1; i lte ListLen(arguments.dataPageIDList); i=i+1 ) { // current method only deletes one at a time?? try { dataPageID = ListGetAt( arguments.dataPageIDList, i ); if( val(dataPageID) gt 0 ) { ceObj.DeleteRecords( formID, dataPageID ); } } catch (any e) { application.adf.utils.logAppend( 'Could not delete custom element record from data manager. #e.message# #e.detail#', 'datamanager-delete.log' ); } } var dsn = Request.Site.Datasource; var returnString = arguments.fieldValue; SELECT FileName, SubsiteID, PageType, Uploaded FROM SitePages WHERE ID = // Since extended url stored data differently for different page types, need to set up proper value to be checked if (getPageInfo.RecordCount) { // Just set to compare with pageID instead of the whole string as certain actions like move in CS do not update the value in DB /*if (getPageInfo.PageType EQ Request.Constants.pgTypeNormal AND getPageInfo.Uploaded EQ 0) returnString = 'CP___PAGEID=#arguments.fieldValue#,#getPageInfo.FileName#,#getPageInfo.SubsiteID#||CP___PAGEID=#arguments.fieldValue#,#getPageInfo.FileName#'; else if ((getPageInfo.PageType EQ Request.Constants.pgTypeNormal AND getPageInfo.Uploaded EQ 1) OR getPageInfo.PageType EQ Request.Constants.pgTypeMultimedia OR getPageInfo.PageType EQ Request.Constants.pgTypeMultimediaPlaylist) returnString = 'CP___PAGEID=#arguments.fieldValue#'; else if (getPageInfo.PageType EQ Request.Constants.pgTypeImage) returnString = 'CP___PAGEID=#arguments.fieldValue#,#getPageInfo.FileName#'; else // PageType as user template,pageset,registered url returnString = 'CP___PAGEID=#arguments.fieldValue#,#getPageInfo.FileName#,#getPageInfo.SubsiteID#';*/ returnString = 'CP___PAGEID=#arguments.fieldValue#'; } SELECT Description FROM SitePages WHERE ID = if (getPageInfo.RecordCount) returnString = 'CPIMAGE:#arguments.fieldValue#|#getPageInfo.Description#';