SELECT.PERFION.REPORTDATA

From

Must contain (or reference) a connection string, in one of the following ways:

Name of a Data Source.
This data source must contain a connection string. This can be defined using the SET command.

Complete Connection-string:
Data Source=localhost;User ID=perfion;Password=mypw;Initial Catalog=perfiondb; PerfionUserID=admin;PerfionPassword=pswd;PerfionLanguage=EN;

Lookup from a named Connection defined in Perfion Go to Administration -> Remote Queries and open a query to see available Remote Connection names:
@REMOTECONNECTIONNAME=Perfion Production Database

Reference to current Perfion database:
Just type a '.' (period) in the From field

To

Unused.
Always delivers output to 3 Table data-sources (Row, Features and Parameters).
If any of them already exist, they will be overwritten.

Script

The Perfion Super-Query used for generating data for Reports.

Important: Make sure the Super-Query only contains a single feature in each of the From-clauses. The full and correct context for all data must be defined for the Action (e.g. no required user interaction to alter any values during generation).

The Super-Query can also be defined dynamically by including parameter references. The parameter values are evaluated in the same way as the script method { 9.16 Method: FillTemplate ( … ) }.
Example 1:
<Clause id='ExteriorColor' operator='=' value='{=$Color}' />
Example 2:
If you want to create the entire query dynamically, simply just include a reference to the parameter containing the query such as:
{=$MyQuery}

From

Name of the Input Data Source which contains the path to a file where Perfion super query is defined.

To

Name of the Output Data Source. Default TO.

@ItemIDs

Specifies the ItemIDs to report on.

A Structured Report
The Super-Query contains 2 API-queries (one for the Categorization structure and one for the Items in the structure – e.g. Products in a Catalog).
In this case, the ItemIDs must be ID's of categories you want to include in the Report. In most cases it would just be a single ID of the Root item in the Catalog-structure.

An Individual Item Report
The Super-Query contains 1 API-query (e.g. individually selected Products to include in a Report, e.g. for generation of Product Data-Sheets).
In this case, the ItemIDs must be the ID's of the individual items (e.g. Products) you want to include in the Report.

The ItemIDs can be specified by this parameter in the following ways:
List
Directly specify a comma-separated list of IDs e.g. '106,131'
Variable reference
Get a comma-separated list of IDs from a variable by writing '{=$MyIDs}'
DataSource
Extract the IDs from a Table data-source that must contain a column named ItemID. A list of IDs is extracted from all the Rows in the data-source. Each row may only contain a single ItemID.