Forum Discussion

RobertScalise's avatar
RobertScalise
Qrew Cadet
8 years ago

Run API_DoDuery using qid for a summary report that uses paramerters

I have a table of contractor data with first name, last name, start and end dates, burden amount, ball rate and pay rate. I want to summarize the bill, pay and burden amounts and do other averages and...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
The API method API_DoQuery cannot return the XML associated with a summary report - it can only return the XML associated with a table report. What you have to do is (1) grab the XML associated with the query, (2) Convert XML to JSON, (3) using Underscore's groupBy() method to aggregate the data, (4) template the data to HTML using Mustache (or Underscore's template() method and/or POST the aggregated data to your history table.

It may sound complicated but the code is short because of the abstractions involved.