RLIST Changes for OI 10.2 [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== RLIST Changes for OI 10.2 ======

RLIST selects records and generates text output using an English-like syntax.

In OpenInsight 10.2, RList allows for the specification of new “target” types including OLIST, XBAND, BRW, EDITTABLE, and OSFILE, with the goal being to unify the reporting syntax.

Other RList enhancements for 10.2 include the addition of the EXPLODE-ON statement and the WITHONLY keyword (See RLIST_EQUATES ).

===== New Feature: EXPLODE-ON and WITHONLY keywords =====

We have added two new enhancements to improve selecting multivalues, the EXPLODE-ON statement and the WITHONLY keyword.

EXPLODE-ON <table> <column> will “explode” the multivalues into individual rows. It is similar to sorting on a multivalued column except that it does not alter the sort order.

WITHONLY < filter clause> behaves like LIMIT but affects the active select. WITHONLY only operates on a select list which has been exploded or sorted on a multivalued column. You can use these facilities from TCL or in RLIST statements. Below are some example code snippets and the resulting output.

{{printing_changes_102_rlist_01.png|Statements used in reports}}

Statements used in reports

{{printing_changes_102_rlist_02.png}}

{{printing_changes_102_rlist_03.png|Multivalued data, unexploded}}

Multivalued data, unexploded

{{printing_changes_102_rlist_04.png}}

{{printing_changes_102_rlist_05.png|Multivalued data, exploded}}

Multivalued data, exploded

{{printing_changes_102_rlist_06.png}}

{{printing_changes_102_rlist_07.png|Multivalued data, exploded and filtered using WITHONLY}}

Multivalued data, exploded and filtered using WITHONLY

===== New Feature: Progress bars during select and reporting =====

RList and supporting programs can display progress dialogs during select and reporting. Cancelling the dialog cancels the report. 

{{printing_changes_102_rlist_08.png|Example of processing dialog}}

Example of processing dialog

You can use the RTI_RESOLVE_SELECT_CALLBACK program in your own routines to display a progress window during selects.

{{printing_changes_102_rlist_09.png|Progress dialog snippet}}

Progress dialog snippet

===== Configuration Record =====

The CFG_RTI_RLIST configuration record can be placed in the SYSENV table. It can be defined globally, or per-application (by appending “*<appid>” to the configuration name), or per-user (by appending “%%**%%<userid>” to the configuration name), or per-application/per-user (by appending “*<appid>*<userid>” to the configuration name).

You can use the OIConsole to enter the details into this configuration record, or you can update it manually via the Record Editor.

{{printing_changes_102_rlist_10.png}}

OIConsole configuration editor

===== CFG_RTI_RLIST Configuration Record =====

The CFG_RTI_RLIST record controls whether R/List statements run in “backwards compatible” (OI9) mode, or with the new enhanced functionality. If field 1 contains “RLIST9”, or just “9”, then R/List will behave as it did in OI 9 (this is the default behavior). If field 1 contains “RLISTX”, or just “X”, then the enhanced R/List functionality will be activated.

{{printing_changes_102_rlist_11.png}}