Stored procedure for My Assignments (SQL Server)

This update includes performance improvements in the My Assignments widget. To speed up the load time, the widget can now use a stored procedure to query the database.

This update includes only the SQL Server version of the stored procedure. An Oracle version will be added in a future update, as well as stored procedures for other widgets.

To enable this feature, open the configuration for the My Assignments Card View widget and set Stored Procedure Mode to True. You must also add the models that the stored procedure uses to the whitelist in the Portal configuration. See the Infor Rhythm for Civics Administration Guide for details.