Search
This is the Search page text template.
Debugging Information
Execution Time
SQL Queries checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=9) in E:\Lumens\Versions\v81QA\checkPermission.cfm @ 07:45:16.016 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) - MenuQry (Datasource=v8Template3, Time=0ms, Records=10) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 07:45:16.016 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) - qGetDashboardName (Datasource=v8Template3, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 07:45:16.016 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) - qLearnerfields (Datasource=v8Template3, Time=0ms, Records=95) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 07:45:16.016 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) - qsocialNetFieldDetails (Datasource=v8Template3, Time=0ms, Records=4) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 07:45:16.016 select * from tbl_social_media_details WHERE int_region_id = ? order by int_order asc Query Parameter Value(s) - qGraphics (Datasource=v8Template3, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 07:45:16.016 select * from UIVariables where RegionID = ? Query Parameter Value(s) - qUserNavItems (Datasource=v8Template3, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 07:45:16.016 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) - qFooterNavItems (Datasource=v8Template3, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 07:45:16.016 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) - q (Datasource=v8Template3, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 07:45:16.016 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) - variables.custom_scripts (Datasource=v8Template3, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 07:45:16.016 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 qTempMenu (Datasource=, Time=0ms, Records=7) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 07:45:16.016 select * from qTempMenu where MenuItemID NOT IN (544,615,2) qGetDonateUserNavLabel (Datasource=v8Template3, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 07:45:16.016 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) - qSocialMediaHeader (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 07:45:16.016 select * from qSocialMedia order by int_order desc qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) - qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qCourseMenu where int_parent_id = ? and MenuItemType = ? and Label <> ? and int_parent_id<>0 Query Parameter Value(s) - qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qMenu where int_parent_id = 515 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qMenu where int_parent_id = 521 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qMenu where int_parent_id = 522 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qMenu where int_parent_id = 5 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qMenu where int_parent_id = 6 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qMenu where int_parent_id = 7 qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 07:45:16.016 select * from qMenu where int_parent_id = 458 CustomizationsQry (Datasource=v8Template3, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\Administration\SQL\CustomizationsQry.cfm @ 07:45:16.016 SELECT OrgID, RegionID, CustomizationID, rtrim(ltrim(FuseAction)) as fuseAction, Status, CASE Status When 'A' Then 'Active' When 'I' Then 'Inactive' END AS StatusDesc, CreateDate, CustomizationName, CustomizationDesc FROM Customizations c WHERE Status = 'A' AND RegionID = 1 Order By Status, Fuseaction ContentsQry (Datasource=v8Template3, Time=15ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\ContentsQry.cfm @ 07:45:16.016 SELECT ContentID , OrgID , RegionID , Section , Path , Contents , ContentsNoHTML , Description , Name , emailTemplate , str_default_condition , str_page_title , str_meta_description , str_keywords FROM Contents WHERE Path = ? AND orgid = ? AND regionid= ? Query Parameter Value(s) - q (Datasource=v8Template3, Time=55ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 07:45:16.016 SELECT asf.str_field_display_name , asf.int_advanced_search_field_id , asf.int_order , CASE asf.chr_field_type WHEN 'S' THEN 'Standard' WHEN 'C' THEN 'Custom' WHEN 'O' THEN 'Optional' END AS str_field_type , asf.str_field_name , asf.bit_is_customized , asf.str_original_field_display_name , asf.int_form_field_type_id , fft.description , CASE WHEN asf.int_form_field_type_id NOT IN (5, 6) THEN CASE WHEN bfc.base_field_id IS NOT NULL THEN ( SELECT JSON_QUERY(CONCAT ( '[' , STRING_AGG(CONCAT ( '"' , str_search_field_value , '"' ), ',') WITHIN GROUP (ORDER BY sort_order) , ']' )) FROM ( SELECT bfcv.str_search_field_value, MIN(bfcv.sort_order) AS sort_order FROM base_field_customized_value bfcv WHERE bfcv.base_field_id = bfc.base_field_id AND bfcv.is_displayed = 1 AND NULLIF(TRIM(bfcv.str_search_field_value),'') IS NOT NULL GROUP BY bfcv.str_search_field_value ) t ) WHEN fc.custom_field_id IS NOT NULL THEN ( SELECT JSON_QUERY(CONCAT ( '[' , STRING_AGG(CONCAT ( '"' , str_search_field_value , '"' ), ',') WITHIN GROUP (ORDER BY sort_order) , ']' )) FROM ( SELECT fcv.str_search_field_value, MIN(fcv.sort_order) AS sort_order FROM field_customized_value fcv WHERE fcv.custom_field_id = fc.custom_field_id AND fcv.is_displayed = 1 AND NULLIF(TRIM(fcv.str_search_field_value),'') IS NOT NULL GROUP BY fcv.str_search_field_value ) t ) END END AS fieldValueOptions FROM tbl_advanced_search_field asf INNER JOIN form_field_type fft ON fft.form_field_type_id = asf.int_form_field_type_id LEFT JOIN base_field_customized bfc ON asf.chr_field_type = 'O' AND bfc.base_field = asf.str_field_name AND bfc.customized_base_field_id IS NULL AND bfc.base_table_id = 2 LEFT JOIN field_customized fc ON fc.custom_field_id = CASE WHEN asf.chr_field_type = 'C' THEN CAST(REPLACE(asf.str_field_name, 'custom_field_', '') AS INT) END WHERE asf.int_region_id = ? AND asf.bit_enabled = ? AND asf.bit_active = 1 AND asf.int_order > 0 ORDER BY CASE WHEN asf.int_order = 0 THEN 1000 * asf.int_default_order ELSE asf.int_order END ASC Query Parameter Value(s) - Content2 (Datasource=v8Template3, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\Contents2Qry.cfm @ 07:45:16.016 SELECT ContentID , OrgID , RegionID , Section , Path , Contents , ContentsNoHTML , Description , Name , emailTemplate , str_default_condition , str_page_title , str_meta_description , str_keywords FROM Contents WHERE Path = ? AND regionid= ? Query Parameter Value(s) - qSocialMediaHeader (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 07:45:16.016 select * from qSocialMedia order by int_order desc 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-3=_remove_; LUMPERSIST=E0075FE374586B25D39EB68851B1CCC4; AWSALBAPP-0=AAAAAAAAAAB7VN21TB/DbU9uWrck1xlJToHjPGNQK3vpSsTLTMiiuW3FsnFwNwOeVuxRm9Vq1H8vr7R6Ri1cbGw2TUURc9IUlcFaHhlT2d80gxU3t83u67v7SI5RpUY07uaDdlpy3dZL+A==; AWSALBAPP-1=_remove_; JSESSIONID=DBD44CA70378C4230CC2004D23930700.cfusion HTTP_HOST=v8template3.augusoft.net HTTP_REFERER= HTTP_URL=/index.cfm?fuseaction=1070 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=fuseaction=1070 REMOTE_ADDR=172.31.102.122 REMOTE_HOST=172.31.102.122 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/index.cfm SERVER_NAME=v8template3.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=AAAAAAAAAAB7VN21TB/DbU9uWrck1xlJToHjPGNQK3vpSsTLTMiiuW3FsnFwNwOeVuxRm9Vq1H8vr7R6Ri1cbGw2TUURc9IUlcFaHhlT2d80gxU3t83u67v7SI5RpUY07uaDdlpy3dZL A AWSALBAPP-1=_remove_ AWSALBAPP-2=_remove_ AWSALBAPP-3=_remove_ JSESSIONID=DBD44CA70378C4230CC2004D23930700.cfusion LUMPERSIST=E0075FE374586B25D39EB68851B1CCC4 Session Variables: actortypeid=90 addtoken=CFID=10154928&CFTOKEN=e423c838cce7aa43-DC57D918-E6D2-EB92-4E864818DE34D6D1&jsessionid=DBD44CA70378C4230CC2004D23930700.cfusion allowunmaskeddata=0 appname=v8Template3 backurl= basecfcs=versions.v81QA basecode=/versions/v81QA bit_canvas_failed_process=false bit_member=0 customcct= customcfcs=Customers.v8Template3 customerid=488 custompath=/Customers/v8Template3/custom debug=0 debugoutput=1 docxdir=DocxHTML domain=v8template3.augusoft.net ds=v8Template3 enabledlivechat=false enabledsupportwidget=false enteredsiteusingipaddress=1 foundeo_firewall_ip=3.137.174.44 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=DBD44CA70378C4230CC2004D23930700.cfusion sitepath=/Customers/v8Template3 sslreturnurl=https://v8template3.augusoft.net/ stylesheetpath=/Customers/v8Template3/StyleSheets/style.css timeoutminutes=60 urltoken=CFID=10154930&CFTOKEN=422d4042f392d336-DC581655-9655-C403-3A0C388B0A80F8F1&jsessionid=DBD44CA70378C4230CC2004D23930700.cfusion version=v81QA URL Parameters: fuseaction=1070Debug Rendering Time: 15 ms |