Staging web site. (this banner will not appear on your "live" website)

Shopping cart is empty !

Last Viewed

Certificates: Search for Certificates

Search for Certificates Name in order to select classes to add to your Shopping cart:

Update your site by replacing this text with your own message.

Certificates Name

Certificates Keyword

Certificate 1: Automation

ID:1

Once upon a time on a lovely sunny day, Alice and her sister went out for a walk in the countryside. They got to a field near a little stream. Afte ... View More

Call 510-405-5448

View Certificate 1 Details »

Debugging Information

ColdFusion Server Enterprise	2021,0,21,330446
Template	/index.cfm
Time Stamp	18-Aug-25 03:56 PM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	172.31.103.195
Host Name	172.31.103.195

Execution Time

Total Time	Avg Time	Count	Template
305 ms	305 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequest(/index.cfm) ] from E:/Lumens/Application.cfc
305 ms	305 ms	1	E:/Lumens/Versions/v81QA/fusebox4.runtime.cfmx.cfm
304 ms	304 ms	1	E:/Lumens/Versions/v81QA/parsed/certificates.certificatesearch.cfm
203 ms	203 ms	1	E:/Lumens/Versions/v81QA/view/certificates/dsp_certificateSearch.cfm
78 ms	78 ms	1	E:/Lumens/Versions/v81QA/model/certificates/act_certificateSearch.cfm
34 ms	34 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc
30 ms	30 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc \| getCertificateDetails() ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc
23 ms	23 ms	1	E:/Lumens/Versions/v81QA/header.cfm
23 ms	23 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/header_section.cfm
17 ms	17 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/templates/templateModel.cfc \| getAvailableFields(v8Testing6, SearchforCertificates) ] from E:/Lumens/versions/v81QA/cfc/systemoptions/templates/templateModel.cfc
16 ms	16 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| processRequest(ip_address = 216.73.216.101) ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/udf/index.cfm
15 ms	15 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc \| GetCertificatePrice(1, 1, 0, 0) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc
15 ms	15 ms	1	E:/Lumens/Versions/v81QA/view/certificates/dsp_certificate_class_listing_template3.cfm
10 ms	10 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc \| init(v8Testing6) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc
5 ms	5 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/custom_style.cfm
4 ms	4 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc \| getSubCategory() ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc
3 ms	3 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-banner.cfm
1 ms	1 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc \| getCategory() ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Application.cfc \| onSessionStart() ] from E:/Lumens/Application.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc \| INIT(v8Testing6) ] from E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| getFooterNavItems() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| getUserNavItems() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc \| INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getGraphicsDetails(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getSiteResourcePathDetailsByID(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/app_setup.cfc \| FindApplicationCustomer(LumensCustomers, v8testing6.augusoft.net) ] from E:/Lumens/app_setup.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/app_setup.cfc \| INIT() ] from E:/Lumens/app_setup.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc \| decodeEntities(/index.cfm?frmMenu=1&method=Certificates.CertificateSearch) ] from E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc \| decodeEntities(frmMenu=1&method=Certificates.CertificateSearch) ] from E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| getRequestIPAddress() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| shouldReInitialize() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| init(v8Testing6) ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	8	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| isCartExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| isCartMerchandiseExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc \| getCertificateType() ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc \| getTemplateCetificateName() ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc \| init(v8Testing6) ] from E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.cfc \| styleExists(v8Testing6, /Customers/v8Testing6) ] from E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/templates/templateModel.cfc \| init() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/templates/templateModel.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/textEdit.cfc \| returnContents(path = SearchforCertificates, datasource = v8Testing6, regionID = 1) ] from E:/Lumens/versions/v81QA/cfc/textEdit.cfc
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Administration/SQL/FeatureConfigurationQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Administration/SQL/MenuQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/AppVariables.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/JavaScripts/NumUtils.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/JavaScripts/ValidateDate.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/JavaScripts/ValidateStudentCertificateRegistration.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/checkPermission.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/fusebox.init.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/globalVariables.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/intercepts.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/nLoadVars.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/plugins/GeneralReportFunction.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/plugins/GlobalFunctions.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/plugins/SimpleSecurity.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81QA/templates/loggedUserDetail.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/udf/logger.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/back-top-desktop.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/back-top-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/banner_slideshow.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/branding-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/cart.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/client-logo-footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/client-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/facebook-pixel.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-analytics.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-tag-manager.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/menu_action.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-footer-buttons.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-social-media.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-user.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/search-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/search.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/footer_section.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-account.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-last-viewed.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-main.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/view/css/style.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
339 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=8) in E:\Lumens\Versions\v81QA\checkPermission.cfm @ 15:56:33.033

