Adding a filter to a table definition

Note: Not all tables can have filters. Filters are not allowed for these tables:
  • Core.HansenEvent
  • All tables in the Core.AccessControl family
  • All tables in the Core.License family
  • All tables in the Core.RoleBasedFilters family
  • All tables in the MetaData family
  1. Select System > Agency Personalization > Schema Manager.
  2. Browse to the Filters node for the table definition that you want to add the filter to.
  3. Click Add above the Filters grid.
  4. Specify this information:
    Name
    Specify a name for the filter.
    Description
    Specify a description of the filter.
    Definition
    Enter the SQL statement that defines the filter.

    The codes listed under the Definition field define which table elements can be used to create a filter. @T is the table you want the filter applied to; @USRID is the user ID for the user the filter applies to; and @EMPID is the ID for the employees the filter applies to.

    Roles
    In the gird, add the roles that this filter applies to.
  5. Click Save.
  6. When you're finished adding filters, click the Refresh button in the Schema Manager's toolbar.
    This applies the filters that you just created. If you don't click Refresh, you must sign out of Infor Public Sector and then sign back in before the filters are applied.