Portal Approvals Report

This report shows a time filtered view of portal approval objects and indicates whether the request was approved or rejected and by whom.

3.4 or Newer

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "bda542de-49d2-4dbe-b123-0fde50b179d3",
      "Name": "Portal Approvals",
      "UserId": null,
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "01:00:00",
      "Description": "Approvals requested in a given time range",
      "Parameters": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
          "Name": "Days",
          "Description": "",
          "Required": true,
          "Validation": "Double",
          "DefaultValue": "7"
        }
      ],
      "DataSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [],
          "SubQueries": [],
          "MapRule": "",
          "MemoRules": [
            {
              "$type": "SoftwareIDM.ReportingModule.Models.MemoRule, SoftwareIDM.ReportingModule",
              "Name": "Target",
              "Rule": "Target"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.MemoRule, SoftwareIDM.ReportingModule",
              "Name": "Requestor",
              "Rule": "Requestor"
            },
            {
              "$type": "SoftwareIDM.ReportingModule.Models.MemoRule, SoftwareIDM.ReportingModule",
              "Name": "Actor",
              "Rule": "ComputedActor"
            }
          ],
          "Aliases": null,
          "Name": "Approval",
          "Type": "SoftwareIDM.SyncModel.PortalApproval, SoftwareIDM.SyncModel"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Id",
              "Operation": "In",
              "Value": "Memo(\"Requestor\")"
            }
          ],
          "SubQueries": [],
          "MapRule": "",
          "MemoRules": [],
          "Aliases": null,
          "Name": "Requestor",
          "Type": "SoftwareIDM.SyncModel.PortalRecord, SoftwareIDM.SyncModel"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Id",
              "Operation": "In",
              "Value": "Memo(\"Target\")"
            }
          ],
          "SubQueries": [],
          "MapRule": "",
          "MemoRules": [],
          "Aliases": null,
          "Name": "Target",
          "Type": "SoftwareIDM.SyncModel.PortalRecord, SoftwareIDM.SyncModel"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Id",
              "Operation": "In",
              "Value": "Flatten(Memo(\"Actor\"))"
            }
          ],
          "SubQueries": [],
          "MapRule": "",
          "MemoRules": [],
          "Aliases": null,
          "Name": "Actor",
          "Type": "SoftwareIDM.SyncModel.PortalRecord, SoftwareIDM.SyncModel"
        }
      ],
      "ReportSets": [],
      "Relations": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
          "Name": "Approval - Requestor",
          "LeftSet": "Approval",
          "RightSet": "Requestor",
          "LeftRule": "Requestor",
          "RightRule": "Id",
          "AllowLeftOuter": false,
          "AllowRightOuter": true
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
          "Name": "Approval - Target",
          "LeftSet": "Approval",
          "RightSet": "Target",
          "LeftRule": "Target",
          "RightRule": "Id",
          "AllowLeftOuter": false,
          "AllowRightOuter": true
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
          "Name": "Approval - Actor",
          "LeftSet": "Approval",
          "RightSet": "Actor",
          "LeftRule": "ComputedActor",
          "RightRule": "Id",
          "AllowLeftOuter": false,
          "AllowRightOuter": true
        }
      ],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Id",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "$\"{TimeTraveler(Id, null, context)}|{Id}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Request Name",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "$\"{WebHost()}/object/{Request}/SoftwareIDM.SyncModel.PortalRequest%2C%20SoftwareIDM.SyncModel|{DisplayName}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "CreatedTime",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "DateTimeFormat(CreatedTime, \"MM-dd-yyyy HH:mm\")"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Status",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "Status"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Requestor",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Right",
          "ValueRule": "$\"{TimeTraveler(Id, null, context)}|{Attributes.DisplayName}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Target",
          "RelationName": "Approval - Target",
          "RelationSide": "Right",
          "ValueRule": "$\"{TimeTraveler(Id, null, context)}|{Attributes.DisplayName}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Approver",
          "RelationName": "Approval - Actor",
          "RelationSide": "Right",
          "ValueRule": "$\"{TimeTraveler(Id, null, context)}|{Attributes.DisplayName}\""
        }
      ],
      "Transformations": [],
      "Styles": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Status"
          ],
          "ConditionRule": "Status == \"Approved\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "g",
          "CellColor": "g"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Status"
          ],
          "ConditionRule": "Status == \"Rejected\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "r",
          "CellColor": "r"
        }
      ],
      "Sort": {
        "Field": "",
        "Direction": "Ascending"
      }
    }
  ],
  "Count": 1
}

