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

I have the same question (0)

All responses (7)

Answers (0)

Community Member on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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).

Was this reply helpful? Yes No
Suggested answer

xelifchemnitz 5 on at

Like (1)

Report

For everyone also facing this problem:

You have to use

sysTableLookup.parmUseLookupValue(false);

Was this reply helpful? Yes No