Debugging Information
| ColdFusion Server Enterprise |
2021,0,21,330446 |
| Template |
/index.cfm |
| Time Stamp |
18-Aug-25 02:13 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 |
| 541 ms |
541 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequest(/index.cfm) ] from E:/Lumens/Application.cfc |
| 541 ms |
541 ms |
1 |
E:/Lumens/Versions/v81QA/fusebox4.runtime.cfmx.cfm |
| 490 ms |
490 ms |
1 |
E:/Lumens/Versions/v81QA/parsed/certificates.certificatesearch.cfm |
| 187 ms |
187 ms |
1 |
E:/Lumens/Versions/v81QA/model/certificates/act_certificateSearch.cfm |
| 141 ms |
141 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc | getCertificateDetails() ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc |
| 47 ms |
47 ms |
1 |
E:/Lumens/Versions/v81QA/header.cfm |
| 32 ms |
32 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc |
| 31 ms |
31 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/header_section.cfm |
| 31 ms |
31 ms |
1 |
E:/Lumens/Versions/v81QA/view/certificates/dsp_certificateSearch.cfm |
| 31 ms |
31 ms |
1 |
E:/Lumens/Versions/v81QA/view/certificates/dsp_certificate_class_listing_template1.cfm |
| 16 ms |
8 ms |
2 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getGraphicsDetails(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 16 ms |
16 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.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 |
CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc | GetCertificatePrice(2, 1, 0, 0) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc |
| 16 ms |
16 ms |
1 |
E:/Lumens/Versions/v81QA/globalVariables.cfm |
| 16 ms |
16 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-main.cfm |
| 15 ms |
15 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc | GetCertificatePrice(18, 1, 0, 0) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc |
| 15 ms |
15 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc | getCategory() ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc |
| 15 ms |
15 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc | INIT(v8Testing4) ] 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 |
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/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 | 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(v8Testing4) ] 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 | GetCertificatePrice(10, 1, 0, 0) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc | GetCertificatePrice(12, 2, 0, 0) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc | GetCertificatePrice(3, 1, 0, 0) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.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 | getSubCategory() ] 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/certificates/certificates.cfc | init(v8Testing4) ] from E:/Lumens/versions/v81QA/cfc/certificates/certificates.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc | init(v8Testing4) ] from E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/templates/templateModel.cfc | getAvailableFields(v8Testing4, SearchforCertificates) ] from E:/Lumens/versions/v81QA/cfc/systemoptions/templates/templateModel.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 = v8Testing4, regionID = 1) ] from E:/Lumens/versions/v81QA/cfc/textEdit.cfc |
| 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/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/index.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/branding-logo.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 |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/custom_style.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-banner.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-mobile.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/view/css/style.cfm |
| 0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 573 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 @ 14:13:44.044
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
MenuQry (Datasource=v8Testing4, Time=0ms, Records=10) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=100) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=5) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:13:44.044
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=v8Testing4, Time=16ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:13:44.044
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
qUserNavItems (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 14:13:44.044
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:13:44.473
Parameter #2(cf_sql_varchar) = 578CB9866F4F389C57EBD03A39483F20.cfusion
Parameter #3(cf_sql_varchar) = 578CB9866F4F389C57EBD03A39483F20.cfusion
variables.custom_scripts (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:13:44.044
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\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 14:13:44.044
select * from qTempMenu where MenuItemID NOT IN (510)
qSocialMediaHeader (Datasource=, Time=0ms, Records=5) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 14:13:44.044
select * from qSocialMedia order by int_order desc
qGetDonateUserNavLabel (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 14:13:44.044
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 @ 14:13:44.044
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=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
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=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
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) = 11
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 @ 14:13:44.044
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) = 16
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
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) = 19
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 @ 14:13:44.044
select * from qMenu where int_parent_id = 525
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
select * from qMenu where int_parent_id = 606
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
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 @ 14:13:44.044
select * from qMenu where int_parent_id = 2
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
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 @ 14:13:44.044
select * from qMenu where int_parent_id = 6
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
select * from qMenu where int_parent_id = 7
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:13:44.044
select * from qMenu where int_parent_id = 458
qGetCategory (Datasource=v8Testing4, Time=15ms, Records=12) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13:44.044
SELECT [CategoryID]
,[Name] As CategoryName
,Name
,Description
,Status
FROM [Categories]
where status = 'A' order by [Name]
qGetSubCategory (Datasource=v8Testing4, Time=0ms, Records=102) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13:44.044
SELECT sc.SubCategoryID,sc.Name,sc.CategoryID FROM SubCategories sc
INNER JOIN Categories c ON sc.CategoryID = c.CategoryID
qGetcertificateType (Datasource=v8Testing4, Time=0ms, Records=3) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13:44.044
SELECT tct.int_certificate_type_id,tct.str_certificate_type_name FROM tbl_certificate_type tct WHERE tct.chr_status ='A'
qGetCertificateDetails (Datasource=v8Testing4, Time=141ms, Records=5) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13:44.044
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()) <= 600
AND cl2.EndDate <= dbo.fun_GetDateCT()
) > 0
)
/* Certificate Groups Dangerfield 12/14/2020 */
qGetTemplateCetificateName (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13:44.044
SELECT str_certificate_name FROM FeatureConfiguration
qGetOrganisationPhoneQry (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\model\certificates\act_certificateSearch.cfm @ 14:13:44.044
SET NOCOUNT ON
SELECT rg.Phone1
,rg.Phone1Ext
,rg.email
FROM Regions rg
WHERE rg.RegionID = 1 AND rg.Status = 'A'
qGetText (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\textEdit.cfc @ 14:13:44.044
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=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\templates\templateModel.cfc @ 14:13:44.044
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=v8Testing4, Time=15ms, Records=0) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13:44.044
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) = 18
qGetCertificatePrice (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13:44.044
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) = 18
qgetCertificateElectiveGroups (Datasource=v8Testing4, Time=16ms, Records=0) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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) = 2
qGetCertificatePrice (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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) = 2
qgetCertificateElectiveGroups (Datasource=v8Testing4, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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) = 10
qGetCertificatePrice (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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) = 10
qgetCertificateElectiveGroups (Datasource=v8Testing4, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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) = 12
qGetCertificatePrice (Datasource=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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) = 12
qgetCertificateElectiveGroups (Datasource=v8Testing4, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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=v8Testing4, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\certificates\certificates.cfc @ 14:13: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
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-2=_remove_; AWSALBAPP-1=_remove_; JSESSIONID=578CB9866F4F389C57EBD03A39483F20.cfusion; AWSALBAPP-3=_remove_; AWSALBAPP-0=AAAAAAAAAADvFo6m0hWCcMbzhLjwwvw8S3nwHK4jLk8AIox/mfyD4X2jKF9TtbNG/e+HWD02b5qFc7U9o+kyTfYAHS3p21hkKHmbCPD79kMtdyNuMw/sHTzGiRzZNhQMlvnF3zNBLNspDw==; LUMPERSIST=FD3CADEE1F4BB82D325A2AB3B773C6BD
HTTP_HOST=v8testing4.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=v8testing4.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=AAAAAAAAAADvFo6m0hWCcMbzhLjwwvw8S3nwHK4jLk8AIox/mfyD4X2jKF9TtbNG/e HWD02b5qFc7U9o kyTfYAHS3p21hkKHmbCPD79kMtdyNuMw/sHTzGiRzZNhQMlvnF3zNBLNspDw
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
JSESSIONID=578CB9866F4F389C57EBD03A39483F20.cfusion
LUMPERSIST=FD3CADEE1F4BB82D325A2AB3B773C6BD
Session Variables:
actortypeid=90
addtoken=CFID=19167685&CFTOKEN=a8e21fe2cbc9d3b2-72045249-E21B-11D1-1728717FD1BDA113&jsessionid=578CB9866F4F389C57EBD03A39483F20.cfusion
allowunmaskeddata=0
appname=v8Testing4
backurl=
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=G-4M453VEXL9
customcfcs=Customers.v8Testing4
customerid=492
custompath=/Customers/v8Testing4/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=v8testing4.augusoft.net
ds=v8Testing4
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=578CB9866F4F389C57EBD03A39483F20.cfusion
sitepath=/Customers/v8Testing4
sslreturnurl=https://v8testing4.augusoft.net/
stylesheetpath=/Customers/v8Testing4/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=19167687&CFTOKEN=d98918c84ffc5b2f-72047C0C-F56C-6C0E-7F08F94EA159543B&jsessionid=578CB9866F4F389C57EBD03A39483F20.cfusion
version=v81QA
URL Parameters:
frmMenu=1
method=Certificates.CertificateSearch
Debug Rendering Time: 15 ms
|
buy 
Donate
Login/Create account
checkout
view cart (
