RAQL Inline

Transforms up to four data feeds into one output by applying a RAQL statement.

The following parameters are available.

Parameter

Description

Data feeds

Up to four data feeds to be transformed. In the RAQL statement, the feeds are referred to as feed1, feed2, feed3, and feed4. At least one feed must be connected.

RAQL query

Input field to enter any RAQL statement.

Insert parameter (Insert parameter)

Inserts user defined input parameters at cursor position. The button is only clickable if at least one user input parameter, for example, Text user input, has already been inserted in the feed definition.

See RAQL and SQL statement parameters for details.

Expand (Expand)/

Collapse (Collaps)

Temporarily expand the edit box. When expanded, the box will shrink again upon clicking Collaps, or when the editor goes out of focus.

The RAQL syntax reference can be found at RAQL Query Syntax Reference.

Built-in RAQL functions are described in Built-In RAQL Functions.

For instructions on how to create user-defined functions, see Configure, Compile, Deploy and Test User-Defined Functions.

For detailed information on configuring the time zone used by this operator, see the chapter Configure feed processing time zone.

Example

SELECT feed1.productName, feed2.supplierName FROM feed1, feed2 WHERE price <= :maxPrice AND feed1.supplierId = feed2.id