Created 06-18-2018 07:22 PM
Hi
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 FROM FLOWFILE GROUP BY caseid,projectshortname ORDER BY caseid DESC LIMIT 1
Please advice me on this issue
Created 06-18-2018 07:34 PM
In Record Writer controller service of QueryRecord processor make sure you are having casecount name defined with the datatype associated with it.
Created 06-18-2018 07:34 PM
In Record Writer controller service of QueryRecord processor make sure you are having casecount name defined with the datatype associated with it.
Created 06-18-2018 10:42 PM
Thanks .. I will check the same