3.2 to 3.3

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "bda542de-49d2-4dbe-b123-0fde50b179d3",
      "Name": "Portal Approvals",
      "UserId": null,
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "01:00:00",
      "Description": "Approvals requested in a given time range",
      "Parameters": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
          "Name": "Days",
          "Description": "",
          "Required": true,
          "Validation": "Double",
          "DefaultValue": "7"
        }
      ],
      "DataSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Aliases": null,
          "MapRule": "",
          "Name": "Approval",
          "Type": "SoftwareIDM.SyncModel.PortalApproval, SoftwareIDM.SyncModel",
          "Clauses": [],
          "SubQueries": []
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Aliases": null,
          "MapRule": "",
          "Name": "Requestor",
          "Type": "SoftwareIDM.SyncModel.PortalRecord, SoftwareIDM.SyncModel",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Id",
              "Operation": "In",
              "Value": "Map(Memo(\"Approval\"), Requestor)"
            }
          ],
          "SubQueries": []
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Aliases": null,
          "MapRule": "",
          "Name": "Target",
          "Type": "SoftwareIDM.SyncModel.PortalRecord, SoftwareIDM.SyncModel",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Id",
              "Operation": "In",
              "Value": "Map(Memo(\"Approval\"), Target)"
            }
          ],
          "SubQueries": []
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Aliases": null,
          "MapRule": "",
          "Name": "Actor",
          "Type": "SoftwareIDM.SyncModel.PortalRecord, SoftwareIDM.SyncModel",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Id",
              "Operation": "In",
              "Value": "Flatten(Map(Memo(\"Approval\"), ComputedActor))"
            }
          ],
          "SubQueries": []
        }
      ],
      "ReportSets": [],
      "Relations": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
          "Name": "Approval - Requestor",
          "LeftSet": "Approval",
          "RightSet": "Requestor",
          "LeftRule": "Requestor",
          "RightRule": "Id",
          "AllowLeftOuter": false,
          "AllowRightOuter": true
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
          "Name": "Approval - Target",
          "LeftSet": "Approval",
          "RightSet": "Target",
          "LeftRule": "Target",
          "RightRule": "Id",
          "AllowLeftOuter": false,
          "AllowRightOuter": true
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
          "Name": "Approval - Actor",
          "LeftSet": "Approval",
          "RightSet": "Actor",
          "LeftRule": "ComputedActor",
          "RightRule": "Id",
          "AllowLeftOuter": false,
          "AllowRightOuter": true
        }
      ],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Id",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "$\"{TimeTraveler(Id, null, context)}|{Id}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Request Name",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "$\"{WebHost()}/object/{Request}/SoftwareIDM.SyncModel.PortalRequest%2C%20SoftwareIDM.SyncModel|{DisplayName}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "CreatedTime",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "DateTimeFormat(CreatedTime, \"MM-dd-yyyy HH:mm\")"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Status",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Left",
          "ValueRule": "Status"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Requestor",
          "RelationName": "Approval - Requestor",
          "RelationSide": "Right",
          "ValueRule": "$\"{WebHost()}/object/{Id}|{Attributes.DisplayName}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Target",
          "RelationName": "Approval - Target",
          "RelationSide": "Right",
          "ValueRule": "$\"{WebHost()}/object/{Id}|{Attributes.DisplayName}\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Approver",
          "RelationName": "Approval - Actor",
          "RelationSide": "Right",
          "ValueRule": "$\"{WebHost()}/object/{Id}|{Attributes.DisplayName}\""
        }
      ],
      "Transformations": [],
      "Styles": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Status"
          ],
          "ConditionRule": "Status == \"Approved\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "g",
          "CellColor": "g"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Status"
          ],
          "ConditionRule": "Status == \"Rejected\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "r",
          "CellColor": "r"
        }
      ],
      "Sort": {
        "Field": "",
        "Direction": "Ascending"
      }
    }
  ],
  "Count": 1
}