if ( request.user.id eq 0 ) { WriteOutput('
You must be logged in. Please login now.'); exit; } // Delete GCE Records // ceName = 'DEV4 GCE'; ceName = 'zDEV4 GCE Copy'; delStart = 1; // 1 or higher; delRows = 1; // 'all' or 1 or higher verbose = false; // Config Values // ----- skipFieldName = 'id'; // Url Params if ( StructKeyExists(request.params,'start') ) delStart = request.params.start; if ( StructKeyExists(request.params,'rows') ) delRows = request.params.rows; if ( StructKeyExists(request.params,'verbose') AND IsBoolean(request.params.verbose) ) verbose = request.params.verbose; datapageidList = ''; dataArr = application.ADF.ceData.getCEData(ceName); delTotal = ArrayLen(dataArr); WriteOutput('
Before Count: #delTotal#'); if ( NOT IsNumeric(delStart) ) delStart = 1; calcRows = application.ADF.data.calcStartEndRows(total=delTotal,start=delStart,qty=delRows); startRow = calcRows.start; endRow = calcRows.end; rowCnt = calcRows.rows; WriteOutput('
startRow: #startRow#'); WriteOutput('
endRow: #endRow#'); deleteRecord = false; pageid = 0 dataValues = {}; for ( i=startRow; i <= endRow; i++ ) { deleteRecord = false; pageid = dataArr[i].pageid; dataValues = dataArr[i].values; WriteOutput('
delete item: #i#'); deleteRecord = true; //if ( TRIM(dataValues.multimediaField) EQ '' AND TRIM(dataValues.mmBrightcoveField) EQ '' AND TRIM(dataValues.mmLocalField) EQ '' ) // deleteRecord = true; if ( deleteRecord ) application.ADF.ceData.deleteCE(datapageidList=pageid); } dataArr = application.ADF.ceData.getCEData(ceName); WriteOutput('
After Count: #ArrayLen(dataArr)#');