...
Code Block | ||
---|---|---|
| ||
var offerCountByDayTable = $Database.Get({ Parameters : { TargetSchema : 'OFR', TargetTable : 'Offers' }, Columns : [{ Name : "Day", Expression : "DateTrunc('Day', OfferDate)" }, { Name : "Amount", Expression : "Count(DateTrunc('Day', OfferDate))" }], Order : [ {Name : "DateTrunc('Day',OfferDate)", Type : 'Ascending'} ] }); offerCountByDayTable.Each(function () { console.info(this.Amount + ' offers made on the date ' + this.Day.toISOString()); }); |
See Also
- DataTable
- Expressions