Dynamics Community Forum Thread Details

Lookup not working

Hi,

if i add VendAccount as a multi-select lookup on a custom form

1. should add i add code to init method or lookup method?

[ExtensionOf(formStr(Form1))]
final class Form1_Extension
{


    public void init()
    {
        next init();

        SysLookupMultiSelectCtrl multiSelectCtrl;
		
        Query query = new Query();
        QueryBuildDataSource qbds = query.addDataSource(tableNum(VendTable));
        qbds.addSelectionField(fieldnum(VendTable,VendAccount));

        multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(this, Form1_Vendor, query, false);  

    }

}

OR


class Form1_EventHandler
{
    
    [FormControlEventHandler(formControlStr(Form1, Form1_Vendor), FormControlEventType::Lookup)]
    public static void Form1_Vendor_OnLookup(FormControl sender, FormControlEventArgs e)
    {
        FormStringControl vendor = sender.formRun().design().controlName(formControlStr(Form1, Form1_Vendor)) as FormStringControl;

        SysLookupMultiSelectCtrl multiSelectCtrl;
		
        Query query = new Query();
        QueryBuildDataSource qbds = query.addDataSource(tableNum(VendTable));
        qbds.addSelectionField(fieldnum(VendTable,VendAccount));

        multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query, false);

    }

}

2. using both ways, the lookup works but when i select multiple values, the control doesn't show them, it stays empty. I read i need to use set, but didn't understand how to use it, can u show me and explain please?
i can see examples on dialogs where they don't use set

Categories:

Dynamics 365 Finance

Hello,

Please try this code :

[ExtensionOf(formStr(Form1))]
final class Form1_Extension
{
SysLookupMultiSelectCtrl multiSelectCtrl_Vendor;
Set vendorSet; // stores selected accounts

public void init()
{
next init();

vendorSet = new Set(Types::String);

// Build lookup query
Query query = new Query();
QueryBuildDataSource qbds = query.addDataSource(tableNum(VendTable));
qbds.addSelectionField(fieldNum(VendTable, VendAccount));

// Create the multi-select lookup control
multiSelectCtrl_Vendor = SysLookupMultiSelectCtrl::constructWithQuery(
this,
Form1_Vendor,
query,
false);

if (vendorSet.elements() > 0)
{
multiSelectCtrl_Vendor.set(vendorSet);
Form1_Vendor.text(this.setToString(vendorSet));
}
}

// Called when user selects values in the lookup
public boolean Form1_Vendor_modified()
{
boolean ret = next Form1_Vendor_modified();
vendorSet = multiSelectCtrl_Vendor.get();
Form1_Vendor.text(this.setToString(vendorSet));

return ret;
}

// Helper method — convert Set to comma-separated string
private str setToString(Set _set)
{
str result = "";
SetEnumerator setEnum = _set.getEnumerator();

while (setEnum.moveNext())
{
result += (result == "" ? "" : ", ") + setEnum.current();
}

return result;
}
}

Quick Links