if ( NOT StructKeyExists(request.params,"action") ) request.params.action = "form"; if ( NOT StructKeyExists(request.params,"subsiteFilterList") ) request.params.subsiteFilterList = ""; if ( NOT StructKeyExists(request.params,"subsiteMappingList") ) request.params.subsiteMappingList = 0; SELECT ID, SubsiteURL FROM Subsites ORDER by SubsiteURL

Select All Subsites in the Subsite Mappings?
Subsite Filter:	#SubsiteURL#

Back to Search Form if ( request.params.subsiteMappingList ){ // Get all the OLD subsite ID list in the subsite mappings subsiteMapData = application.ptImport.subsiteDAO.getMappingData(); request.params.subsiteFilterList = ListAppend(request.params.subsiteFilterList, ValueList(subsiteMapData.oldSubsiteID)); } SELECT * FROM subsiteCount.subsiteQuery ORDER BY template, oldsubsiteid currTemplate = template; prevTemplate = currTemplate; queryAddRow(templateQry); querySetCell(templateQry, "id", templateQry.RecordCount, templateQry.RecordCount); querySetCell(templateQry, "oldsubsiteid", oldsubsiteid, templateQry.RecordCount); querySetCell(templateQry, "name", name, templateQry.RecordCount); querySetCell(templateQry, "textblocks", textblocks, templateQry.RecordCount); querySetCell(templateQry, "template", template, templateQry.RecordCount); prevRowID = templateQry.RecordCount; prevTextblocks = textblocks; if ( NOT ListFind(prevTextblocks, itm) ){ prevTextblocks = ListAppend(prevTextblocks, itm); querySetCell(templateQry, "textblocks", ListSort(prevTextblocks, "numeric"), prevRowID); }

// Look into the subsite mapping to get the new subsite path subsiteMapQry = application.ptImport.SubsiteDAO.getMappingDataBySubsiteURL(oldSubsiteURL=name);

Old Subsite ID	Old Subsite Path	New Subsite Path	Template	Distinct RTE Page Layouts
#name#	#oldsubsiteid#	#subsiteMapQry.newSubsiteURL#	#template#	#textblocks# [details]

#subsiteCount[currKey].name# #subsiteCount[currKey].id# #subsiteCount[currKey].textblocks# ---> Back to Search Form

RTE Count on Page	Page IDs
#rteIndex#	#Replace(subsiteCount.retRTEPageInfo[rteIndex],",",", ","all")#