Stored procedure mode

To improve performance in the card views, you can use a stored procedure in the database to load the user's instruments. With the stored procedure the widgets will load more quickly.

In addition, if stored procedure mode is enabled, these additional fields are shown in the widget's search criteria:

  • Area
  • Milestone

To enable the stored procedure, open the widget configuration 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, select the Security > Service Model Whitelist > Allowing Models node and add child Model nodes for these models:

  • Infor.PublicSector.Services.Portal.MyInstrument
  • Infor.PublicSector.Services.Portal.RelatedInstrument
  • Infor.PublicSector.Services.Portal.IncludedInstrument