Aggregate Queries in mysql using virtual fields


#1

I have created a virtual field vcol1 for SUM query as mentioned in wiki.dreamfactory.com.I want to use dreamfactory api to query.

SELECT col0,SUM(col1)
FROM tablename
WHERE col2=x
GROUP BY col3
I get a value 0 for all records.Any help?


#2

Hi Kyle, maybe if you give more details, i.e. how are you doing the call I could help you to get it running.