CSPro Users Forum

Dear Team;

In old days we can see data in phpMyAdmin against each row. But now it is not. There is a way to view data in phpMyAdmin other than rational table.

Best regards.
Arshad

Questionnaire content is stored as compressed JSON. Easiest way to view a case is using MySQL Workbench using the query
SELECT uncompress(questionnaire) FROM DICT_NAME where caseids = '<your caseid string>';
In the result grid you can right click on the cell and open in value viewer as Text/JSON

Dear Savy;

How can update case in phpmyadmin through sql query.
Best.
a.