db={"principals":[{"_id":"18fbab53-b119-43ea-aba0-140997265460","identity":{"_id":"test@abc.com","type":"Email"},"type":"User","links":[{"linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","status":"Activated","createdOn":{"$date":"2022-08-10T13:07:54.846Z"},"createdBy":""}],"principalCount":0,"roles":[{"_id":"f2bde9a2-c693-4461-b479-60710448ad12","name":"Dell/AuthZ/App Admin","type":"IAM","isCascaded":true,"isInternal":true,"sourceType":"Direct","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","createdOn":{"$date":"2022-08-17T13:33:46.936Z"},"updatedOn":{"$date":"2022-08-17T13:33:46.936Z"}},{"_id":"2ecb4039-645b-470e-bf1a-d72f6668e305","name":"Dell/AuthZ/Org Admin","type":"IAM","isCascaded":true,"isInternal":false,"sourceType":"Direct","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","createdOn":{"$date":"2022-08-17T14:56:00.538Z"},"updatedOn":{"$date":"2022-08-17T14:56:00.538Z"}},{"_id":"06e349d9-56b5-44ea-8ab0-60454f06fad6","name":"Two permissions","type":"Builtin","isCascaded":true,"isInternal":true,"sourceType":"Group","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","groupId":"e6431f5a-285d-45fa-b53a-2e7205b2e8b4","createdOn":{"$date":"2022-08-17T16:37:27.331Z"},"updatedOn":{"$date":"2022-08-17T16:37:27.331Z"}},{"_id":"261f8bb5-b914-461f-83cc-7cd7eaf0bc79","name":"Test3 Role","type":"Builtin","isCascaded":true,"isInternal":true,"sourceType":"Group","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","groupId":"e6431f5a-285d-45fa-b53a-2e7205b2e8b4","createdOn":{"$date":"2022-08-17T16:37:27.331Z"},"updatedOn":{"$date":"2022-08-17T16:37:27.331Z"}},{"_id":"276e8906-3e96-4b33-893f-42b3247cd0ec","name":"test123123","type":"Builtin","isCascaded":false,"isInternal":false,"rolePermissions":[],"sourceType":"Direct","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","groupId":"e6431f5a-285d-45fa-b53a-2e7205b2e8b4","createdOn":{"$date":"2022-08-17T16:37:27.331Z"},"updatedOn":{"$date":"2022-08-17T16:37:27.331Z"}},{"_id":"3ccc216e-81cb-4735-9dd9-6d65dc5b7176","name":"one permission","type":"Builtin","isCascaded":false,"isInternal":false,"rolePermissions":[{"appId":"0923689a-e009-4d67-8db5-5ba40f840bf3","appName":"AuthZteam testApp","permissions":[{"_id":"3bf80eba-0607-4856-9181-cfabe58ccc7f","name":"First Custom Permission!"}]}],"sourceType":"Group","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","groupId":"e6431f5a-285d-45fa-b53a-2e7205b2e8b4","createdOn":{"$date":"2022-08-17T16:37:27.331Z"},"updatedOn":{"$date":"2022-08-17T16:37:27.331Z"}},{"_id":"4d636e49-7e0e-4494-988c-c622a6e7abd5","name":"asdfasdfasdf","type":"Builtin","isCascaded":false,"isInternal":false,"sourceType":"Group","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","groupId":"e6431f5a-285d-45fa-b53a-2e7205b2e8b4","createdOn":{"$date":"2022-08-17T16:37:27.331Z"},"updatedOn":{"$date":"2022-08-17T16:37:27.331Z"}}],"memberOfGroups":[{"_id":"e6431f5a-285d-45fa-b53a-2e7205b2e8b4","name":"POST w/Users & Role","appId":"0923689a-e009-4d67-8db5-5ba40f840bf3","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","createdOn":{"$date":"2022-08-17T16:37:27.331Z"},"updatedOn":{"$date":"2022-08-17T16:37:27.331Z"}}]}]}

db.principals.update({_id:"18fbab53-b119-43ea-aba0-140997265460"},[{"$set":{"roles":{"$ifNull":["$roles",[]]}}},{"$set":{"roles":{"$cond":[{"$eq":[{"$filter":{"input":"$roles","cond":{"$and":[{"$eq":["$$this._id","276e8906-3e96-4b33-893f-42b3247cd0ec"]},{"$eq":["$$this.linkPath","0923689a-e009-4d67-8db5-5ba40f840bf3"]},{"$eq":["$$this.sourceType","Group"]}]}}},[]]},{"$concatArrays":["$roles",[{"_id":"276e8906-3e96-4b33-893f-42b3247cd0ec","name":"test123123","type":"Builtin","isCascaded":false,"isInternal":false,"rolePermissions":[],"sourceType":"Group","linkType":"App","linkPath":"0923689a-e009-4d67-8db5-5ba40f840bf3","createdOn":ISODate("2022-08-17T17:11:06.133Z"),"updatedOn":ISODate("2022-08-17T17:11:06.133Z")}]]},"$roles"]}}}])