Student Progress

500 Error

Column [subgroup] not found in query

SQL: SELECT m.ReportCardYear ,m.DistrictCd ,m.SchoolCd ,m.SchoolTypeCd ,m.SubGroupIndexNbr ,m.ScoringTypeId ,m.DataTypeNbr ,m.studentprogressPct ,m.studentprogressNbr ,c1.ScoringTypeNm , d.schoolnm FROM [StudentProgress] m inner join ScoringTypesMGMT c1 on m.ScoringTypeId = c1.ScoringTypeId INNER JOIN schools d ON m.schoolcd = d.schoolcd AND m.DistrictCd = d.DistrictCd AND m.ReportCardYear = d.ReportCardYear AND m.schooltypecd = d.schooltypecd WHERE ( ( m.DistrictCd = '1501' AND m.SchoolCd = '006' ) OR ( m.DistrictCd = '1501' AND m.SchoolCd = '012' ) OR ( m.DistrictCd = '1501' AND m.SchoolCd = '021' ) ) AND m.SchoolTypeCd = 'E' AND m.ScoringTypeId in (19,99,18) and m.ReportCardYear = 2018 ORDER By m.ScoringTypeId DESC, d.schoolnm

Code: 0

Type: 0

available columns are [REPORTCARDYEAR, DISTRICTCD, SCHOOLCD, SCHOOLTYPECD, SUBGROUPINDEXNBR, SCORINGTYPEID, DATATYPENBR, STUDENTPROGRESSPCT, STUDENTPROGRESSNBR, SCORINGTYPENM, SCHOOLNM]

---

Column: 0
ID: ??
Line: 27
Raw Trace: sites.screportcardpublic.includes.themes.reportcardsv3.display_objects.reportcards.main.academics.compareschool.studentprogress_cfm$cf.call(/sites/scReportCardPublic/includes/themes/reportCardsV3/display_objects/reportCards/main/academics/compareschool/studentProgress.cfm:27)
Template: D:\www\sites\scReportCardPublic\includes\themes\reportCardsV3\display_objects\reportCards\main\academics\compareSchool\studentProgress.cfm
Type: cfml

---

Column: 0
ID: ??
Line: 10
Raw Trace: sites.screportcardpublic.includes.themes.reportcardsv3.display_objects.reportcards.main.academics.studentprogress_cfm$cf.call(/muraWRM/sites/scReportCardPublic/includes/themes/reportCardsV3/display_objects/reportcards/main/academics/studentProgress.cfm:10)
Template: D:\www\sites\scReportCardPublic\includes\themes\reportCardsV3\display_objects\reportCards\main\academics\studentProgress.cfm
Type: cfml

---

Column: 0
ID: ??
Line: 2817
Raw Trace: content.contentrenderer_cfc$cf.udfCalla(/mura/content/contentRenderer.cfc:2817)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 262
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:262)
Template: D:\www\core\mura\cfobject.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 135
Raw Trace: masascope_cfc$cf.udfCall1(/mura/MasaScope.cfc:135)
Template: D:\www\core\mura\MasaScope.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 2735
Raw Trace: content.contentrenderer_cfc$cf.udfCall9(/mura/content/contentRenderer.cfc:2735)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 88
Raw Trace: content.contentrendererutility_cfc$cf.udfCall1(/mura/content/contentRendererUtility.cfc:88)
Template: D:\www\core\mura\content\contentRendererUtility.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 3090
Raw Trace: content.contentrenderer_cfc$cf.udfCallc(/mura/content/contentRenderer.cfc:3090)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 262
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:262)
Template: D:\www\core\mura\cfobject.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 135
Raw Trace: masascope_cfc$cf.udfCall1(/mura/MasaScope.cfc:135)
Template: D:\www\core\mura\MasaScope.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 93
Raw Trace: sites.screportcardpublic.includes.themes.reportcardsv3.content_types.page.index_cfm$cf.call(/muraWRM/sites/scReportCardPublic/includes/themes/reportCardsV3/content_types/page/index.cfm:93)
Template: D:\www\sites\scReportCardPublic\includes\themes\reportCardsV3\content_types\page\index.cfm
Type: cfml

---

Column: 0
ID: ??
Line: 1856
Raw Trace: content.contentrenderer_cfc$cf.udfCall4_000066(/mura/content/contentRenderer.cfc:1856)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 1759
Raw Trace: content.contentrenderer_cfc$cf.udfCall4(/mura/content/contentRenderer.cfc:1759)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 262
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:262)
Template: D:\www\core\mura\cfobject.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 135
Raw Trace: masascope_cfc$cf.udfCall1(/mura/MasaScope.cfc:135)
Template: D:\www\core\mura\MasaScope.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 158
Raw Trace: sites.screportcardpublic.includes.themes.reportcardsv3.templates.home_cfm$cf.call(/muraWRM/sites/scReportCardPublic/includes/themes/reportCardsV3/templates/home.cfm:158)
Template: D:\www\sites\scReportCardPublic\includes\themes\reportCardsV3\templates\home.cfm
Type: cfml

---

Column: 0
ID: ??
Line: 130
Raw Trace: translator.standardhtmltranslator_cfc$cf.udfCall(/mura/Translator/standardHTMLTranslator.cfc:130)
Template: D:\www\core\mura\Translator\standardHTMLTranslator.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 169
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:169)
Template: D:\www\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 119
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall1(/mura/Handler/standardEventsHandler.cfc:119)
Template: D:\www\core\mura\Handler\standardEventsHandler.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 1415
Raw Trace: utility_cfc$cf.udfCall7(/mura/utility.cfc:1415)
Template: D:\www\core\mura\utility.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 119
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:119)
Template: D:\www\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 454
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall3(/mura/Handler/standardEventsHandler.cfc:454)
Template: D:\www\core\mura\Handler\standardEventsHandler.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 1415
Raw Trace: utility_cfc$cf.udfCall7(/mura/utility.cfc:1415)
Template: D:\www\core\mura\utility.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 119
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:119)
Template: D:\www\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 915
Raw Trace: content.contentserver_cfc$cf.udfCall2_000080(/mura/content/contentServer.cfc:915)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 907
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:907)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 294
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:294)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 380
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:380)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 786
Raw Trace: content.contentserver_cfc$cf.udfCall2_000060(/mura/content/contentServer.cfc:786)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 782
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:782)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml

---

Column: 0
ID: ??
Line: 75
Raw Trace: index_cfm$cf.call(/index.cfm:75)
Template: D:\www\index.cfm
Type: cfml