I joined an ongoing project where we make use of the option to format the values of an Apps table via the row_format_json
.
Example sql
statement in the sourceOptions
of an Apps table:
SELECT
o.*,
CASE
WHEN o.col_x < o.col_y THEN '[{"fontColor": "rgb(0,135,90)", "columns": ["col_x"]}]'
ELSE '[{"fontColor": "rgba(255,0,0,0.0)", "columns": ["col_x"]}]'
END as row_json_format
FROM
(
SELECT
col_x,
col_y
FROM inputTable
) as o
Question: Where can i find a documentation to the row_format_json
functionality/capabilities?