Getting Started With Seal Report: Mapping Restrictions to SQL User-Defined Functions

This is the sixth post in the series. It is quite common that restrictions applied at the data model property level (regardless of their origin—expression filters, static or dynamic enumerations, etc.) cannot implement the complex business logic that a stored procedure or a user-defined function can handle. Another motivation is related to custom joins defined in the generated SQL statement. In such cases, it is not always optimal to rely on JOIN statements generated automatically (under the hood) instead of using EXISTS statements that a database administrator might prefer for performance or clarity reasons. The goal of this post is to demonstrate how to map data model restrictions to the parameters of a user-defined function (UDF) or stored procedure . Defining a "Virtual" Table This exercise mostly mimics what was described in the previous post : Getting Started With Seal Report: Applying Custom Joins Vlad Ganușceac Vlad Ganușceac Vlad Ganușceac Follow Apr 2 Getting Started With Sea