Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

SEARCHCOL (Col A)

      Mandatory in combination with another keyword/parameter = mandatory in combination with another parameter                                                                                                                                        

Parameter

Mandatory/Optional

Value (example)

Occurrence in column A

Comment

FORMS

REPORT

SEARCHCOL

Mandatory in combination with another keyword/parameter

Mandatory in combination with another keyword/parameter

<OBJECT>

1

Parameter to define which search column that should be dynamically expanded in the column.

SEARCHCOL in column A is a parameter that must be defined if the columns should be expanded dynamically. This parameter should state which search column (in the table/view stated in the SQL query in parameter DYNCOL) that should be expanded for each column.

This parameter needs to be defined for each column that has COLEXPAND as TRUE.

In order for the column to expand dynamically, it is also necessary to define three other parameters:

To expand several columns in a group, the following must apply:

  • COLEXPAND = TRUE for all of these columns.
  • Identical values in SEARCHCOL and SEARCHVAL.
  • No blank column between them (the columns that should be expanded together need be in consecutive order).

SEARCHCOLColA

Published:

SEARCHCOL (Col A)

      Mandatory in combination with another keyword/parameter = mandatory in combination with another parameter                                                                                                                                        

Parameter

Mandatory/Optional

Value (example)

Occurrence in column A

Comment

FORMS

REPORT

SEARCHCOL

Mandatory in combination with another keyword/parameter

Mandatory in combination with another keyword/parameter

<OBJECT>

1

Parameter to define which search column that should be dynamically expanded in the column.

SEARCHCOL in column A is a parameter that must be defined if the columns should be expanded dynamically. This parameter should state which search column (in the table/view stated in the SQL query in parameter DYNCOL) that should be expanded for each column.

This parameter needs to be defined for each column that has COLEXPAND as TRUE.

In order for the column to expand dynamically, it is also necessary to define three other parameters:

To expand several columns in a group, the following must apply:

  • COLEXPAND = TRUE for all of these columns.
  • Identical values in SEARCHCOL and SEARCHVAL.
  • No blank column between them (the columns that should be expanded together need be in consecutive order).

SEARCHCOLColA

For an optimal Community experience, Please view on Desktop
Powered by Zendesk