MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
74 stars 22 forks source link

[Feature Request] Support deletion of activitypointer records in PrincipalObjectAccess table #540

Closed alen1979 closed 1 month ago

alen1979 commented 2 months ago

Hi Mark,

I love your tool!

At the moment we are using it to delete historic entries from the PrincipalObjectAccess table. When running deletes against records where the entity is ActivtyPointer following error is raised:

The 'RevokeAccess' method does not support entities of type 'activitypointer'. MessageProcessorCache returned MessageProcessor.Empty.

RevokeAccess should work for the underlying Activities types though (i.e. Email, Appointment, PhoneCall, etc).

Would it be possible to add some logic to handle this in Sql4CDS? I.e. find out which ActivityType is involved and then using that type for the RevokeAcess call?

Many thanks Alen