Finance | Project Operations, Human Resources, ...

how to do group by on an existing aot query by extension

(0) Share

Report

Posted on by Brightlin

Hi,

I'm doing an extension on the TMSCommercialInvoice and it uses an AOT query object

I've extended the TMSCommercialInvoice query object with new datasources and I need to do a group by.

It doesn't allow it. So I'm wondering if there another way of doing group by on extended query?

Regards,

Brightlin

I have the same question (0)

All responses (4)

Answers (0)

Jeremy_Mounet 170 on at

Like (0)

Report

RE: how to do group by on an existing aot query by extension

Hi

Maybe the easiest way to calculate this will be to implement a specific query in the processReport method of the Data Provider with the "group by" in the Data Provider class ?

You could calculate this only when the shipmentId has changed by using the method queryRun.changed(tablenum(WMSShipmentTable)) and avoid the calculation on every row (it depends to the excepted result).

By this way, you don't change the standard design of the query.

Jérémy.

Was this reply helpful? Yes No
Brightlin 60 on at

Like (0)

Report

RE: how to do group by on an existing aot query by extension

Yes, I know. It's because I need add the container table to sum up qty from the container instead of using the qty of the loadline

Was this reply helpful? Yes No
Martin Dráb 235,928 Most Valuable Professional on at

Like (0)

Report

RE: how to do group by on an existing aot query by extension

If you added Group By to the query, it means the whole query would be grouped, not just the new data source. It sounds suspicious. Wouldn't it break the standard logic that uses the query?

What exactly are you trying to achieve?

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,699 Moderator on at

Like (0)

Report

RE: how to do group by on an existing aot query by extension

You have option of using query object in a code and then add datasource to it and then do group by on it .

Was this reply helpful? Yes No