Back Forward List View form
Completing the Organize tab

About List View rules

  Show all 

Complete the Display Fields tab before the Organize tab. All data are optional. Complete this tab to:

Sorting and filtering that you define on this tab runs on the Process Commander server, and occurs after sorting and filtering by the database software.

  Paging

Field

Description

Enable Paging

Select to present the list view results in segments — known as pages — each containing a fixed number of rows. C-2339 Clear to present all rows (up to the Maximum Value count on the Content tab.) Paging is enabled by default. GRP-359

Tip As a good practice, enable this capability for worklists and for other lists that users need to scan only until they find a row of interest. However, for maximum user productivity, design the selection criteria and sorting in each list view rule to eliminate the need for user paging, or to present as few pages as possible when paging is unavoidable. See Pega Developer Network article PDNPRKB-16205 How and when to enable paging of list view displays.
Paging causes the system to retrieve rows to only a segment at a time on request, improving response time and reducing the size of the clipboard. REMOVED If your PegaRULES database is hosted by IBM DB2 software, such paging is supported only if all properties in the report are exposed as columns. KARAF 11/7/2006 REVISED SR-6868 BUG-2824 Rejected fixed 5.4 NATAA BUG-12433 Anil

At runtime, users may see the busy indicator (Busy indicator ) while waiting for a paging operation to complete. 5.5 GRP-289

Paging Properties

Complete these fields when you select the Enable Paging checkbox.  

Page Size

Enter a positive integer not greater than 200 to control how many rows appear at once as a report page. Values between 10 and 30 are typical; the default is 50 rows.

Page Mode

The system divides the responses into numbered pages based on the Page Size value. Select to control the presentation of pages:

  • NumericPage controlPresent the first group of N links as page 1, the second group as page 2, and so on, where N is the value of the Page Size field. Numbers 1, 2, ... appear as clickable links. (This is the default mode.)
  • Next/Previous — Use navigation buttons to access the next page, or a previous page
  • Drop-Down — Present all page numbers in a selection list control.

For example, if the Page Size value is 10 and the report contains 107 rows, the first page contains rows 1 to 10, and the last (11th) page contains the final 7 rows.

Page Navigation Alignment

Choose Left, Center, or Right as the location of the page control on the list view display. The default is Right.

Paging Bar Position

Select to indicate whether the page control is to appear at the top of the report display, at the bottom, or both.

Sort Mode

Rows are initially presented in the natural sort order of the class. Users can re-sort the rows of the display by clicking a column header. Select:

  • All Pages to cause clicking a column header at runtime to sort the entire result set of rows, rather than the current page. Sorting is performed by database software, and requires all data to be retrieved. Select this mode only when all properties in the report display correspond to exposed columns and use ordinary sorting rather than a custom sort routine (such as used — for example — by the Work-.pyID property for work object ID). KARAF 5/2006 and BUG-4250 rejected
  • Viewed Pages to cause this action to sort only the current displayed page. Sorting occurs through Process Commander software, not the database server. In this case, users can sort on any report column — whether or not the column data is from a property that is exposed as a database column. Forum 178 and Kondepati 5/5/06 B-19806

  Sort by..., Filter by..., Categorize by..

These fields are not available for reports in which paging is enabled.

Field

Description

Sort by...

ArrayIf you complete this array, the first row identifies the major sort. Later rows identify minor sorts within the major sort. Unlike sorting defined in the Get these fields array (on the Content tab), this sorting uses the OVERRIDE SORT FUNCTION (if any) defined in the property rule. For example, use this array to sort work objects by work object ID, property Work-.pyID has an Override Sort Function.

Sort by Column

SmartPromptOptional. Identify a property for this sort. (You can choose a property not referenced elsewhere on this form.) SR-4571

Sort Order

Select Ascending or Descending.

Filter by... Array
When Expression

Optional. To display only a subset of the results retrieved by the criteria set on the Content tab, you can identify a when condition rule here, or a Boolean expression.

The text you enter here becomes the content of a when directive (or a <pega:when >JSP tag) in the generated HTML. At runtime, the system evaluates this condition for each potential row of the display, displaying only those for which the result is true.

If you enter two or more When Expression values, records are included only if all evaluate to true. GUESS

Rows excluded by such filtering are not displayed and not sent to Excel when a user clicks the  Export to Excel   button. B-15284

TipFor best performance, selecting the desired instances through the criteria or a custom activity (so they never are added to the page) rather than through this filter mechanism is preferred, when possible.

Categorize by...

ArrayWhen you complete this optional array, the initial report presentation shows rows collapsed, labeled with a plus sign (+) and the values in this array. The user can click the + to view the rows.

