What is the SQL Query for Word Period Report?

[JTRTech]

Yes,
Ive not done masses of work with it but it would be along these lines;

Graph Query getTicket Calculations

I got it with some trial and error. Parameters input as JSON array and values used in report as $Name… query q {getCustomReport(name:"Ticket Calculations",parameters:[{name:"TicketId",value:"55955"}]) { name tables { rows { cells } } } } into [Ticket Calculations:3,2] >Calculation Type|Amount {REPORT CALCULATION DETAILS:C.Type,C.CalculationAmount:T.Id=$TicketId} gives desired result… ish; { "data": { "getCustomReport": { "name": "Ticket Calcul…