Survey Characteristics Search

 Select Survey Year
 Select Survey Status
Select Region/Country
Select Survey Type
Select Survey Characteristics
Clear Search  


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /Methodology/Survey-Search.cfm
Time Stamp 02-Jul-24 11:12 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.0.2.129
Host Name 10.0.2.129


Execution Time

Total Time Avg Time Count Template
562 ms 21 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
562 ms 21 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
360 ms 360 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
360 ms 360 ms 1 C:/inetpub/wwwroot/dhs/Methodology/Survey-Search.cfm
313 ms 313 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
313 ms 313 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
313 ms 313 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
313 ms 313 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
313 ms 313 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
281 ms 28 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
281 ms 281 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
235 ms 235 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c1378-l70-t51-dAny.read
219 ms 219 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
203 ms 203 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
171 ms 171 ms 1 C:/inetpub/wwwroot/dhs/Methodology/customcf/survey-search-cs.cfm
32 ms 16 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(4470, 4473) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19154-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/Methodology/Application.cfm
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(4470) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19152-l70-t51-dAny.read
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c1432-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19153-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19155-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p4470-c19177-l70-t51-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/dhtmlmenu/menu-output-display.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
0 ms 0 ms 4 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(3901) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(4470) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(3901, 19, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(4470, 19, 3901, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 19, 4470, 3901, 0, 0, 90) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomAppPath(19) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomModulePath(post-page-render, 19) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc | GetEntry(4470) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc | getRewriteSettings(19) ] from C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(3901) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(template-what-we-do-temp-new.cfm, 3901, 19) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc | executeFunction(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(RequestTimeout check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Server-level remote requests checked) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Subsite context updated (ID=19)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(customerScope object initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Cache) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Element) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(LiveBookmarks) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(4470, 19) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
376 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=2360) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 23:12:10.010
		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 3901
