Service Form History

This report displays the results of Service Panel form submissions that are completed and have action steps associated with them.

{
 "Data": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
 "Id": "bf85892e-7643-487b-a4a9-26e9cac1f012",
 "Name": "Service Form History",
 "UserId": null,
 "UserProfile": false,
 "Tags": null,
 "Roles": null,
 "CacheExpiration": "00:05:00",
 "Description": "",
 "Parameters": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.DateReportParameter, SoftwareIDM.ReportingModule",
 "DefaultValue": "",
 "Name": "After",
 "Description": "Time range to search for form submissions",
 "Required": true,
 "Validation": "DateTime"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
 "Name": "Name",
 "Description": "Filter based on form name. Enter '*' for all forms",
 "Required": true,
 "Validation": "",
 "DefaultValue": "*"
 }
 ],
 "DataSets": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
 "Clauses": [
 {
 "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
 "Field": "Created",
 "Operation": "Gte",
 "Value": "CoerceDateTime(Memo(\"After\"))",
 "ObjectValue": null
 }
 ],
 "SubQueries": [],
 "MapRule": "",
 "MemoRules": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.MemoRule, SoftwareIDM.ReportingModule",
 "Name": "Forms",
 "Rule": "Id"
 }
 ],
 "Aliases": null,
 "Name": "Forms",
 "Type": "SoftwareIDM.ServicePanel.Models.ServiceFormState, SoftwareIDM.ServicePanel",
 "Limit": null
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
 "Clauses": [
 {
 "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
 "Field": "ObjectId",
 "Operation": "In",
 "Value": "Memo(\"Forms\")",
 "ObjectValue": null
 }
 ],
 "SubQueries": [],
 "MapRule": "",
 "MemoRules": [],
 "Aliases": null,
 "Name": "Workflows",
 "Type": "SoftwareIDM.WorkflowModel.WorkflowRecord, SoftwareIDM.WorkflowModel",
 "Limit": null
 }
 ],
 "ReportSets": [],
 "Relations": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
 "Name": "Form - Action",
 "LeftSet": "Forms",
 "RightSet": "Workflows",
 "LeftRule": "Id",
 "RightRule": "ObjectId",
 "AllowLeftOuter": false,
 "AllowRightOuter": false
 }
 ],
 "FieldProjections": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
 "Name": "Name",
 "RelationName": "Form - Action",
 "RelationSide": "Left",
 "ValueRule": "Label"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
 "Name": "User",
 "RelationName": "Form - Action",
 "RelationSide": "Left",
 "ValueRule": "UserName"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
 "Name": "Started",
 "RelationName": "Form - Action",
 "RelationSide": "Left",
 "ValueRule": "DateTimeFormat(Created, \"yyyy-MM-dd hh:mm:ss\")"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
 "Name": "Submitted",
 "RelationName": "Form - Action",
 "RelationSide": "Left",
 "ValueRule": "DateTimeFormat(Created, \"yyyy-MM-dd hh:mm:ss\")"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
 "Name": "Data",
 "RelationName": "Form - Action",
 "RelationSide": "Left",
 "ValueRule": "Filter(Flatten(Map(Data, Map(Value, $\"{Key}: {Value}\"))), Not(Contains(context, \"Password\")))"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
 "Name": "Action Result",
 "RelationName": "Form - Action",
 "RelationSide": "Right",
 "ValueRule": "If(Filter(Steps, And(Result, Not(Contains(Result, \"success\")))).Count > 0, \"finished-with-errors\", \"success\")"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
 "Name": "Step Actions",
 "RelationName": "Form - Action",
 "RelationSide": "Right",
 "ValueRule": "Map(Filter(Steps, Result), If(Contains(TypeName(Data), \"Fixture\"), $\"{TimeTraveler(Data.FixtureId)}|{Name}: {Result}\", $\"{Name}: {Result}\"))"
 }
 ],
 "Transformations": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
 "FilterRule": "If(Memo(\"Name\") == \"*\", true, Contains(Data.Name, Memo(\"Name\")))",
 "GroupingRule": "",
 "TransformRules": []
 }
 ],
 "Styles": [
 {
 "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
 "Fields": [
 "Action Result"
 ],
 "ConditionRule": "Contains(Data.Action Result, \"success\")",
 "Bold": false,
 "Italic": false,
 "Hide": false,
 "TextColor": "g",
 "CellColor": "g"
 },
 {
 "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
 "Fields": [
 "Action Result"
 ],
 "ConditionRule": "Not(Contains(Data.Action Result, \"success\"))",
 "Bold": false,
 "Italic": false,
 "Hide": false,
 "TextColor": "r",
 "CellColor": "r"
 }
 ],
 "Sort": {
 "Field": "Submitted",
 "Direction": "Descending"
 }
 }
 ],
 "Count": 1
}