Using LookedUpFromActivity as relationship causes Apex error for non Admin user

[deejay-hub]

Time Warp version
1.15

Describe the bug
When accessing a task or event configured using LookedUpFromActivity as the object name tand the user does not have viewall data permission you get the error

[deejay-hub]

LookupUpFromActivity object has specific limitations in Salesforce (https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_lookedupfromactivity.htm)

• In the main clause of the relationship query, you can reference only one record. For example, you can’t filter on all records where the account name starts with ‘A’; instead, you must reference a single account record.
• In the inner clause of the query, you can’t use WHERE.
• In the inner clause of the query, you must specify a limit of 500 or fewer on the number of rows that are returned in the list.
• You must sort on ActivityDate in descending order and LastModifiedDate in descending order; you can display nulls last. For example: ORDER BY ActivityDate DESC NULLS LAST, LastModifiedDate DESC.

We are adding the modifications to the SOQL accordingly.