Finance | Project Operations, Human Resources, ...

Lookup event handler method is not being called more than once

(0) Share

Report

Posted on by ..

1,965

Hi,

I added a code to the lookup method of the customized control that I created. As you can see that there is a range based on the value of another customized control.
So if the customerContract value changed, then the lookup method should return something else.
And when debugging, i've noticed that the lookup event handler method is only called once when debugging, so currently when the customer contract value changes, the value in the lookup is still the same, i need to close the form and open it again to see the change.

I noticed that this happens for multi select lookup only, i have other lookup methods without multi select, and the method is called all the time.

    [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));
        qbds1.addSelectionField(fieldNum(ProjValEmplProjSetup, Projid));
        qbds2.addSelectionField(fieldNum(Table1, OrderNumber));
        multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query);
        FormRun formRun = sender.formRun();
        formRun.AAMultiSelectCtrl(multiSelectCtrl);
        

    }

I have the same question (0)

All responses (23)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report
Hi IntegrationBeginner,

I think that may be due to the SysLookupMultiSelectCtrl class. I think you need to update the query with the latest values.

To update the lookup based on the selected values of another control you can call the refreshQueury method of SysLookupMultiSelectCtr l class.

Create new method - In this method you build the same query you added for the lookup - Return type should be query.

Add the below method which will return a query.

Public Query buildQuery(CustomerId _id) { 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(_id)); qbds.addSelectionField(FieldNum(ResourceView, ResourceId)); qbds.addSelectionField(FieldNum(ResourceView, Name)); qbds1.addSelectionField(fieldNum(ProjValEmplProjSetup, Projid)); qbds2.addSelectionField(fieldNum(Table1, OrderNumber)); return query; }

Add the below code in the modified method of the CustomerContractLookup control to refresh the multi select lookup query.

multiSelectCtrl.refreshQuery(this.buildQuery(customerContract.text()));

Thanks,

Girish S.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report
Hi Girish,

I'm getting "variable multiSelectCtrl is not found in scope" error, when calling refresh query

Here's what I did:
class AACaseDetailCreate_EventHandler { [FormControlEventHandler(formControlStr(CaseDetailCreate, AACustomerContract), FormControlEventType::Modified)] public static void AACustomerContract_OnModified(FormControl sender, FormControlEventArgs e) { multiSelectCtrl.refreshQuery(sender.formRun().buildQuery(sender.valueStr())); } [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)); qbds1.addSelectionField(fieldNum(ProjValEmplProjSetup, Projid)); qbds2.addSelectionField(fieldNum(Table1, OrderNumber)); multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query); FormRun formRun = sender.formRun(); formRun.aaMultiSelectCtrl(multiSelectCtrl); } }

[ExtensionOf(formStr(CaseDetailCreate))] final class CaseDetailCreateAA_Extension { public SysLookupMultiSelectCtrl multiSelectCtrl; public SysLookupMultiSelectCtrl aaMultiSelectCtrl(SysLookupMultiSelectCtrl _multiSelectCtrl = multiSelectCtrl) { multiSelectCtrl = _multiSelectCtrl; return multiSelectCtrl; } Public Query buildQuery(Table1OrderNumber _customerContract) { 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)); qbds.addSelectionField(FieldNum(ResourceView, ResourceId)); qbds.addSelectionField(FieldNum(ResourceView, Name)); qbds1.addSelectionField(fieldNum(ProjValEmplProjSetup, Projid)); qbds2.addSelectionField(fieldNum(Table1, OrderNumber)); return query; } }

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

Like (0)

Report

Since you are using event handler its difficult to get the multiselect control buffer.

So try one thing you are passing the mutliselect buffer to the form methods on the lookup(Line number 24).

On the modified event handler try to get the multiselect control buffer using the AAMultuSelectCtrl method and call then call the refresh query using that buffer.

Thanks,

Girish S.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Girish,

It worked but there is still an issue with the lookup.

So i filled customer contract with value A, then the lookup for worker showed correct records where i selected worker 1

then i went to the customer contract and changed it's value to B -- the worker field is now empty, now I'm expecting the lookup to not return anything for the worker, as there are now workers for that contract, and correct it returned nothing. However, the moment i clicked on the lookup for worker, it filled it with the previous value selected which was worker 1 but worker 1 wasn't in the lookup in the first place

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

Like (0)

Report

You need to debug the code and find the issue.

Thanks,

Girish S.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Girish,

I debugged, but I can't find the issue.

