Finance | Project Operations, Human Resources, ...

lookup based on condition doesn't work directly and the UI for both lookups is different

(0) Share

Report

Posted on by ..

2,003

Hi,

I have this lookup code:

    /// 
    ///
    /// 
    /// 
    /// 
    [FormControlEventHandler(formControlStr(CaseDetailCreate, AAWorker), FormControlEventType::Lookup)]
    public static void AAWorker_OnLookup(FormControl sender, FormControlEventArgs e)
    {
        FormStringControl customerContract = sender.formRun().design().controlName(formControlStr(CaseDetailCreate, AACustomerContract)) as FormStringControl;

        if(customerContract.text() != '')
        {
            SysLookupMultiSelectCtrl multiSelectCtrl;
            Query query = new Query();
            QueryBuildDataSource qbds = query.addDataSource(tableNum(ResourceView));
            QueryBuildDataSource qbds1 = qbds.addDataSource(tableNum(PROJVALEMPLPROJSETUP));
            Qbds1.joinMode(JoinMode::InnerJoin);
            Qbds1.addLink(fieldNum(ResourceView, RecId), fieldNum(PROJVALEMPLPROJSETUP, Resource));
            QueryBuildDataSource qbds2 = qbds1.addDataSource(tableNum(AATable1));
            qbds2.joinMode(JoinMode::InnerJoin);
            qbds2.addLink(fieldNum(PROJVALEMPLPROJSETUP, ProjId), fieldNum(AATable1, OrderNumber));
            qbds2.addRange(fieldNum(AATable1, OrderNumber)).value(queryValue(customerContract.text()));

            qbds.addSelectionField(FieldNum(ResourceView, ResourceId));
            qbds.addSelectionField(FieldNum(ResourceView, Name));
            multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query);
        }
        else
        {
            SysLookupMultiSelectCtrl multiSelectCtrl;
            Query query = new Query();
            QueryBuildDataSource qbds = query.addDataSource(tableNum(HcmWorkerDetailsView));
            qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, PersonnelNumber));
            qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, Name));
            multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query);
        }
    }

1. the lookup field is on a dialog, and as you can see the lookup depends on another form control. When the dialog is still open, if i change the value of the control to match the other lookup it doesn't work, it keeps showing the old one until i close the dialog and open it again... how to solve this?

2. The UI for both lookups is different, why? i want them both to be the same things, as you can see for the hcmworkerDetailsView i only selected 2 fields but i can still see a lot of fields

however the other lookup looks good and smaller in size.. why is that?

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!
Hi,

Please try to debug and see what values you are getting from the control.

Use the following code to disable dynamic fields on your other datasources which will then not be included in the lookup fields:
queryBuildDataSource.fields().dynamic(NoYes::No);

Regards,

Kamal

Was this reply helpful? Yes No
.. 2,003 on at

Like (0)

Report
Copy link

Link copied!
Hi Kamal,

1.As for the debug point. When I first opened the dialog form, and clicked on the lookup, the eventhandler was called, when I clicked on the lookup again, the event handler wasn't called. Why is that? and the UI is still different

2. The dynamics field didn't work
else { SysLookupMultiSelectCtrl multiSelectCtrl; Query query = new Query(); QueryBuildDataSource qbds = query.addDataSource(tableNum(HcmWorkerDetailsView)); qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, PartyNumber)); qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, Name)); qbds.fields().dynamic(NoYes::No); multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query); }

3. Now since I filled multiple selects in the control. I want on the clicked method to insert those workers in the caseAssociation grid.. how can I get each value from the multi select?

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi IntegrationBeginner,

You need to make use of getSelectedFieldValues method of SysLookupMultiSelectCtrl class to get the selected values line below.

Container con; con = multiSelectCtrl.getSelectedFieldValues();

It will return as container and you can loop through the values.

Thanks,

Girish S.

Was this reply helpful? Yes No
.. 2,003 on at

Like (0)

Report
Copy link

Link copied!

Hi Girish,

I want to get the values from another control and not in the lookup method.

so in another control clicked method i want to loop through the multi selected values in another control. How to do that?

Was this reply helpful? Yes No
Suggested answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi IntegrationBeginner,

If you declare the SysLookupMultiSelectCtrl multiSelectCtrl globally which means in the form declaration itself, you can access the buffer in any if the form methods.

Thanks,

Girish S.

Was this reply helpful? Yes No
.. 2,003 on at

Like (0)

Report
Copy link

Link copied!

Hi Girish,

How about the extra fields appearing in the lookup?

even though i specified only 2 fields using addSelectionField but alot are appearing as i described in previous comments

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!
SysLookupMultiSelectCtrl::constructQuery arguments takes the container as parameter for showing fields in the lookup. Try passing the required fields to that and check.

multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query, [tableNum(TableName), fieldNum(TableName,FieldName)]));

Thanks,

Girish S.

Was this reply helpful? Yes No
.. 2,003 on at

Like (0)

Report
Copy link

Link copied!
Hi Girish,

So you don't want me to use add selection field, right?

can you give me the syntax exactly for multiple fields as i'm getting errors on it

multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query, false, [(tableNum(ResourceView), fieldNum(ResourceView,ResourceId)), (tableNum(ResourceView), fieldNum(ResourceView,Name)));

here's what i did:
[FormControlEventHandler(formControlStr(CaseDetailCreate, AAWorker), FormControlEventType::Lookup)] public static void AAWorker_OnLookup(FormControl sender, FormControlEventArgs e) { FormStringControl customerContract = sender.formRun().design().controlName(formControlStr(CaseDetailCreate, AACustomerContract)) as FormStringControl; SysLookupMultiSelectCtrl multiSelectCtrl; Query query = new Query(); QueryBuildDataSource qbds = query.addDataSource(tableNum(ResourceView)); QueryBuildDataSource qbds1 = qbds.addDataSource(tableNum(PROJVALEMPLPROJSETUP)); qbds1.joinMode(JoinMode::InnerJoin); qbds1.addLink(fieldNum(ResourceView, RecId), fieldNum(PROJVALEMPLPROJSETUP, Resource)); QueryBuildDataSource qbds2 = qbds1.addDataSource(tableNum(Table1)); qbds2.joinMode(JoinMode::InnerJoin); qbds2.addLink(fieldNum(PROJVALEMPLPROJSETUP, ProjId), fieldNum(Table1, OrderNumber)); qbds2.addRange(fieldNum(Table1, OrderNumber)).value(queryValue(customerContract.text())); //qbds.addSelectionField(FieldNum(ResourceView, ResourceId)); //qbds.addSelectionField(FieldNum(ResourceView, Name)); multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query, false, [(tableNum(ResourceView), fieldNum(ResourceView,ResourceId)), (tableNum(ResourceView), fieldNum(ResourceView,Name))]); FormRun formRun = sender.formRun(); formRun.AAMultiSelectCtrl(multiSelectCtrl); }

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!
Yo already said that adding selection field doesn't work. That's why I have given an alternate suggestion.

Try the below code.

container selectedFields = [tableNum(ResourceView),fieldnum(ResourceView,ResourceId),fieldnum(ResourceView,Name)]; multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query, false, selectedFields);

Thanks,

Girish S.

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Edited the code. You can initialize container and add fields to that.

Thanks,

Girish S.

Was this reply helpful? Yes No