<fetch>
  <entity name="xrm1_review_detail">
    <attribute name="xrm1_name" />
    <attribute name="xrm1_details" />
    <attribute name="xrm1_comment" />
    <attribute name="xrm1_rating" />
    <attribute name="statuscode" />
    <filter>
      <condition attribute="xrm1_review_detail_review_id" operator="eq" value="[RECORDID]" />
    </filter>
    <link-entity name="xrm1_review" from="xrm1_reviewid" to="xrm1_review_detail_review_id" />
  </entity>
</fetch>

[
    {
        "@odata.etag": "W/\"4759237\"",
        "xrm1_name": "Operationalise GDPR system improvements",
        "xrm1_details": "Operationalise GDPR system improvements \n-\tDeliver Outlook personal data tagging for emails \n-\tEvaluate Compliance Manager in microsoft 365 and recommend /implement features to strengthen our GDPR compliance position\n-\tContent search for personal data and build an index, and maintain going forward",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "20f7fb49-d91f-ed11-b83e-0022489438c3"
    },
    {
        "@odata.etag": "W/\"4759271\"",
        "xrm1_name": "Project Process improvements",
        "xrm1_details": "Project Process ongoing monitoring, coordinating and delivering efficiencies with the Process Champions working group, improving processes where required, optimizing the use of Nimbus where it makes sense such as developing a operations manual for property managers and corporate service providers ",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "3654ee76-d91f-ed11-b83e-0022489438c3"
    },
    {
        "@odata.etag": "W/\"4759276\"",
        "xrm1_name": "Deliver HR solution for objective setting and absence requests.",
        "xrm1_details": "Deliver HR solution for objective setting and absence requests.",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "4ce3dac9-d91f-ed11-b83e-0022489438c3"
    },
    {
        "@odata.etag": "W/\"4759317\"",
        "xrm1_name": "Manage risks effectively",
        "xrm1_details": "Agree global technology risk management register and ensure risks are managed on going basis",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "7ff273f6-d91f-ed11-b83e-0022489438c3"
    },
    {
        "@odata.etag": "W/\"5639679\"",
        "xrm1_name": "SIRE – Ensure the successful transfer of system to and costs",
        "xrm1_details": "SIRE – Ensure the successful transfer of  system to and costs are no longer on  where applicable. Ensure is able to continue to usefor finance and asset management for . corporate budget met and some cost savings made. ",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "afa8a3f2-7f40-4715-a116-010a40709e5b"
    },
    {
        "@odata.etag": "W/\"5639703\"",
        "xrm1_name": "– Review alternatives to - REMOVE",
        "xrm1_details": "– Review alternatives to for fund and asset management reporting, tenant opportunities tracking, tenant relationship management features. Possible alternatives include lease and deal manager or build our own solution",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "801b71a1-b509-4e3e-8076-132cb29199a3"
    },
    {
        "@odata.etag": "W/\"5639676\"",
        "xrm1_name": " Implement on going improvements to ",
        "xrm1_details": "– Implement on going improvements to including (but not limited to):\n-\reporting \n-\tAP workflows \n-\tRoll out in Denmark, Portugal, Italy\n-\tReview existing country use of  and improve\nOther improvements are stated on the document. These improvements will form the project during FY23",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "a31f111b-c166-4d6c-a339-467e62efd3d5"
    },
    {
        "@odata.etag": "W/\"5639697\"",
        "xrm1_name": "Optimise global security platform",
        "xrm1_details": "  Optimise global security platform by:\n•\tUser access reviews internal \n•\tExternal user access review and conditional access (access to documents)\n•\tRoll out corporate phones initiative to secure IP and data leakage\n•\tConduct a systems audit for year end \n•\tAssess cyber intrusion and early detection /warning solution \n•\tAssess SEIM logging solution for full audit trail of cyber attacks",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "f1a63537-6490-4599-97c5-5fb10a0f29be"
    },
    {
        "@odata.etag": "W/\"5639705\"",
        "xrm1_name": "SIRE - Automate time consuming manual processes",
        "xrm1_details": "SIRE - Automate time consuming manual processes particularly approvals using Microsoft 365 Power platform where cost vs benefit and value makes sense. Some Identified processes to be automated are:\n•\tArrears reporting \n•\tLease data on boarding for acquisitions (TBC with KP)\n•\tDeal to asset management and finance handover \n•\tFunds management dashboard to manage workflow/tasks/asset data (TBC with KP)\n•\tAUM reporting\n•\tPipeline management ",
        "[email protected]": "Draft",
        "statuscode": 693100000,
        "xrm1_review_detailid": "a95afc79-5bdc-479c-a5f2-7da580492b87"
    }
]

[
    {
        "key": "xrm1_name",
        "fieldName": "xrm1_name",
        "name": "Name",
        "minWidth": 100,
        "maxWidth": 300
    },
    {
        "key": "xrm1_review_detail",
        "fieldName": "xrm1_review_details",
        "name": "Review Details",
        "minWidth": 100,
        "maxWidth": 300
    },
    {
        "key": "xrm1_comment",
        "fieldName": "xrm1_comment",
        "name": "Comment",
        "minWidth": 100,
        "maxWidth": 300
    },
    {
        "key": "xrm1_rating",
        "fieldName": "xrm1_rating",
        "name": "Rating",
        "minWidth": 100,
        "maxWidth": 200
    }
]