Parameter #5(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 23:12:10.010
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=4470 OR (PageID IN (3901,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		
qry (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 23:12:10.010
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 23:12:10.010
		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470
Parameter #2(CF_SQL_INTEGER) = 11

ControlInstanceData (Datasource=commonspot-site-dhs, Time=16ms, Records=82) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 23:12:10.010
		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 3901

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:12:10.010
		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 400
Parameter #2(CF_SQL_INTEGER) = 22
Parameter #3(CF_SQL_INTEGER) = 44
Parameter #4(CF_SQL_INTEGER) = 55
Parameter #5(CF_SQL_INTEGER) = 1
Parameter #6(CF_SQL_INTEGER) = 56
Parameter #7(CF_SQL_INTEGER) = 47
Parameter #8(CF_SQL_INTEGER) = 26
Parameter #9(CF_SQL_INTEGER) = 48
Parameter #10(CF_SQL_INTEGER) = 27
Parameter #11(CF_SQL_INTEGER) = 28
Parameter #12(CF_SQL_INTEGER) = 51
Parameter #13(CF_SQL_INTEGER) = 31
Parameter #14(CF_SQL_INTEGER) = 33
Parameter #15(CF_SQL_INTEGER) = 26
Parameter #16(CF_SQL_INTEGER) = 48
Parameter #17(CF_SQL_INTEGER) = 37
Parameter #18(CF_SQL_INTEGER) = 27
Parameter #19(CF_SQL_INTEGER) = 38
Parameter #20(CF_SQL_INTEGER) = 28
Parameter #21(cf_sql_integer) = 26

Request.customCFUpfront (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 23:12:10.010
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=4470 OR (PageID IN (3901,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 23:12:10.010
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3901

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

modfeat_f (Datasource=dhs_legacy_live, Time=16ms, Records=44) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
FROM mod_feat m
INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
INNER JOIN survey s ON s.survey_ID = l.survey_ID
WHERE m.Active_Flag = 1
AND s.Stts_ID in (2,3)
AND m.internal_flag = 0
AND mod_feat_type = 'f'
AND biomarker = 0
AND (Mod_Feat_ID_Group IS NULL or Mod_Feat_ID_Group = 0)

GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
ORDER BY mod_feat_type, biomarker, mod_feat_name
modfeat_b (Datasource=dhs_legacy_live, Time=0ms, Records=23) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
FROM mod_feat m
INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
INNER JOIN survey s ON s.survey_ID = l.survey_ID
WHERE m.Active_Flag = 1
AND s.Stts_ID in (2,3)
AND m.internal_flag = 0
AND mod_feat_type = 'f'
AND biomarker = 1
AND (Mod_Feat_ID_Group IS NULL or Mod_Feat_ID_Group = 0)

GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
ORDER BY mod_feat_type, biomarker, mod_feat_name
modfeat_m (Datasource=dhs_legacy_live, Time=15ms, Records=21) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
FROM mod_feat m
INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
INNER JOIN survey s ON s.survey_ID = l.survey_ID
WHERE m.Active_Flag = 1
AND s.Stts_ID in (2,3)
AND m.internal_flag = 0
AND mod_feat_type = 'm'
AND (Mod_Feat_ID_Group IS NULL or Mod_Feat_ID_Group = 0)

GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
ORDER BY mod_feat_type, biomarker, mod_feat_name
GetModFeat_group (Datasource=dhs_legacy_live, Time=16ms, Records=3) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
		SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
		FROM mod_feat m
		INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
		INNER JOIN survey s ON s.survey_ID = l.survey_ID
		WHERE m.Active_Flag = 1
		AND s.Stts_ID in (2,3)
		AND Mod_Feat_ID_Group = 120
		
		GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
		ORDER BY mod_feat_type, biomarker, mod_feat_name
		
GetModFeat_group (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
		SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
		FROM mod_feat m
		INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
		INNER JOIN survey s ON s.survey_ID = l.survey_ID
		WHERE m.Active_Flag = 1
		AND s.Stts_ID in (2,3)
		AND Mod_Feat_ID_Group = 47
		
		GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
		ORDER BY mod_feat_type, biomarker, mod_feat_name
		
GetModFeat_group (Datasource=dhs_legacy_live, Time=15ms, Records=8) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
		SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
		FROM mod_feat m
		INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
		INNER JOIN survey s ON s.survey_ID = l.survey_ID
		WHERE m.Active_Flag = 1
		AND s.Stts_ID in (2,3)
		AND Mod_Feat_ID_Group = 23
		
		GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
		ORDER BY mod_feat_type, biomarker, mod_feat_name
		
GetModFeat_group (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
		SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
		FROM mod_feat m
		INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
		INNER JOIN survey s ON s.survey_ID = l.survey_ID
		WHERE m.Active_Flag = 1
		AND s.Stts_ID in (2,3)
		AND Mod_Feat_ID_Group = 124
		
		GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
		ORDER BY mod_feat_type, biomarker, mod_feat_name
		
GetModFeat_group (Datasource=dhs_legacy_live, Time=0ms, Records=10) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
		SELECT m.mod_feat_id, mod_feat_name, COUNT(DISTINCT s.survey_id) AS Cnt, mod_feat_type, biomarker, Mod_Feat_ID_Group
		FROM mod_feat m
		INNER JOIN survey_mod_feat_lnk l ON m.mod_feat_ID = l.mod_feat_ID
		INNER JOIN survey s ON s.survey_ID = l.survey_ID
		WHERE m.Active_Flag = 1
		AND s.Stts_ID in (2,3)
		AND Mod_Feat_ID_Group = 122
		
		GROUP BY mod_feat_type, biomarker, Mod_Feat_ID_Group, m.mod_feat_id, mod_feat_name
		ORDER BY mod_feat_type, biomarker, mod_feat_name
		
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 23:12:10.010
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4470

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3901

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:12:10.010
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1


Stored Procedures

usp_get_Ctry_Region_modfeat_SurvType_qYear (Datasource=dhs_legacy_live, Time=31ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010

    
parameters
typeCFSQLTypevaluevariabledbVarName
    
resultsets
nameresultset
 ctrys  1
 regions  2
 modfeat  3
 GetMainType  4
 qYear  5
usp_get_ctry_details_rgn (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  4    
    
resultsets
nameresultset
 qctry  1
usp_get_ctry_details_rgn (Datasource=dhs_legacy_live, Time=15ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  3    
    
resultsets
nameresultset
 qctry  1
usp_get_ctry_details_rgn (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  5    
    
resultsets
nameresultset
 qctry  1
usp_get_ctry_details_rgn (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  1    
    
resultsets
nameresultset
 qctry  1
usp_get_ctry_details_rgn (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  7    
    
resultsets
nameresultset
 qctry  1
usp_get_ctry_details_rgn (Datasource=dhs_legacy_live, Time=15ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  2    
    
resultsets
nameresultset
 qctry  1
usp_get_surveyType_details_byID (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  1    
    
resultsets
nameresultset
 GetSubTypes  1
usp_get_surveyType_details_byID (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  2    
    
resultsets
nameresultset
 GetSubTypes  1
usp_get_surveyType_details_byID (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  5    
    
resultsets
nameresultset
 GetSubTypes  1
usp_get_surveyType_details_byID (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  3    
    
resultsets
nameresultset
 GetSubTypes  1
usp_get_surveyType_details_byID (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\survey-search-cs.cfm @ 23:12:10.010
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  4    
    
resultsets
nameresultset
 GetSubTypes  1


Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\Methodology\Survey-Search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=JSESSIONID=B8A4CFF3411A8644893C81E7A3D4A2DE.cfusion; CSRFTOKEN=1FDA0F72541EA0AF864012F1994E6CDDE1782BD5
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/Methodology/Survey-Search.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\Methodology\Survey-Search.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.129
REMOTE_HOST=10.0.2.129
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Methodology/Survey-Search.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CSRFTOKEN=1FDA0F72541EA0AF864012F1994E6CDDE1782BD5
JSESSIONID=B8A4CFF3411A8644893C81E7A3D4A2DE.cfusion
Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=25
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=1366388160
cs_runningdashboardcmdcode=0
csrftoken=1FDA0F72541EA0AF864012F1994E6CDDE1782BD5
ctrl_data=Struct (70)
customcf_data=Struct (2)
customcfupfront=Query (1)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-02 23:12:10
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719961930390
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-02 23:12:10.374
req_sequenceid=55049
req_startticks=1719961930374
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_B8A4CFF3411A8644893C81E7A3D4A2DE.cfusion
sessionstring=1_B8A4CFF3411A8644893C81E7A3D4A2DE.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=19
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-02 23:12:10'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=1FDA0F72541EA0AF864012F1994E6CDDE1782BD5
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=4470
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719961927640
listview=0
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=B8A4CFF3411A8644893C81E7A3D4A2DE.cfusion
sessionstring=1_B8A4CFF3411A8644893C81E7A3D4A2DE.cfusion
urltoken=CFID=2267218&CFTOKEN=9380214ece605e8-99327F0F-D527-181A-4BAEDACE380CC7EB&jsessionid=B8A4CFF3411A8644893C81E7A3D4A2DE.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 16 ms