Display results of complex query in form?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, I need to create a query that seems impossible (or difficult) to express using reports or the advanced find tool, but would be trivially expressed in SQL or C#.

SQL is unavailable for the hosted solution, but is there any way to define a query or somehow to create an EntityCollection and display it in a form?

My best idea is to create a connection that would resemble the datamodel of the query result, and populate it using a Plugin that fires on record retrieval (executing the query and populating that field with the results data before the record is displayed in the form). Would this work, and if so, is this really the easiest way to achieve this?