Status Check-In Report

This report historically summarizes entries made via the Status Check-in dashboard module.

Report Definition:

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "6e223a53-99e6-4e3a-85da-01b4f7d4c730",
      "Name": "Check-in Report",
      "UserId": null,
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "00:10:00",
      "Description": "",
      "Parameters": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
          "Name": "Days",
          "Description": "Number of days to show data for",
          "Required": true,
          "Validation": "Double",
          "DefaultValue": "7"
        }
      ],
      "DataSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "TimeStamp",
              "Operation": "Gte",
              "Value": "AddTime(Now(), Days(\"-\" + Memo(\"Days\")))",
              "ObjectValue": null
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Health",
              "Operation": "NotNull",
              "Value": "true",
              "ObjectValue": null
            }
          ],
          "SubQueries": [],
          "MapRule": "",
          "MemoRules": [],
          "Aliases": null,
          "Name": "Notes",
          "Type": "SoftwareIDM.PanelModel.Models.NoteRecord, SoftwareIDM.PanelModel",
          "Limit": null
        }
      ],
      "ReportSets": [],
      "Relations": [],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Health",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Health"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "User",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "UserFriendly"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Message",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Message"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Issue",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Issue"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Timestamp",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "DateTimeFormat(TimeStamp, \"yyyy-MM-dd HH:mm\")"
        }
      ],
      "Transformations": [],
      "Styles": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Health"
          ],
          "ConditionRule": "Health == \"Healthy\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "g",
          "CellColor": "g"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Health"
          ],
          "ConditionRule": "Health == \"Issues\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "o",
          "CellColor": "o"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Health"
          ],
          "ConditionRule": "Health == \"Unhealthy\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "r",
          "CellColor": "r"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Health"
          ],
          "ConditionRule": "Health == \"Critical\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "p",
          "CellColor": "p"
        }
      ],
      "Sort": {
        "Field": "Timestamp",
        "Direction": "Descending"
      }
    }
  ],
  "Count": 1
}