Read data from a JSON formatted column
Posted: Fri Feb 22, 2019 1:19 pm
Hi everyone,
I'm pretty new to Servoy. Nevertheless I've been asked to maintain a Servoy application - so I guess you'll be seeing more of me here.
Anyway. Currently this application must be able to generate some report from the database, and I've come a long way in setting up the sql string and actually getting a set of records using databaseManager.getDataSetByQuery.
To my unpleasant surprise however,I discovered that certain relevant data cannot be retrieved directly from a column; this data is stored in JSON in this column - and my sql string needs to query a key-value pair within it.
Can this be done in Servoy - and if not, what would be a good workaround?
Thanks!
I'm pretty new to Servoy. Nevertheless I've been asked to maintain a Servoy application - so I guess you'll be seeing more of me here.
Anyway. Currently this application must be able to generate some report from the database, and I've come a long way in setting up the sql string and actually getting a set of records using databaseManager.getDataSetByQuery.
To my unpleasant surprise however,I discovered that certain relevant data cannot be retrieved directly from a column; this data is stored in JSON in this column - and my sql string needs to query a key-value pair within it.
Can this be done in Servoy - and if not, what would be a good workaround?
Thanks!