Error in app grid with SQL JSON

Scriptcase 9 Bugs
#1

I am trying generate a report with a SQL with JSON_TABLE, but SC generate a error with '$.envio[]’. SC believes that is a global variable ( [] ).

SELECT
jt.id_envio,
jt.fecha_envio
FROM pedidos p,
JSON_TABLE(
p.json_data,
‘$.envio[*]’
COLUMNS (
id_envio INT PATH ‘$.id’,
fecha_envio DATE PATH ‘$.fecha’
)
) AS jt

#2

‘$.envio[*]’

OR

CONCAT(’$.envio’, ‘[*]’)

#3

i test with differents quotation marks and CONCAT and Not work.

#4

$check_sql = “SELECT …,
JSON_TABLE(
CONCAT(’[”’, REPLACE($campo_permiso, ‘,’, ‘","’), ‘"]’),
‘$".chr(91)."*]’ COLUMNS (valor VARCHAR(50) PATH ‘$’)
) AS jt …"

Concat .chr(91). in php
works for me

#5

Thaks derazo for your help.
My case is a App Grid where not work. I need that works from SQL of app Grid.