Re: [Axapta-Knowledge-Village] Group by in X++ ??

Sat, 08 Jan 2005 12:45:46 -0800

Hi Anton,
 
I tried this in a job andI didn't get any error:
 
    Query q = new Query();
    QueryBuildDataSource dsSalesTable;
    QueryBuildDataSource dsSalesLine;
    QueryRun             qr;
    SalesTable           SalesTable;
    dsSalesTable = q.addDataSource(tablenum(SalesTable));
    dsSalesLine = dsSalesTable.addDataSource(tablenum(SalesLine));
    dsSalesLine.addLink(FieldNum(SalesTable, SalesId), FieldNum
    (SalesLine,SalesId));
    dsSalesLine.JoinMode(JoinMode::InnerJoin);
    dsSalesLine.addSortField(FieldNum(SalesLine, SalesId));
    dsSalesLine.orderMode(ordermode::GroupBy);
    dsSalesLine.addSelectionField(FieldNum(SalesLine, LineAmount),
    SelectionField::Sum);
    qr = new QueryRun(q);
    while (qr.next())
    {
        SalesTable = qr.get(tablenum(SalesTable));
        print SalesTable.DeliveryAddress;
    }
    pause;

anton_tjiptadi <[EMAIL PROTECTED]> wrote:

Hi,
How to create X++ query for Group By ??

My select statement is simply like this (in Transact SQL)

select a.salesid, sum(b.lineamount) from salestable a, salesline b
where a.salesid=b.salesid
group by a.salesid

I try to build in X++ like this, but it cause error said that there's
no Group by

dsSalesTable = q.addDataSource(tablenum(SalesTable));
dsSalesLine = dsSalesTable.addDataSource(tablenum(SalesLine));
dsSalesLine.addLink(FieldNum(SalesTable, SalesId), FieldNum
(SalesLine,SalesId));
dsSalesLine.JoinMode(JoinMode::InnerJoin);
dsSalesLine.addSortField(FieldNum(SalesLine, SalesId));
dsSalesLine.orderMode(ordermode::GroupBy);
dsSalesLine.addSelectionField(FieldNum(SalesLine, LineAmount),
SelectionField::Sum);

Thanks in advance,






Sharing the knowledge on Axapta.

Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.

Sharing the knowledge on Axapta.


Yahoo! Groups Links

Reply via email to