Default sorting for Plan Data plansheet

Plan Data plansheets can have a pre-defined sorting when the plansheet is initially loaded. The default sort order is displayed as a label at the top of the plansheet. If default sorting is not specified, the data is loaded without the sort applied.

The default sorting is determined using these plansheet parameters:

• rv_sort_property and rv_sort_period: The sort is only applied only if the rv_sort_property and rv_sort_period parameters are defined, and these conditions are met:
  • The property must be an atomic property.
  • The property must be displayed in the plansheet, either in columns or slicer.
  • The period must be a single period. This can be represented as a specific period or period index. Application variables can also be used to represent the period values.
  • The period must be displayed in the plansheet, either in columns or slicer.
  Note: 

  • The property must belong to the resource classes applicable to the plansheet.
  • The property and period names are displayed based on the defined display settings for property and period. See Modifying user settings.
• rv_sort_direction: This parameter determines the direction, such as DESC (Descending), or ASC (Ascending) in which the sort is applied.
  Note: 

  • The rv_sort_direction parameter value is not case sensitive.
  • If this value is not specified, the default sort order is set to DESC (Descending).
• rv_top_results: This parameter determines the number of results to be displayed. The first x descending or ascending results are displayed, based on the sort options applied. If the parameter is not a positive integer value, all results are displayed.