View Data in phpMyAdmin

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

View Data in phpMyAdmin

Post by khurshid.arshad »

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
savy
Posts: 159
Joined: December 27th, 2012, 1:36 pm

Re: View Data in phpMyAdmin

Post by savy »

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
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: View Data in phpMyAdmin

Post by khurshid.arshad »

Dear Savy;

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