Giri,
agree with Florian, in your $aggregate function, you can pass an object like
// table.$query().$where(oYourConditions).$aggregate(oYourColumns).$execute();
the variable/object oYourColumns would be like { COLNAME: true, COLNAME2: true }; // replace COLNAME/COLNAME2 with your actual column name from the table. You may have one or more of these columns in the object you are passing into the aggregation clause.
here is the API documentation - I hope this helps. Let us know if you run into other issues and good luck!
my advise to make sure your code is running correctly would be to write a sql query on the sql console, then your xsds code to validate you did the correct XSDS syntax.
Add comment