Page 1 of 1
SQL Query on a dictionary
Posted: May 8th, 2018, 11:13 pm
by bmuganda
How do you write a query on a dictionary and retrieve the fields for instance
Code: Select all
string household_query = "SELECT NAME, AGE, GENDER FROM PERSON_REC WHERE AGE > 12";
sqlquery(HOUSEHOLD_DICT, PERSON_REC, household_query)
How do I implement such a query above?
Re: SQL Query on a dictionary
Posted: May 9th, 2018, 9:05 am
by Gregory Martin
The case data is stored as a single text value, so you can't really use SQL queries to extract data from it. We've discussed allowing such functionality in the future.
The purpose of the SqlQuery function at the moment is mostly to use with paradata logs.
Re: SQL Query on a dictionary
Posted: May 9th, 2018, 9:41 am
by htuser
Congratulations Greg and the Cspro Developer Team!
"The case data is stored as a single text value, so you can't really use SQL queries to extract data from it. We've discussed allowing such functionality in the future."
This is one of the most important news about Cspro evolution!
Best regards,