I am using below query in query record processor for flow files which are json based , But the casecount column is not displaying in resultant flowfiles
SELECT caseid, projectshortname,COUNT(caseid) as casecount
GROUP BY caseid,projectshortname
ORDER BY caseid DESC
Please advice me on this issue
In Record Writer controller service of QueryRecord processor make sure you are having casecount name defined with the datatype associated with it.
View solution in original post
Thanks .. I will check the same