SELECT DISTINCT ACA.int_actor_type_id
			FROM tbl_access_control_rules ACR
			INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id
			WHERE
				
					str_fuse_action LIKE ? 
				AND ISNULL(ACA.int_actor_type_id,'')<>''
				AND ACA.bit_allow = 1

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = Certificates.CertificateSearch

FeatureConfigurationQry (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\FeatureConfigurationQry.cfm @ 15:56:33.033

SET NOCOUNT ON

	DECLARE @UsesRefundRequest CHAR(1)

	SET @UsesRefundRequest = 0
	SET @UsesRefundRequest = (
			SELECT 1
			FROM RefundPaymentMethods
			WHERE RefundPaymentMethodID = 7
				AND STATUS = 'A'
			)

	SELECT TOP 1 rg.RegionID
		, rg.NAME
		, rg.Address1
		, rg.Address2
		, rtrim(rg.City) + ', ' + rg.STATE + '  ' + rg.Zip AS CSZ
		, rg.Phone1
		, rg.SiteTitle
		, rg.Footer
		/**/
		, rg.prefooter
		, rg.brandingfooter
		/**/
		, rg.MetaText
		, rg.EmailAux4
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'REGFEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS RegistrationFee
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'DEFERRED_PAYMENT_FEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS deferred_payment_fee
		, fc.*
		, @UsesRefundRequest AS UsesRefundRequest
		, rg.privacy_data_mask_id
		, rg.str_google_verify
		, rg.str_yahoo_verify
		, rg.str_hubspot_portal_id
		, rg.str_hubspot_salog_version
		, rg.str_hubspot_ppa
		, rg.str_genoo_api_key
		, rg.str_genoo_tracking_code
		, rg.TimeZoneHourAdjustment
		/**/
		/**/
		/**/
		, e.str_erp_name
		/**/
		/**/
		, CAST(DecryptByKeyAutoCert(cert_id('LumensCert'), NULL, ec.varbin_erp_password) AS NVARCHAR(500)) AS str_erp_password_decrypted
		/**/
		/**/
		, rg.theURL
		, rg.URLText
		, rg.str_analytics_linked_domains
		, rg.GTMContainerID
		, rg.str_social_media_sharing
		, ec.*
		, (
			SELECT TOP 1 Description
			FROM PaymentMethods
			WHERE PaymentMethodID >= 200
				AND STATUS = 'A'
		) AS str_internal_payment_method_name
	FROM FeatureConfiguration fc
	INNER JOIN Regions rg ON fc.RegionID = rg.RegionID
	LEFT JOIN tbl_erp e ON fc.int_erp_id = e.int_erp_id
	LEFT JOIN tbl_erp_config ec ON ec.str_erp_url <> ''
	WHERE rg.STATUS = 'A'

qryGetRegion (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\globalVariables.cfm @ 15:56:33.033

SELECT regionId,orgID
				FROM featureConfigurationQry
				WHERE baseurl LIKE '%v8testing6.augusoft.net%'

MenuQry (Datasource=v8Testing6, Time=0ms, Records=30) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 15:56:33.033

SET NOCOUNT ON

			SELECT OrgID
				, RegionID
				, MenuItemID
				, MenuItemType
				, MainLevel
				, SubLevel
				
				,MainLevelSortOrder
				, SubLevelSortOrder
				, 
					SiteURL
				
				, AccessLevel
				, IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1
				
				, IsNull(DisplayValue_1, '') AS DisplayValue_1
				, IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2
				, IsNull(DisplayValue_2, '') AS DisplayValue_2
				, Condition
				, LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName
				, m.Label AS UniqueLable
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member')
										/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate to PAC')
										/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"')
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN (str_user_nav_label)
							ELSE str_user_nav_label
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS Label
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(m.Label, 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(m.Label, 'Member', 'Member')
									/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate to PAC')
									/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE m.Label
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN dbo.fun_strip_html((str_user_nav_label))
							ELSE dbo.fun_strip_html(str_user_nav_label)
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS LabelNoHTML 
				
				, ISNULL(int_parent_id,0) as int_parent_id
				, int_sort_order
				, m.UniqueLabel
				, m.bit_default_behavior
			FROM MenuItems m
			LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id
			WHERE STATUS = 'A'
				AND SubCategoryID IS NULL
				AND (
					
						int_actor_type_id = ?
						OR
						(
							int_actor_type_id IS NULL
							AND AccessLevel = ?
						)
					
				)
				
				AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/
				
			ORDER BY int_sort_order

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 90

qGetDashboardName (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 15:56:33.033

SET ANSI_NULLS ON

		SELECT IsNull((
					CASE
						WHEN str_dashboard_name = ''
							THEN NULL
						ELSE str_dashboard_name
						END
					), CASE
					WHEN ActorTypeID = 55
						THEN 'Dashboard'
					ELSE 'my dashboard'
					END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */
		FROM ActorTypes
		WHERE ActorTypeID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

qLearnerfields (Datasource=v8Testing6, Time=0ms, Records=114) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 15:56:33.033

SELECT pfo.int_order
				, pf.str_field_display_name
				, pf.str_field_name
				, pfo.int_profile_field_tab_id
				, pf.str_actor_types
				, pf.chr_field_type
			FROM tbl_profile_field_order pfo
			INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id
			WHERE pf.int_region_id = ?
				AND bit_enabled = ?
				AND
				(
					(
						pf.chr_field_type not in ('C','O')
					)
					
						OR
						(
							pf.chr_field_type in ('C','O') AND
							(
								pf.str_actor_types LIKE ? 
							)
						)
					
				)
			ORDER BY pfo.int_profile_field_tab_id
				, pfo.int_order ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_varchar) = %90%

qsocialNetFieldDetails (Datasource=v8Testing6, Time=0ms, Records=3) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 15:56:33.033

select * from tbl_social_media_details WHERE int_region_id = ?
			order by int_order asc

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qGraphics (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 15:56:33.033

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qUserNavItems (Datasource=v8Testing6, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 15:56:33.033

SELECT menitms.SiteURL AS nav_site_url
			, menitms.label AS nav_label
			, menitms.rowNum
			, COUNT(menitms.rowNum) OVER () AS Total_Rows
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel 
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_nav=1
				AND STATUS = ?
				
	) menitms

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_char) = A

qFooterNavItems (Datasource=v8Testing6, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 15:56:33.033

SELECT menitms.SiteURL
			, menitms.label
			, menitms.AccessLevel
			, menitms.rowNum
			, ((rowNum - 1) / 4) + 1 AS block
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, AccessLevel
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel
			
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_footer=1
				AND STATUS = ?
				
	) menitms

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_char) = A

qryResult (Datasource=v8Testing6, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 15:56:33.033

DECLARE @currentTime DATETIME2 = ?
				UPDATE tbl_cart_class_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;
				UPDATE tbl_cart_merchandise_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 15:56:33.394

			    
			        Parameter #2(cf_sql_varchar) = CDE85E41E901630CE60531A3FBF39390.cfusion

			    
			        Parameter #3(cf_sql_varchar) = CDE85E41E901630CE60531A3FBF39390.cfusion

qryResult (Datasource=v8Testing6, Time=1ms, Records=0) in E:\Lumens\Application.cfc @ 15:56:33.033

DECLARE @expireRequestsAfter DATETIME2 = ?;
						DELETE FROM tbl_cart_class_detail WHERE EnteredDate <= @expireRequestsAfter;
						DELETE FROM tbl_cart_merchandise_detail WHERE EnteredDate <= @expireRequestsAfter;

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 14:56:33.394

variables.custom_scripts (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 15:56:33.033

SELECT str_header_script
				, str_footer_script
			FROM tbl_style_settings WITH (NOLOCK)
			-- WHERE int_region_id = Commented as long as multiple regions are not there

qGraphics (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 15:56:33.033

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qTempMenu (Datasource=, Time=0ms, Records=14) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 15:56:33.033

select * from qTempMenu where MenuItemID NOT IN  (510,630,590,560,562,563,564,565,458,566,567,568,569,571,572,574)

qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 15:56:33.033

select * from qSocialMedia order by int_order desc

qGetDonateUserNavLabel (Datasource=v8Testing6, Time=2ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 15:56:33.033

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 3

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=12) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 6

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 31

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 38

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 41

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 44

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=5) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 47

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 609

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 559

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 561

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 573

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 543

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 549

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 541

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 551

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 503

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 5

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 15:56:33.033

select * from qMenu where int_parent_id = 7

qGetCategory (Datasource=v8Testing6, Time=1ms, Records=18) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 15:56:33.033

SELECT  [CategoryID]
			,[Name] As CategoryName

      		,Name
      		,Description
      		,Status

	FROM [Categories]

	where status = 'A' order by [Name]

qGetSubCategory (Datasource=v8Testing6, Time=4ms, Records=144) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 15:56:33.033

SELECT sc.SubCategoryID,sc.Name,sc.CategoryID FROM SubCategories sc
			INNER JOIN Categories c ON sc.CategoryID = c.CategoryID

qGetcertificateType (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 15:56:33.033

SELECT tct.int_certificate_type_id,tct.str_certificate_type_name FROM tbl_certificate_type tct WHERE tct.chr_status ='A'

qGetCertificateDetails (Datasource=v8Testing6, Time=30ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 15:56:33.033

SET NOCOUNT ON
		DECLARE @name VARCHAR(255)
			, @keyWord VARCHAR(255)
			, @categoryId INT
			, @subcategoryId INT
			, @typeId INT
			, @onlineOnly BIT
			, @certificateId INT
			, @LateRegDays INT
			, @UseProgramSection BIT
			, @UseCertificateGroups BIT
			, @DisplayToPublic BIT
		
			SET @DisplayToPublic = 1;
		

		SELECT DISTINCT CL.DescriptionNoHTML AS description
			, CL.description as descriptionFull
			, CL.*
			, tc.str_certificate_name AS NAME
			, tct.str_certificate_type_name AS typeName
			, tc.str_contact_email
			, st.Email AS Email
			, st.LName
			, st.FName
			, tc.int_courses_required_completion AS ClassesToComplete
			, tc.int_courses_offered AS classCount
			, tc.bit_display_to_public AS bitDisplay
			, tc.bit_allow_public_registration AS bitRegistration
			, tc.str_certificate_no
			, tc.str_url_slug AS CertificateSlug
			, tc.int_certificate_id
			, tc.str_graphic_name
			/**/
			/*Added July 11 2012 Tracker 30411 Neo 00110*/
			, tc.bit_multiple_elective_groups
			/*Added July 11 2012 Tracker 30411 Neo 00110*/
			/* BEGIN: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */
			, tc.bit_use_program_sections AS UseProgramSection
			, '' AS ProgramSectionStartDate
			, '' AS ProgramSectionEndDate
			, '' isAllProgramSectionClassesAvailable
			, tc.bit_use_prerequisite
			, '' AS isProgramSectionSeatsAvailable
			/* END: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */
			, tc.int_certificate_merchandise
			, cl.bit_allow_wcg_registration
			, tc.str_default_text_for_call_message_class
			, tc.bit_use_badges
			, tc.int_badge_integration_id
			, tc.int_badge_integration_template_id
			, tc.str_badge_template_label
			, tc.int_program_version as anthology_int_program_version

			/* Certificate Groups Dangerfield 12/14/2020 */
			, tc.bit_use_certificate_groups AS UseCertificateGroups
			, '' AS CertificateGroupStartDate
			, '' AS CertificateGroupEndDate
			, '' AS isAllCertificateGroupClassesAvailable
			, '' AS isCertificateGroupSeatsAvailable
			, tc.str_special_notice
			/* Certificate Groups Dangerfield 12/14/2020 */
		FROM tbl_class_listing CL
		INNER JOIN tbl_certificates tc ON CL.int_certificate_id = tc.int_certificate_id
			AND tc.chr_status = 'P' AND tc.bit_use_certificate_groups = 0
		/**/
		INNER JOIN tbl_certificate_type tct ON tc.int_certificate_type_id = tct.int_certificate_type_id
		INNER JOIN Staff st ON tc.int_staff_contact_id = st.StaffID
		WHERE CL.str_class_type = 'cf'
			/* BEGIN: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */
			AND ( @UseProgramSection IS NULL OR tc.bit_use_program_sections = 0 )
			/* END: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */
			/* Certificate Groups Dangerfield 12/14/2020 */
				AND ( @UseCertificateGroups IS NULL OR tc.bit_use_certificate_groups = 0)
			/* Certificate Groups Dangerfield 12/14/2020 */
			AND ( @name IS NULL OR tc.str_certificate_name LIKE @name )
			AND (
				@keyWord IS NULL
				OR tc.str_certificate_name LIKE @keyWord
				OR tc.str_description LIKE @keyWord
			)
			AND ( @categoryId IS NULL OR tc.int_category_id = @categoryId )
			AND ( @subcategoryId IS NULL OR tc.int_subcategory_id = @subcategoryId )
			AND ( @typeId IS NULL OR tc.int_certificate_type_id = @typeId )
			AND ( @onlineOnly IS NULL OR tc.bit_online_courses_only = @onlineOnly )
			AND ( @certificateId IS NULL OR tc.int_certificate_id = @certificateId )
			/**/
			AND (
					@LateRegDays IS NULL
					OR
					(
						SELECT count(cl2.ClassID)
						FROM tbl_certificates_classes tcc
						INNER JOIN classes cl2 ON cl2.ClassID = tcc.int_class_id
						WHERE tcc.int_certificate_id = tc.int_certificate_id
							AND cl2.STATUS = 'R'
							AND DATEDIFF(dd, cl2.EndDate, dbo.fun_GetDateCT()) <= @LateRegDays
							AND cl2.EndDate <= dbo.fun_GetDateCT()
					) > 0
				)
			/**/
			AND ( @DisplayToPublic IS NULL OR tc.bit_display_to_public = @DisplayToPublic )
		/* BEGIN: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */
		
		/* END: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */
		/* Certificate Groups Dangerfield 12/14/2020 */
		
		/* Certificate Groups Dangerfield 12/14/2020 */

qGetTemplateCetificateName (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 15:56:33.033

SELECT str_certificate_name FROM FeatureConfiguration

qGetOrganisationPhoneQry (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\model\certificates\act_certificateSearch.cfm @ 15:56:33.033

SET NOCOUNT ON
    	SELECT rg.Phone1
			,rg.Phone1Ext
			,rg.email
    	FROM Regions rg 
    	WHERE rg.RegionID = 1 AND rg.Status = 'A'

qGetText (Datasource=v8Testing6, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\textEdit.cfc @ 15:56:33.033

DECLARE @ContentCondition BIT

				SET @ContentCondition = 1

				SELECT contents.name
					, contents.contents
					, contents.description
					, contents.str_instructor_detail_list
					, isNull(emailType.allowHTML, 1) AS allowHTML
					/**/
					, contents.emailTemplate
					/**/
					, contents.path
					, contents.str_page_title
					, contents.str_meta_description
					, contents.str_keywords
					, contents.section
					, contents.URL
					/**/
					, contents.EmailSubject
					, contents.bit_email_confirmation
					, contents.ContentsNoHTML
					/* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */
					, contents.bit_custom_email_template
					, (SELECT name
						FROM Contents C2
						WHERE C2.ContentID = contents.int_parent_content_id) AS ParentName
					, contents.int_parent_content_id
					/* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */
					, contents.CreateDate
					, contents.ModifyDate
					, IsNull(S1.FName + ' ' + S1.LName,'System') as created_by
					, IsNull(S2.FName + ' ' + S2.LName,'System') as modified_by
					, contents.str_desc_learner_erp_email
					, contents.str_desc_learner_erp_email_nohtml
					, contents.str_desc_learner_no_erp_email
					, contents.str_desc_learner_no_erp_email_nohtml
					, CASE
						WHEN Contents.Path IN ('ForgotPasswordNotice', 'StaffProfile')
							THEN 1
						ELSE 0
					END AS isEmailSubjectEditable
					, CASE
						WHEN 0 = 0 THEN 0
						WHEN (
								Contents.bit_email_confirmation = 1
								OR Contents.bit_learner_class_reminder = 1
								/*OR Contents.bit_instructor_class_reminder = 1*/
							)
							THEN 1
						WHEN Contents.Path LIKE 'ClassEndReminder%'
							OR Contents.Path LIKE 'LearnerTransferClassMerchandiseConfirmation%'
							OR Contents.Path LIKE 'LearnerTransferConfirm%'
							OR Contents.Path LIKE 'LearnerMerchandiseConfirmation%'
							THEN 1
						ELSE 0
						END AS IsConditonalEmailTemplate
					, Contents.str_desc_learner_erp_email
					, Contents.str_desc_learner_no_erp_email
					, Contents.str_test_email_subject
					, Contents.str_test_from_email
					, Contents.str_test_from_name
				FROM Contents
				LEFT JOIN EmailTypeContent ON contents.contentid = EmailTypeContent.contentid
				LEFT JOIN emailType ON EmailTypeContent.emailTypeid = emailType.emailtypeid
				LEFT JOIN Users U1 ON contents.CreateUserID = U1.UserID
				LEFT JOIN Staff S1 ON U1.ActorID = S1.StaffID
				LEFT JOIN Users U2 ON contents.ModifyUserID = U2.UserID
				LEFT JOIN Staff S2 ON U2.ActorID = S2.StaffID
				WHERE @ContentCondition = @ContentCondition
					
						AND Contents.path = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = SearchforCertificates

qryAvailableFields (Datasource=v8Testing6, Time=17ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\templates\templateModel.cfc @ 15:56:33.033

SELECT AvailableFieldID,ContentID,VariableName,VariableDisplay
				FROM AvailableField
				WHERE 
					/* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */
					ContentID = (
									SELECT 
										CASE
											WHEN int_parent_content_id <> 0 THEN int_parent_content_id
											ELSE ContentID
										END AS ContentID
									FROM Contents
									WHERE path = ?
									/* BEGIN: NEO 00091 AI Company Qty Reg Use Cases 2013-02-21 - F04 Date:04 July 2013 */
									AND (ISNULL(int_slim_profile_attribute_id,0) = 0 OR int_slim_profile_attribute_id IN (SELECT int_slim_profile_attribute_id FROM tbl_slim_profile_attributes WHERE bit_required = 1))
									/* END: NEO 00091 AI Company Qty Reg Use Cases 2013-02-21 - F04 Date:04 July 2013 */
								)
					/* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = SearchforCertificates

qgetCertificateElectiveGroups (Datasource=v8Testing6, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 15:56:33.033

SELECT int_certificates_elective_group_id,int_req_no_classes_in_group
			FROM tbl_certificates_elective_groups
			WHERE int_certificate_id=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qGetCertificatePrice (Datasource=v8Testing6, Time=15ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 15:56:33.033

SELECT (isnull((SELECT SUM(flt_class_price)
								FROM tbl_certificates_courses
								WHERE int_certificate_id =?
									AND bit_elective = 0),0)
						) as CertificatePrice

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

Stored Procedures

q_customer_by_domain (Datasource=LumensCustomers, Time=0ms) in E:\Lumens\app_setup.cfc @ 15:56:33.033

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`cf_sql_varchar`	`v8testing6.augusoft.net`

resultsets
`name`	`resultset`
`qCustomer`	`1`

Scope Variables

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=E:\Lumens\index.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=AWSALBAPP-0=_remove_; AWSALBAPP-1=_remove_; AWSALBAPP-2=_remove_; AWSALBAPP-3=_remove_
HTTP_HOST=v8testing6.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm?frmMenu=1&method=Certificates.CertificateSearch
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.100.167
PATH_INFO=
PATH_TRANSLATED=E:\Lumens\index.cfm
QUERY_STRING=frmMenu=1&method=Certificates.CertificateSearch
REMOTE_ADDR=172.31.103.195
REMOTE_HOST=172.31.103.195
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=v8testing6.augusoft.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
AWSALBAPP-0=_remove_
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
LUMPERSIST=DB8E08FFCFE1831975F2ACE081F3497C

Session Variables:
actortypeid=90
addtoken=CFID=19169343&CFTOKEN=3e50c6257af66505-75B1B20C-9AAB-B515-55EADE6BD8045BF6&jsessionid=CDE85E41E901630CE60531A3FBF39390.cfusion
allowunmaskeddata=0
appname=v8Testing6
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.v8Testing6
customerid=494
custompath=/Customers/v8Testing6/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=v8testing6.augusoft.net
ds=v8Testing6
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=216.73.216.101
foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
loggedin=No
loggeduseremail=
loggeduserfname=Guest
loggeduserlname=
membershiptypeid=0
menuid=1
orgid=1
privacypolicyack=
regionid=1
sessionid=CDE85E41E901630CE60531A3FBF39390.cfusion
sitepath=/Customers/v8Testing6
sslreturnurl=https://v8testing6.augusoft.net/
stylesheetpath=/Customers/v8Testing6/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=19169343&CFTOKEN=3e50c6257af66505-75B1B20C-9AAB-B515-55EADE6BD8045BF6&jsessionid=CDE85E41E901630CE60531A3FBF39390.cfusion
version=v81QA

URL Parameters:
frmMenu=1
method=Certificates.CertificateSearch

Debug Rendering Time: 16 ms