GroupBy on Lookup problem

(0) Share

Report

Posted on by Community Member

Hello,

I have problem with GroupBy query on Lookup. I have table TabA with price lists:

PriceListVersion | PriceSignCode | PriceSignDesc.

In table tabB I have column PriceListVersion, where a want check version of price list from popup. Each version should appear only once in the list.

I have code:

public void lookup(FormControl _formControl, str _filterStr)

{

    Query                   query = new Query();

    QueryBuildDataSource    queryBuildDataSource;

    SysTableLookup          sysTableLookup;

    ;

    sysTableLookup = SysTableLookup::newParameters(tableNum(TabA), _formControl);

    sysTableLookup.addLookupfield(fieldnum(TabA,PriceListVersion), true);

    queryBuildDataSource = query.addDataSource(tablenum(TabA));



    queryBuildDataSource.orderMode(orderMode::GroupBy);

    queryBuildDataSource.addGroupByField(fieldnum(TabA,PriceListVersion));



    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup();

}

I check Query in Debbuger, in queryBuildDataSource we have:

SELECT FIRSTFAST * FROM PriceSignListTable GROUP BY PriceSignListTable.PriceListVersion

But still there is no grouping on the form:

4667.popup.PNG

What's the most interesting, sometimes it works properly, although I don’t change anything on popup or datasource.

*This post is locked for comments

All responses (7)

Answers (0)

Tony Mok 577 on at

Like (0)

Report

RE: GroupBy on Lookup problem

Hi xelifchemnitz,

It works for me. Thank you so much.
Suggested answer

Hossein.K 6,646 on at

Like (2)

Report
RE: GroupBy on Lookup problem

Hi,

Change your code like this:

void orderNoLookup(FormControl _control) { SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(InventTrans),_control); QueryBuildDataSource inventTransQbds; Query query;// = element.initQuery(); ; sysTableLookup.addLookupfield(fieldnum(InventTrans, TransRefId), true); inventTransQbds = query.dataSourceNo(1); inventTransQbds.addSortField(fieldnum(InventTrans,TransRefId)); inventTransQbds.orderMode(OrderMode::GroupBy); sysTableLookup.parmUseLookupValue(false); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); }
Suggested answer

xelifchemnitz 5 on at

Like (1)

Report

RE: GroupBy on Lookup problem

For everyone also facing this problem:

You have to use

sysTableLookup.parmUseLookupValue(false);
Community Member on at

Like (0)

Report

RE: GroupBy on Lookup problem

I tried use addSelectionField instead of addSelectionField, effect is still the same. I tried use they together, also without success.

I was looking in these tutorials, i didn't find anythink like that (Lookup with groupBy).
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report

RE: GroupBy on Lookup problem

Hi Maces, try open AOT > Forms/Classes > find "tutorial_" you have existing lookup for samples standard in dynamics ax for beginners or starters in development
Community Member on at

Like (0)

Report

RE: GroupBy on Lookup problem

I'm afraid that sysTableLookup.addSelectionField(), does not work in AX 2009, i get error: class hasn't this method.

It looks like it has been working since the AX 2012.
Community Member on at

Like (0)

Report
RE: GroupBy on Lookup problem

Hello Crispin,

Thanks for your answers.

I tried create an AOT query, effect is the same.

I noticed that the popup works with an empty field:

Then in queryBuildDataSource we also have:

SELECT FIRSTFAST * FROM PriceSignListTable GROUP BY PriceSignListTable.PriceListVersion

If there is any value in the field, group by not working:

QueryBuildDataSource is still the same.