Each collapsed row can contain a prefix, a property value, and a suffix, in the format:

PREFIX: value suffix

Property

SmartPromptOptional. Identify a property to provide a value for the collapsed row.

Caption

Optional. Enter literal text as a prefix for the value.

Label

Optional. Identify a property reference. The text value of this reference appears in italics as a suffix to the row.  

  Organize Title

These fields determine the contents of the title area. Optionally, enter a caption for each button in the Caption column, or accept the default caption text.

Field

Description

Organize Title  
Customize View button

Select to cause the  Customize View  button to appear in the title area. This permits report users to make a personal copy of the list view rule, altering any part of it that can be changed using the Report wizard.  

Enter a Caption to appear as a ToolTip. The default ToolTip is Customize View.

NoteThis capability is not available when the Embedded option (on the Display Fields tab) C-2414 is selected, or when the Activity Name identified on the Content tab is not GetContent. KARAF 9/12/06

Customize Criteria link

Select to cause the Customize Summary Criteria link to appear in the title area. This permits report users to make a personal copy of the summary view rule, altering the criteria.  

Enter a Caption to appear as a ToolTip. The default text is Customize summary criteria.

This capability is not available when the Embedded option (on the Display Fields tab) is selected. C-2414

Export to PDF link

Select to cause an Export to PDF link to appear in the title area. When clicked, the report output is converted to a Portable Document Format file and downloaded to the user workstation. 5.5 GRP-306 GRP-875 See these PDNPega Developer Network articles for examples and instructions: GRP-3197

  • PRKB-25596 How to export list view and summary view output to a PDF document
  • PRKB-25731 How to produce PDF reports on a nightly schedule.
  • PRKB-25635 Generating PDFs and attaching them to a work object or viewing them in a web browser

NoteYour application can attach list view report output, converted to PDF, to a work object. See How to attach report output (as PDF) to a work object.

Advanced featureThis conversion uses the Public API method getPDFUtils().generatePDF(byte[] htmlStream).

Excel button

Select to cause the  Export to Excel   button to appear in the title area. This allows users to export the report contents to Microsoft Excel, and (if configured), to edit Process Commander data using Excel.

Enter a Caption to appear as the button caption. The default text is Export to Excel.  

Edit?

Select to allow users to edit rows of the report data using Microsoft Excel and upload the results as instances into the PegaRULES database. Proj-164 Select this only when:

  • The Applies To key part of this rule is a concrete class derived from the Data- base class, Rule- base class, or Work- base class. NATAA
  • All properties in the Get These Fields array (on the Content tab) are exposed as columns in the database.
  • Only limited validation is needed.
Configure
Edit in Excel

If you selected the Edit? checkbox, click to define the operations that are supported when editing in Excel. Proj-164 See List View rules — Completing the Edit in Excel window.

Add to Favorites Button

Select to cause the  Add to Favorites   button to appear in the title area. This allows users to add a shortcut to this report on their Dashboard or Monitor Activity workspaces.

Enter a Caption to appear as the button caption. The default text is Add to Favorites.  

This capability is not available when the Embedded option (on the Display Fields tab) is selected. TASK-4086

Open button

Select to allow users to open this summary view rule, allowing them to update it (unless it is locked) or save a copy for personalization.  

Enter a Caption to appear as the button caption. The default text is Open.  

New button

Select to include a New button ( New) in the title area after drill down. This allows users of the report to add a new instance of the class supporting the drill-down report, using a temporary Rule-Template-Excel rule.

CautionSelect this only for data classes that do not affect the integrity of your application.

Enter a Caption to appear as a button caption The default text is New...

Model name for new window

Optional. Identify a model in the Applies To class to be applied when users click the  New   button. If this field is blank, the system uses the model named pyDefault.

  Custom Buttons

Field

Description

Custom Buttons  
Label

AddOptional. To include additional text-labeled buttons, complete a row of this array. Enter brief text to appear as the label.

Onclick function

Enter the name of a script function (JavaScript or similar) to run when a report user clicks the button defined by this row.

Tooltip

Optional. Enter the help text to display when a report user points to the button defined by this row.

Fragment for custom scripts

Optional. Identify an HTML fragment rule that contains, or provides access to, the script functions referenced in the array above.

SubHeader

Optional. Select an HTML rule that provides the contents of an optional subheader that appears below the header on the report display. KARAF 4/12/05

Link to help topic

Optional. Enter a relative URL for a help topic that explains the operation of this list view rule. If not blank, a help button (Help) appears in the button group. VAGUE relative to what? GUESS SP6.

Up About List View rules