WebFOCUS Language

In this section:

 

The following are known issues in the WebFOCUS language.


Top of page

x
Autoprompt Values With Quotation Marks

Autoprompt correctly lists a value that contains double quotation marks ("), but when selected for a single select list, the request fails with a syntax error. The problem does not occur for a multi-select list control.


Top of page

x
Changes to Default MATCH FILE Processing

In prior releases, MATCH FILE requests did not group verb objects with their sort keys across files. The resulting record was laid out by appending the fields from each file to the resulting record in the HOLD file. The current default behavior is to group verb objects with their sort keys. This can result in the fields being propagated to the HOLD file in a different order and can affect the MATCH results if the request uses the default alias names generated in the HOLD Master File. The advantage of this technique is that it supports HOLD file formats such as FORMAT FOCUS that generate an associated Master File. If you need to invoke the processing from prior releases, issue the following command.

SET MATCHCOLUMNORDER = UNGROUPED

Top of page

x
SET ASNAMES = FLIP

The new option SET ASNAMES = FLIP makes the field name from the original Master File the alias value in the HOLD Master File and generates default field names in the HOLD Master File. For complete information, see the Creating Reports With WebFOCUS Language manual.


Top of page

x
Using an MFD_PROFILE That References Itself

A Master File Profile is a FOCEXEC that is invoked whenever the Master File is referenced in a request. If the MFD_PROFILE references itself, an infinite loop can result. For information about using a counter in the MFD_PROFILE request to prevent infinite looping, see the MFD_PROFILE Usage Notes in the Describing Data With WebFOCUS Language manual.


Top of page

x
Hierarchical Reporting

Hierarchical reporting uses BY HIERARCHY syntax to display hierarchies defined in Master Files automatically indented to show the hierarchical relationships between the members. For complete information about hierarchical reporting, see the Creating Reports With WebFOCUS Language manual.


Top of page

x
Escape Special Characters in JAVASCRIPT Calls

A single quotation mark ('), double quotation mark ("), or backslash (\) within a JAVASCRIPT call in a hyperlink or drill down is not supported.


Top of page

x
URL Attribute in Styling

When using a URL attribute with a TYPE=DATA, ACROSSCOLUMN=field declaration, the URL data value of the first ACROSS column is being assigned to all ACROSS columns.


Top of page

x
HTML Table of Contents

When the size of the LEFTMARGIN is customized, only the first table, which is displayed automatically when the request is run, respects this margin. When the second or lower value for the highest-level sort field is selected from the TOC tree, the default size of the left margin is used.

As a result, when View Entire Report (On/Off) is selected in the TOC tree, two left margin sizes are displayed and a separation of the report into two parts occurs. The first table shows the left margin specified, while all other tables adhere to the default left margin size.


Top of page

x
Accordion By Row Reports

The following are known issues with Accordion By Row reports:


Top of page

x
XLSX FORMAT

A COMPUTE field with a URL containing a blank space in the value generates a bad workbook.


Top of page

x
EXL2K FORMAT

In EXL2K formatted reports, with headings or footings containing multiple items that are separated by spot markers without spaces, the spot marker adds an additional space between the items within the text in the cell. The workaround is to use XLSX formatted reports, instead.


Top of page

x
EXL2K FORMULA

The following are known issues with EXL2K FORMULA:


WebFOCUS