Filtering data in tables

SCP tables use server-side or client-side to filter data.

Server-side filtering

The server-side filter is set for tables that contain large volumes of data. Filtering is processed on the server instead of the user interface. When server-side filter is applied, the underscore character (_) is treated as a wildcard. For example, when you search for F_R, the application displays values with one character between F and R, such as FAR, FIR, and FOR. You can also search for a literal underscore; the character must be escaped using square brackets. For example, F[_]R returns as F_R.

These screens are configured to use server-side filtering, where the underscore character is interpreted as a wildcard:

  • Configuration / Common: Interface Services, Calculation Rules, Measures, Planning Hierarchies, and Worksheets
  • Configuration / Cycles: Macros
  • Configuration / Planning Engines: Plansheets
  • Configuration / SCV: Constraints, Hierarchies, Hierarchy Table Links, Map Routings, and Valid Combinations
  • Data Management: All code lists
  • SCV: All datasheets

Client-side filtering

The client-side filter is used for tables with smaller data volumes. When the client-side filter is applied, the underscore character (_) is treated as a literal value. For example, when you search for F_R, the application displays records that contain only F_R.

Note: All tables use client-side filtering, where the underscore does not act as a wildcard, unless specified as using server-side filtering.