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 ).

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.

Statements used in reports

Multivalued data, unexploded

Multivalued data, exploded

Multivalued data, exploded and filtered using WITHONLY

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

Example of processing dialog

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

Progress dialog snippet

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.

OIConsole configuration editor

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.