Skip to main content

Quantela platform user manual

Filter By SQL

Description

This function will use a SQL expression to query and filter a JSON object.

Input

JSON

Output

JSON

Expression

The SQL expression to be used to filter the input data. You should use "?" as the data placeholder. This is an example:

SELECT userId, SUM(id) FROM ? GROUP BY userId