Skip to content

Query: Qry View Purple Panelists Rubric Metric Scores

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • Purple Panelists Scores
  • Rubric Metric Templates
  • Purple Panelists
  • Metrics
  • Purple

Columns Selected

  • Unused
  • [Purple Panelists].[Purple Panel ID]
  • [Purple Panelists Scores].[Purple Panelist ID]
  • [Purple Panelists].[Purple Panelist]
  • [Purple Panelists].[Business Area]
  • [Purple Panelists Scores].[Purple Panelist Score ID]
  • 5*[Metric Weight]
  • Metrics.[Metric ID]
  • Metric
  • Metrics.[Metric Description]
  • [Purple Panelists Scores].[Purple Panelist Score]
  • IIf(IsNull([Purple Panelist Score]) Or [Purple Panelist Score]=0,\
  • [Purple Panelist Score]*[Metric Weight]
  • Metrics.[Sort Order]

Where Clause

((([Purple Panelists Scores].Unused)=False))

Order By

Metrics.[Sort Order]

SQL

SELECT [Purple Panelists Scores].Unused, [Purple Panelists].[Purple Panel ID], [Purple Panelists Scores].[Purple Panelist ID], [Purple Panelists].[Purple Panelist], [Purple Panelists].[Business Area], [Purple Panelists Scores].[Purple Panelist Score ID], 5*[Metric Weight], Metrics.[Metric ID], Metrics.Metric, Metrics.[Metric Description], [Purple Panelists Scores].[Purple Panelist Score], IIf(IsNull([Purple Panelist Score]) Or [Purple Panelist Score]=0,\, [Purple Panelist Score]*[Metric Weight], Metrics.[Sort Order] FROM [Purple Panelists Scores], [Rubric Metric Templates], [Metrics], [Purple Panelists] WHERE ((([Purple Panelists Scores].Unused)=False))