Microsoft Dynamics AX (Archived)

Multi select combobox using enums...

(0) Share

Report

Posted on by Community Member

Is it possbile? As far as i know it's possible with a query;

msCtrl = SysLookupMultiSelectCtrl::construct(element, TestCtrl, querystr(StudentCourse)); etc...

Regards

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

As I know, isn't possible.

What you can do is exclude some values with the SysFormEnumComboBox class.

A workaround could be use a tmp table, fill with the enum values and use the SysLookupMultiSelectCtrl Class.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

Lookups are all about queries. Nevertheless you can fill a temporary table with enum values and use it an a query. SysLookupMultiSelectCtrl offers constructWithQueryRun() factory method for scenarios with a temporary table.

Was this reply helpful? Yes No
CU13051429-0 351 on at

Like (0)

Report

Hi Martin

I have to use tmp table ( either tmp or in momory ) for SysLookupMultiSelectCtrl

using below code

MyTempTable.setTmpData(element.populateTmpTable);

queryRun = new QueryRun(queryStr(MyTempQuery));

//AOT MyTempQuery query which has MyTempTable as datasource

queryRun.setCursor(MyTempTable);

msCtrlCust = SysLookupMultiSelectCtrl::constructWithQueryRun(element, control,queryRun);

Temporay table are population as i have ran the same cod to fill MyTempTable ( making it regular table)

after execution able to see inserted rows. and also with regular table type SysLookupMultiSelectCtrl is showing records in multiselectcontrol too.

However if i change table type to tmp or inmomory then same code showing no records in multiselectcontrol.

Please suggest.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (1)

Report
You're not using constructWithQueryRun() correctly - you have to provide a value for _selectField parameter in this case. For example:

msCtrlCust = SysLookupMultiSelectCtrl::constructWithQueryRun( element, control, queryRun, false, [tablenum(MyTempTable), fieldNum(MyTempTable, MyField)]);

Was this reply helpful? Yes No
CU13051429-0 351 on at

Like (0)

Report

Thanks for Reply Martin.

I have added container for select field however there is no records at UI.

while debugging , form data source has no records ( no of loaded records)

SysLookupMultiSelectGrid at this class level

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

Like (0)

Report

I'm sorry, but I don't have enough information to tell you where you have done something wrong. Ensure yourself that you fill the temporary buffer with data, that your query is correct (e.g. Fields node has Dynamic property set) and if you don't see anything wrong. debug the code.

Was this reply helpful? Yes No
Suggested answer

YuliaK 10 on at

Like (0)

Report

Try this:

MyTempTable = element.populateTmpTable;

Was this reply helpful? Yes No