Add support for eager-loading submission properties

[rungta]

What are you trying to do?

We are trying to create a custom view for publishers and reviewers to look at a subset of submissions, and for each submission attempting to access the following:

• submission.owner
• submission.lastReview
• submission.lastReview.element
• submission.lastReview.user.username

This is resulting in many duplicated queries and long page load times. Would be great if there was an option to eager-load one or more of these attributes when calling craft.workflow.submissions().

What's your proposed solution?

Add support for craft.workflow.submissions().with() to eager-load submission attributes.

Additional context

No response

[engram-design]

Sounds fair enough, looking into it!