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
}
Comments
0 comments
Please sign in to leave a comment.