Getting extra fields in multiselect lookup grid

(2) Share

Report

Posted on by Dineshkarlekar

1,678

In my custom lookup grid i am getting more fields i need only two fileds company and name , but it is showing other fields in grid also how can i limit it to only fields required ,

when i select data from company info it get only two fields but when i apply filter to the lookup it get more than two fields , how can i make them show only fields required .

here is the gird .

  public void lookup()
        {
            super();
            
            OMUserRoleOrganization omOrg;
            boolean hasOrgAccess = false;

            // Check if the current user has any organization access records
            select firstonly RecId from omOrg
        where omOrg.User == curUserId();

            hasOrgAccess = (omOrg.RecId != 0);

            Query query = new Query();
            QueryBuildDataSource qbdsCompany = query.addDataSource(tablenum(CompanyInfo));
    
            qbdsCompany.addSelectionField(fieldNum(CompanyInfo, DataArea));
            qbdsCompany.addSelectionField(fieldNum(CompanyInfo, Name));

            if (hasOrgAccess)
            {
                QueryBuildDataSource qbdsOrg = qbdsCompany.addDataSource(tablenum(OMUserRoleOrganization));
                qbdsOrg.relations(false);
                qbdsOrg.joinMode(JoinMode::InnerJoin);
                qbdsOrg.addLink(
            fieldnum(OMUserRoleOrganization, omInternalOrganization),
            fieldnum(CompanyInfo, RecId));
        
                qbdsOrg.addRange(fieldnum(OMUserRoleOrganization, User)).value(queryValue(curUserId()));
            }

            msLookupCtrl = SysLookupMultiSelectCtrl::constructWithQuery(this.formRun(), this, query);
            msLookupCtrl.set(msLookupCtrl.getSelectedFieldValues());

        }

Categories:

Dynamics 365 Project Operations

All responses (7)

Answers (0)

Dineshkarlekar 1,678 on at

Like (1)

Report
Getting extra fields in multiselect lookup grid

hi @Layan Jwei

the string is not bound to datasource , it is simple string field i have override the lookup method on it .

the from data source is
OMUserRoleOrganization
Layan Jwei 7,898 Super User 2025 Season 1 on at

Like (1)

Report

Getting extra fields in multiselect lookup grid

Hi Dinesh,

So you created a new form with pattern dialog?

What are the datasources (please take a screenshot)

And this form string control, is it bound to a datasource?
Layan Jwei 7,898 Super User 2025 Season 1 on at

Like (1)

Report

Getting extra fields in multiselect lookup grid

Hi Dinesh,

So u created a new form of type dialog?

What are the datasources?

Please take a screenshot
Dineshkarlekar 1,678 on at

Like (1)

Report

Getting extra fields in multiselect lookup grid

hi @André Arnaud de Calavon

thanks for reply ,

I am using this lookup code on from string control , it is custom dialogue form.

Thanks,

Regards ,

Dinesh
André Arnaud de Cal... 296,017 Super User 2025 Season 1 on at

Like (1)

Report

Getting extra fields in multiselect lookup grid

Hi Dinesh,

Where exactly are you using this coding? Is it on a new table or is it an extension to override an existing lookup? If so, have you verified if the current lookup with all fields is a standard lookup?
Dineshkarlekar 1,678 on at

Like (0)

Report

Getting extra fields in multiselect lookup grid

hi @Layan Jwei,

thanks for reply,

when i am getting the data from table inside if condition it gets all this fields in lookup, but i only want it to show company and name , and out of if conditio it is showing only two name ie company and name which is fine the grid in below image is coming from omuserorgainsation table within if condition i want only two fields Company and name.

i want to show grid this much only

not this much.
Layan Jwei 7,898 Super User 2025 Season 1 on at

Like (0)

Report

Getting extra fields in multiselect lookup grid

Hi

What do you mean by when when you select data from company info, you only get two fields? But when u filter you get more?