Debugging Information
| ColdFusion Server Enterprise |
2021,0,21,330446 |
| Template |
/index.cfm |
| Time Stamp |
18-Aug-25 02:14 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.102.63 |
| Host Name |
172.31.102.63 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 482 ms |
482 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequest(/index.cfm) ] from E:/Lumens/Application.cfc |
| 482 ms |
482 ms |
1 |
E:/Lumens/Versions/v81/fusebox4.runtime.cfmx.cfm |
| 482 ms |
482 ms |
1 |
E:/Lumens/Versions/v81/parsed/certificates.certificatesearch.cfm |
| 199 ms |
199 ms |
1 |
E:/Lumens/Versions/v81/view/certificates/dsp_certificateSearch.cfm |
| 173 ms |
173 ms |
1 |
E:/Lumens/Versions/v81/model/certificates/act_certificateSearch.cfm |
| 142 ms |
142 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | getCertificateDetails() ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 110 ms |
110 ms |
1 |
E:/Lumens/Versions/v81/header.cfm |
| 94 ms |
94 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/header_section.cfm |
| 78 ms |
78 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/includes/nav-main.cfm |
| 27 ms |
27 ms |
1 |
E:/Lumens/Versions/v81/view/certificates/dsp_certificate_class_listing_template1.cfm |
| 16 ms |
16 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onSessionStart() ] from E:/Lumens/Application.cfc |
| 16 ms |
16 ms |
1 |
CFC[ E:/Lumens/app_setup.cfc | FindApplicationCustomer(LumensCustomers, testing7.augusoft.net) ] from E:/Lumens/app_setup.cfc |
| 16 ms |
16 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/systemoptions/templates/templateModel.cfc | getAvailableFields(testing7, SearchforCertificates) ] from E:/Lumens/versions/v81/cfc/systemoptions/templates/templateModel.cfc |
| 16 ms |
16 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/includes/nav-banner.cfm |
| 15 ms |
15 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc |
| 15 ms |
15 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | getSubCategory() ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 15 ms |
15 ms |
1 |
E:/Lumens/Versions/v81/Administration/SQL/FeatureConfigurationQry.cfm |
| 15 ms |
15 ms |
1 |
E:/Lumens/Versions/v81/globalVariables.cfm |
| 11 ms |
11 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | GetCertificatePrice(1, 2, 0, 0) ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/Versions/v81/cfc/cart/cart_dao.cfc | INIT(testing7) ] from E:/Lumens/Versions/v81/cfc/cart/cart_dao.cfc |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/ColorUtils.cfc | INIT() ] from E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/ColorUtils.cfc |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | INIT() ] from E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getGraphicsDetails(1) ] from E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getSiteResourcePathDetailsByID(1) ] from E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81/cfc/systemoptions/siteconfiguration/siteconfiguration.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 | processRequest(ip_address = 216.73.216.101) ] 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/v81/cfc/cart/cart.cfc | init(testing7) ] from E:/Lumens/versions/v81/cfc/cart/cart.cfc |
| 0 ms |
0 ms |
8 |
CFC[ E:/Lumens/versions/v81/cfc/cart/cart.cfc | isCartExist() ] from E:/Lumens/versions/v81/cfc/cart/cart.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/cart/cart.cfc | isCartMerchandiseExist() ] from E:/Lumens/versions/v81/cfc/cart/cart.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | GetCertificatePrice(3, 2, 0, 0) ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | getCategory() ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | getCertificateType() ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | getTemplateCetificateName() ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/certificates/certificates.cfc | init(testing7) ] from E:/Lumens/versions/v81/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/merchandise/merchandise.cfc | init(testing7) ] from E:/Lumens/versions/v81/cfc/merchandise/merchandise.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/stylesheet/styleManager.cfc | styleExists(testing7, /customers/testing7) ] from E:/Lumens/versions/v81/cfc/stylesheet/styleManager.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/systemoptions/poweruser/poweruser.cfc | INIT() ] from E:/Lumens/versions/v81/cfc/systemoptions/poweruser/poweruser.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/systemoptions/poweruser/poweruser.cfc | getFooterNavItems() ] from E:/Lumens/versions/v81/cfc/systemoptions/poweruser/poweruser.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/systemoptions/poweruser/poweruser.cfc | getUserNavItems() ] from E:/Lumens/versions/v81/cfc/systemoptions/poweruser/poweruser.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/systemoptions/templates/templateModel.cfc | init() ] from E:/Lumens/versions/v81/cfc/systemoptions/templates/templateModel.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81/cfc/textEdit.cfc | returnContents(path = SearchforCertificates, datasource = testing7, regionID = 1) ] from E:/Lumens/versions/v81/cfc/textEdit.cfc |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/Administration/SQL/MenuQry.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/AppVariables.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/JavaScripts/NumUtils.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/JavaScripts/ValidateDate.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/JavaScripts/ValidateStudentCertificateRegistration.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/checkPermission.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/footer.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/fusebox.init.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/intercepts.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/nLoadVars.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/plugins/GeneralReportFunction.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/plugins/GlobalFunctions.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/plugins/SimpleSecurity.cfm |
| 0 ms |
0 ms |
2 |
E:/Lumens/Versions/v81/templates/loggedUserDetail.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/udf/index.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/udf/logger.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/back-top-desktop.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/back-top-mobile.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/branding-logo.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/cart/act_cart_action.cfm |
| 0 ms |
0 ms |
2 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/cart/cart.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/client-logo-footer.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/client-logo.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/facebook-pixel.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/google-analytics.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/google-tag-manager.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/menu_action.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/nav-footer-buttons.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/nav-social-media.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/nav-user.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/search-mobile.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/shared/includes/search.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/footer_section.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/includes/custom_style.cfm |
| 0 ms |
0 ms |
2 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/includes/nav-account.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/includes/nav-last-viewed.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/vendor/site_templates/template1/includes/nav-mobile.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81/view/css/style.cfm |
| 0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 513 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=8) in E:\Lumens\Versions\v81\checkPermission.cfm @ 14:14:45.045
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=testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81\Administration\SQL\FeatureConfigurationQry.cfm @ 14:14:45.045
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=0) in E:\Lumens\Versions\v81\globalVariables.cfm @ 14:14:45.045
SELECT regionId,orgID
FROM featureConfigurationQry
WHERE baseurl LIKE '%testing7.augusoft.net%'
MenuQry (Datasource=testing7, Time=0ms, Records=10) in E:\Lumens\Versions\v81\Administration\SQL\MenuQry.cfm @ 14:14:45.045
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')
/*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')
/*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=testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81\Administration\SQL\MenuQry.cfm @ 14:14:45.045
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=testing7, Time=0ms, Records=98) in E:\Lumens\versions\v81\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:14:45.045
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=testing7, Time=0ms, Records=3) in E:\Lumens\versions\v81\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:14:45.045
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=testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:14:45.045
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
qUserNavItems (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\versions\V81\cfc\systemoptions\poweruser\poweruser.cfc @ 14:14:45.045
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=testing7, Time=0ms, Records=1) in E:\Lumens\versions\V81\cfc\systemoptions\poweruser\poweruser.cfc @ 14:14:45.045
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=testing7, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 14:14:45.045
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 14:14:45.228
Parameter #2(cf_sql_varchar) = 948D8F511E17AF48143F098650F7FDD5.cfusion
Parameter #3(cf_sql_varchar) = 948D8F511E17AF48143F098650F7FDD5.cfusion
qryResult (Datasource=testing7, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 14:14:45.045
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 13:14:45.228
variables.custom_scripts (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81\header.cfm @ 14:14:45.045
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=testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:14:45.045
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
qTempMenu (Datasource=, Time=0ms, Records=9) in E:\Lumens\Versions\v81\vendor\site_templates\shared\includes\menu_action.cfm @ 14:14:45.045
select * from qTempMenu where MenuItemID NOT IN (612)
qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81\vendor\site_templates\shared\includes\nav-social-media.cfm @ 14:14:45.045
select * from qSocialMedia order by int_order desc
qGetDonateUserNavLabel (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81\header.cfm @ 14:14:45.045
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
qGetDonateUserNavLabel (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81\header.cfm @ 14:14:45.045
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
qGetDonateUserNavLabel (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81\header.cfm @ 14:14:45.045
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\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
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=1) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
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
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 540
qTempMenu (Datasource=, Time=78ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 518
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 500
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 2
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 5
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 6
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 7
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81\vendor\site_templates\template1\includes\nav-main.cfm @ 14:14:45.045
select * from qMenu where int_parent_id = 458
qGetCategory (Datasource=testing7, Time=0ms, Records=3) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
SELECT [CategoryID]
,[Name] As CategoryName
,Name
,Description
,Status
FROM [Categories]
where status = 'A' order by [Name]
qGetSubCategory (Datasource=testing7, Time=15ms, Records=13) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
SELECT sc.SubCategoryID,sc.Name,sc.CategoryID FROM SubCategories sc
INNER JOIN Categories c ON sc.CategoryID = c.CategoryID
qGetcertificateType (Datasource=testing7, Time=0ms, Records=2) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
SELECT tct.int_certificate_type_id,tct.str_certificate_type_name FROM tbl_certificate_type tct WHERE tct.chr_status ='A'
qGetCertificateDetails (Datasource=testing7, Time=142ms, Records=2) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
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 @UseCertificateGroups = 1;
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 */
UNION
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
, tc.bit_multiple_elective_groups
, tc.bit_use_program_sections AS UseProgramSection
, '' AS ProgramSectionStartDate
, '' AS ProgramSectionEndDate
, '' AS isAllProgramSectionClassesAvailable
, tc.bit_use_prerequisite
, '' AS isProgramSectionSeatsAvailable
, 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
, tc.bit_use_certificate_groups AS UseCertificateGroups
, (
SELECT MIN(c.StartDate)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
) AS CertificateGroupStartDate
, (
SELECT MAX(c.EndDate)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
) AS CertificateGroupEndDate
, CASE
WHEN (
SELECT COUNT(c.ClassID)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
) = (
SELECT COUNT(c.ClassID)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
HAVING MAX(c.dat_public_registration_begin) <= dbo.fun_GetDateCT()
AND MIN(c.dat_public_registration_closes) >= dbo.fun_GetDateCT()
)
THEN 1
ELSE 0
END AS isAllCertificateGroupClassesAvailable
, CASE
WHEN (
SELECT COUNT(c.ClassID)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
) = (
SELECT COUNT(c.ClassID)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
WHERE CC.int_remaining_seats > 0
AND CC.int_certificate_id = CL.int_certificate_id
AND CC.int_certificate_group_id = CL.int_certificate_group_id
)
THEN 1
ELSE 0
END AS isCertificateGroupSeatsAvailable
, tc.str_special_notice
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 = 1
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_id = CL.int_certificate_id AND CG.int_certificate_group_id = CL.int_certificate_group_id
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 = 'cg'
AND (
SELECT COUNT(c.ClassID)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
) = (
SELECT COUNT(c.ClassID)
FROM classes c
INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID
INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id
AND CG.int_certificate_group_id = CL.int_certificate_group_id
WHERE CC.int_remaining_seats > 0
AND CC.int_certificate_id = CL.int_certificate_id
AND CC.int_certificate_group_id = CL.int_certificate_group_id
)
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 ( @DisplayToPublic IS NULL OR tc.bit_display_to_public = @DisplayToPublic )
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 tcc.int_certificate_group_id = CL.int_certificate_group_id
AND cl2.STATUS = 'R'
AND DATEDIFF(dd, cl2.EndDate, dbo.fun_GetDateCT()) <= 30
AND cl2.EndDate <= dbo.fun_GetDateCT()
) > 0
)
/* Certificate Groups Dangerfield 12/14/2020 */
qGetTemplateCetificateName (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
SELECT str_certificate_name FROM FeatureConfiguration
qGetOrganisationPhoneQry (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\Versions\v81\model\certificates\act_certificateSearch.cfm @ 14:14:45.045
SET NOCOUNT ON
SELECT rg.Phone1
,rg.Phone1Ext
,rg.email
FROM Regions rg
WHERE rg.RegionID = 1 AND rg.Status = 'A'
qGetText (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81\cfc\textEdit.cfc @ 14:14:45.045
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=testing7, Time=16ms, Records=1) in E:\Lumens\versions\v81\cfc\systemoptions\templates\templateModel.cfc @ 14:14:45.045
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=testing7, Time=11ms, Records=0) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
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=testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
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
qgetCertificateElectiveGroups (Datasource=testing7, Time=0ms, Records=0) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
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) = 3
qGetCertificatePrice (Datasource=testing7, Time=0ms, Records=1) in E:\Lumens\versions\v81\cfc\certificates\certificates.cfc @ 14:14:45.045
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) = 3
Stored Procedures
q_customer_by_domain (Datasource=LumensCustomers, Time=16ms) in E:\Lumens\app_setup.cfc @ 14:14:45.045
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
IN |
cf_sql_varchar |
testing7.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=
HTTP_HOST=testing7.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.102.63
REMOTE_HOST=172.31.102.63
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=testing7.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:
LUMPERSIST=7C298E6CB00C423A0EF98FC1EC2ED438
Session Variables:
actortypeid=90
addtoken=CFID=19167707&CFTOKEN=69bf6f84858bce34-720DABC6-AB73-531D-265834733410FAB2&jsessionid=948D8F511E17AF48143F098650F7FDD5.cfusion
allowunmaskeddata=0
appname=testing7
basecfcs=versions.v81
basecode=/versions/v81
bit_canvas_failed_process=false
bit_member=0
customcct=UA-10864701-2
customcfcs=customers.testing7
customerid=207
custompath=/customers/testing7/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=testing7.augusoft.net
ds=testing7
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=948D8F511E17AF48143F098650F7FDD5.cfusion
sitepath=/customers/testing7
sslreturnurl=https://testing7.augusoft.net/
stylesheetpath=/customers/testing7/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=19167707&CFTOKEN=69bf6f84858bce34-720DABC6-AB73-531D-265834733410FAB2&jsessionid=948D8F511E17AF48143F098650F7FDD5.cfusion
version=v81
URL Parameters:
frmMenu=1
method=Certificates.CertificateSearch
Debug Rendering Time: 418 ms
|
buy 
Donate
Login/Create account
checkout
view cart (