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.reportcardsv4.display_objects.reportcards.main.academics.compareschool.studentprogress_cfm$cf.call(/sites/scReportCardPublic/includes/themes/reportCardsV4/display_objects/reportCards/main/academics/compareschool/studentprogress.cfm:27)
Template: D:\Mura\sites\scReportCardPublic\includes\themes\reportCardsV4\display_objects\reportCards\main\academics\compareschool\studentprogress.cfm
Type: cfml
Column: 0
ID: ??
Line: 10
Raw Trace: sites.screportcardpublic.includes.themes.reportcardsv4.display_objects.reportcards.main.academics.studentprogress_cfm$cf.call(/muraWRM/sites/scReportCardPublic/includes/themes/reportCardsV4/display_objects/reportcards/main/academics/studentProgress.cfm:10)
Template: D:\Mura\sites\scReportCardPublic\includes\themes\reportCardsV4\display_objects\reportcards\main\academics\studentProgress.cfm
Type: cfml
Column: 0
ID: ??
Line: 2783
Raw Trace: content.contentrenderer_cfc$cf.udfCalla(/mura/content/contentRenderer.cfc:2783)
Template: D:\Mura\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 189
Raw Trace: baseobject_cfc$cf.udfCall3(/mura/baseobject.cfc:189)
Template: D:\Mura\core\mura\baseobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 63
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:63)
Template: D:\Mura\core\mura\MuraScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 2713
Raw Trace: content.contentrenderer_cfc$cf.udfCall9(/mura/content/contentRenderer.cfc:2713)
Template: D:\Mura\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:\Mura\core\mura\content\contentRendererUtility.cfc
Type: cfml
Column: 0
ID: ??
Line: 3097
Raw Trace: content.contentrenderer_cfc$cf.udfCallc(/mura/content/contentRenderer.cfc:3097)
Template: D:\Mura\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 189
Raw Trace: baseobject_cfc$cf.udfCall3(/mura/baseobject.cfc:189)
Template: D:\Mura\core\mura\baseobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 63
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:63)
Template: D:\Mura\core\mura\MuraScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 93
Raw Trace: sites.screportcardpublic.includes.themes.reportcardsv4.content_types.page.index_cfm$cf.call(/muraWRM/sites/scReportCardPublic/includes/themes/reportCardsV4/content_types/page/index.cfm:93)
Template: D:\Mura\sites\scReportCardPublic\includes\themes\reportCardsV4\content_types\page\index.cfm
Type: cfml
Column: 0
ID: ??
Line: 1793
Raw Trace: content.contentrenderer_cfc$cf.udfCall5(/mura/content/contentRenderer.cfc:1793)
Template: D:\Mura\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 189
Raw Trace: baseobject_cfc$cf.udfCall3(/mura/baseobject.cfc:189)
Template: D:\Mura\core\mura\baseobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 63
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:63)
Template: D:\Mura\core\mura\MuraScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 164
Raw Trace: sites.screportcardpublic.includes.themes.reportcardsv4.templates.home_cfm$cf.call(/muraWRM/sites/scReportCardPublic/includes/themes/reportCardsV4/templates/home.cfm:164)
Template: D:\Mura\sites\scReportCardPublic\includes\themes\reportCardsV4\templates\home.cfm
Type: cfml
Column: 0
ID: ??
Line: 63
Raw Trace: translator.standardhtmltranslator_cfc$cf.udfCall(/mura/Translator/standardHTMLTranslator.cfc:63)
Template: D:\Mura\core\mura\Translator\standardHTMLTranslator.cfc
Type: cfml
Column: 0
ID: ??
Line: 95
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:95)
Template: D:\Mura\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 36
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall1(/mura/Handler/standardEventsHandler.cfc:36)
Template: D:\Mura\core\mura\Handler\standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1533
Raw Trace: utility_cfc$cf.udfCall8(/mura/utility.cfc:1533)
Template: D:\Mura\core\mura\utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 45
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:45)
Template: D:\Mura\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 316
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall3(/mura/Handler/standardEventsHandler.cfc:316)
Template: D:\Mura\core\mura\Handler\standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1533
Raw Trace: utility_cfc$cf.udfCall8(/mura/utility.cfc:1533)
Template: D:\Mura\core\mura\utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 45
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:45)
Template: D:\Mura\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 973
Raw Trace: content.contentserver_cfc$cf.udfCall2_000095(/mura/content/contentServer.cfc:973)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 965
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:965)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 245
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:245)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 335
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:335)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 790
Raw Trace: content.contentserver_cfc$cf.udfCall2_000067(/mura/content/contentServer.cfc:790)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 786
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:786)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 1
Raw Trace: index_cfm$cf.call(/index.cfm:1)
Template: D:\Mura\index.cfm
Type: cfml