Hello friends,

Is there any possibility to extend the "Group by" clause on the main table like the function "query.extend.where("...")"?

thanks in advance

MRF

select, from and where are pretty much it.

If you insist that grouping is a requirement, you can create a temporary table filled by your extended query and then sort your heart out on it.

If you are querying a substantial amount of data then that is probably a better solution anyway.

Since MRF is using Baan 5, query.extend.order is also available...

Group by functionality is not available. However it depends on what you would like to achieve. Please provide more detailed information on what your requirements are.

Group by functionality can be simulated in some situations, but for this some more extensive programming is necessary.

Youp