SUM/Query

(0) Share

Report

Posted on by Community Member

Dear Experts

I have different columns in grid for Amount I want total at bottom of grid and grid is bound to custom table (ARM_INVOICEDETAIL) and their is no query in AOT how can i take sum of each column.

Thanks

Afridi

I found Below query on Martin Page

// Copy the query
Query query = new Query(SalesLine_ds.queryRun().query());

QueryBuildDataSource qbds = query.dataSourceTable(tableNum(SalesLine));
QueryRun qr;
Salesline summedTrans;

// Sum LineAmountMst
qbds.addSelectionField(fieldNum(SalesLine, LineAmount), SelectionField::Sum);
qr = new QueryRun(query);
// Run the query
qr.next();

// Get the data
summedTrans = qr.get(tableNum(SalesLine));
// Set the new sum to the control
RealEdit.realValue(summedTrans.LineAmount);
txtitemid.text("1000");

*This post is locked for comments

All responses (4)

Answers (1)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi

One way is to create a query object in AOT, with the desired sum fields. use that query in your code to get the result.

for eg: for SalesLine, in the query >> Datasources >> SalesLine >> fields >> New Sum.

select the field as LineAmount.. you must have the Dynamic property to "No" before you do this.
Suggested answer

reachnaidu 890 on at

Like (0)

Report
Copy link

Link copied!

In the table ARM_INVOICEDETAIL , create a new display method Sum() and add the fields which you need.

like this.Field1 + this.Field2 .. etc and use the display field at the end of the row of the grid

If you want to sum only one field out of the table, use the same procedure above and write a simple query

Select Sum(LineAmount) from SalesLine

where Salesline.SalesId = this.SalesID

and return SalesLine.LineAmount ..This should give you the whole value
Verified answer

Martin Dráb 240,744 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Can you explain what kind of problem you have with the code you've posted?

Also, the code uses a query from the form, not some separate query in AOT. If your form has a datasource, it also has a query.
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin I Used your code and it is working