Code: Select all
select * from
json_tree((select INFOVALUE from INFOTABLE_V1 where INFONAME='NAV_TREE_STATUS'), '$')
where json_tree.id != 0
More info : http://www.sqlite.org/json1.html
Moderator: Renato
Code: Select all
select * from
json_tree((select INFOVALUE from INFOTABLE_V1 where INFONAME='NAV_TREE_STATUS'), '$')
where json_tree.id != 0