a simpler way to describe the issue:

So i filled customer contract with value A, then the lookup for worker showed correct records where i selected worker 1.
if i delete the worker value from the field and click on the lookup again, the lookup show the old value as selected, so if i click in the empty space without selecting it, the field gets filled with this value anyway..any idea?

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

Like (0)

Report

Try to print the query in the modified method of customer control.

sender.formRun().buildQuery(sender.valuestr()).toString();

Also please paste the query output here.

Thanks,

Girish S.

Was this reply helpful? Yes No

1,965 on at

Like (0)

Report

Hi Girish,

I now call the build query method in the modified method of the "worker" control and "customer contract" control

and i had to reset control value with conNull() as well

But i have one last issue now. When i first click the dialog and click on the lookup control of the worker it doesn't return anything... i have to click it twice to see the lookup result

class AACaseDetailCreate_EventHandler
{
    
    [FormControlEventHandler(formControlStr(CaseDetailCreate, AACustomerContract), FormControlEventType::Modified)]
    public static void AACustomerContract_OnModified(FormControl sender, FormControlEventArgs e)
    {
    
        if(sender.valueStr())
        {

            multiSelectCtrl.set(conNull());

        }
        multiSelectCtrl.refreshQuery(sender.formRun().buildQuery(sender.valueStr()));
    }
    
    [FormControlEventHandler(formControlStr(CaseDetailCreate, AAWorker), FormControlEventType::Modified)]
    public static void AAWorker_OnModified(FormControl sender, FormControlEventArgs e)
    {
        FormStringControl customerContract = sender.formRun().design().controlName(formControlStr(CaseDetailCreate, AACustomerContract)) as FormStringControl;
        FormRun formRun = sender.formRun();
        SysLookupMultiSelectCtrl workerMultiSelectCtrl = formRun.aaMultiSelectCtrl();
        if(sender.valueStr() == '')
        {
            if(workerMultiSelectCtrl)
            {
                workerMultiSelectCtrl.set(conNull());
            }
        }

        workerMultiSelectCtrl.refreshQuery(formRun.buildQuery(customerContract.text()));

    }
    


    [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(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));
            qbds1.addSelectionField(fieldNum(ProjValEmplProjSetup, Projid));
            qbds2.addSelectionField(fieldNum(Table1, OrderNumber));
            multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query);
            FormRun formRun = sender.formRun();
            formRun.aaMultiSelectCtrl(multiSelectCtrl);
        }
        else
        {
            SysLookupMultiSelectCtrl multiSelectCtrl;
            Query query = new Query();
            QueryBuildDataSource qbds = query.addDataSource(tableNum(HcmWorkerDetailsView));
            qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, AAPersonnelNumber));
            qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, Name));
            multiSelectCtrl = SysLookupMultiSelectCtrl::constructWithQuery(sender.formRun(), sender, query);
            FormRun formRun = sender.formRun();
            formRun.aaMultiSelectCtrl(multiSelectCtrl);
        }
    }
}

[ExtensionOf(formStr(CaseDetailCreate))]
final class CaseDetailCreateAA_Extension
{
    public SysLookupMultiSelectCtrl multiSelectCtrl;
    
    public SysLookupMultiSelectCtrl aaMultiSelectCtrl(SysLookupMultiSelectCtrl _multiSelectCtrl = multiSelectCtrl)
    {
        multiSelectCtrl = _multiSelectCtrl;
        return multiSelectCtrl;
    }
    
       Public Query buildQuery(Table1OrderNumber _customerContract)
    {
        Query query;
        if(_customerContract != '')
        {
            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));

            qbds.addSelectionField(FieldNum(ResourceView, ResourceId));
            qbds.addSelectionField(FieldNum(ResourceView, Name));
            qbds1.addSelectionField(fieldNum(ProjValEmplProjSetup, Projid));
            qbds2.addSelectionField(fieldNum(Table1, OrderNumber));
        }
        else
        {
            query = new Query();
            QueryBuildDataSource qbds = query.addDataSource(tableNum(HcmWorkerDetailsView));
            qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, AAPersonnelNumber));
            qbds.addSelectionField(FieldNum(HcmWorkerDetailsView, Name));
        }
    
        return query;
    }
}

Was this reply helpful? Yes No

GirishS 27,827 Moderator on at

Like (0)

Report

What is the edt used for the worker control?

Thanks,

Girish S.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Girish,

HcmPersonnelNumberId

Was this reply helpful? Yes No