Getting extra fields in multiselect lookup grid

(2) Share

Report

Posted on by Dineshkarlekar

1,836

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

I have the same question (0)

All responses (7)

Answers (0)

Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,183 Super User 2025 Season 2 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (1)

Report

Hi Dinesh,

So u created a new form of type dialog?

What are the datasources?

Please take a screenshot

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (1)

Report
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

Was this reply helpful? Yes No