SQLITE_ENABLE_JSON1

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

SQLITE_ENABLE_JSON1

Post by Nikolay »

Sample sql with JSON

Code: Select all

select * from 
json_tree((select INFOVALUE from INFOTABLE_V1 where INFONAME='NAV_TREE_STATUS'), '$')
where json_tree.id != 0
json.png
json.png (9.62 KiB) Viewed 2530 times
Related issue : link
More info : http://www.sqlite.org/json1.html
Post Reply