All comments from Data Set

Support - Assistance technique
1

Hi

Is there a way of retrieving all the comments made on the Data Entry form of a particular Data Set.

2 Likes
2

Easily done using an SQL view. You don’t mention which version you are running, but find the SQL View app, open up a new view, and paste something like this into the code window (obviously you change the dataset name to whatever you want it to be):

SELECT ds.name AS dataset_name, de.name AS de_name, dv.comment, COUNT(dv.*) AS no_of_comments FROM datavalue dv
JOIN datasetelement dse ON dse.dataelementid=dv.dataelementid
JOIN dataelement de ON de.dataelementid=dv.dataelementid
JOIN dataset ds ON ds.datasetid=dse.datasetid
WHERE dv.comment IS NOT null AND ds.name = ‘NIDS Monthly Dataset’
GROUP BY ds.name, de.name, dv.comment
ORDER BY ds.name, de.name, dv.comment;

It will give you a list of comments, per data element and including the number of such comments

Regards
Calle

2 Likes
3

Thank you Calle. I’m using 2.28. Does this still qualify?

2 Likes
4

Hi

Yes, just note that in 2.28 the SQL view is under Data Administration (it’s been moved in more recent versions)

Regards
Calle

3 Likes