Finance | Project Operations, Human Resources, ...

Selection field returns wrong column label on lookup

(4) Share

Report

Posted on by RadekM

178

Hello,

I'm trying to create a lookup but I have a difficulty setting the right labels for them.

Like below the label for CustomerRef field is totaly not what it should be. How can I fix it? Tried to change to addSelectionFieldWithAlias but I'm getting and error 'Query selection aliases are not supported in the native stack'

 fsCtrlMultiSelect = formRun.design().control(fbsCtrlMultiSelect.id());
           Query query = new Query();

           if(tableId == CustInvoiceJour.Tableid)
            {
                QueryBuildDataSource qbds = query.addDataSource(tableNum(CustinvoiceJour));
                qbds.addSelectionField(fieldNum(CustinvoiceJour, InvoiceId));
                qbds.addSelectionField(fieldNum(CustinvoiceJour, InvoiceDate));
                qbds.addSelectionField(fieldNum(CustinvoiceJour, OrderAccount));
                qbds.addSelectionField(fieldNum(CustinvoiceJour, InvoicingName));
            }
            else if(tableId == CustPackingSlipJour.TableId)
            {
                QueryBuildDataSource qbds = query.addDataSource(tableNum(CustPackingSlipJour));
                qbds.addSelectionField(fieldNum(CustPackingSlipJour, PackingSlipId));
                qbds.addSelectionField(fieldNum(CustPackingSlipJour, OrderAccount));
                qbds.addSelectionField(fieldNum(CustPackingSlipJour, SalesId));
                qbds.addSelectionField(fieldNum(CustPackingSlipJour, CustomerRef))
                //bds.addSelectionFieldWithAlias("reference", fieldNum(CustPackingSlipJour, CustomerRef));
                qbds.addSelectionField(fieldNum(CustPackingSlipJour, InvoicingName));
            }
            else
            {
                return;
            }

            msCtrl = SysLookupMultiSelectCtrl::constructWithQuery(formRun, fsCtrlMultiSelect, query);

All responses (5)

Answers (0)

Sort by

Suggested answer

Jonas "Jones&q... 5,016 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The alias is not used when SysLookupMultiSelect* builds the grid, notice the call to addDataField.

I haven't found, and am unaware of, any generic multi-select lookups where you can specify your own labels.

You will either have to create your own custom lookup form or develop your own SysLookupMultiSelect classes that extend from SysLookupMultiSelectCtrl and SysLookupMultiSelectGrid and can accept custom labels.
Suggested answer

Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you want to set a label for what? Can you show me screenshot of the lookup issue?

Thanks,

Waed Ayyad
RadekM 178 on at

Like (1)

Report
Copy link

Link copied!
This label

is certainly not this

And the problem is bigger while I'm using a different language in AX than English.

It doesn't even have the correct translate for me since it should show me something like 'User reference number' so nothing compareable to what actually is in this field stored.
CustPackingSlipJour, CustomerRef

Users hate it and want me to add THIS field since the labels are so different so even while they see the data in this field is what they want it is just wrong for them and want to add the field they want.
Suggested answer

Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can change the field label on the table level using extension, but you should know this will affect all screens that use the field in the system, another idea creates a display method that returns the field and use it instead of the field.

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue
RadekM 178 on at

Like (1)

Report
Copy link

Link copied!

I can't use it as a display because they need this field to filter.