Dynamics Community Forum Thread Details

Data entity lookup up of a field issue

Hi,

I am trying to add lookup for a field CompanyLocation in my entity .It is a custom entity and I tried to get lookup for the field. When I try to get the locationId from LogisticsLocation, it is working , but I want the description also.

My questions:

1. Can I add 2 fields in lookup (Location Id and Description )?

2. If not how can I add description in lookup . When i tried just description it shows nothing. But the same is working if I locationID. Am i missing anything?

Please see my lookup method added to the entity.

 [
     SysODataAction("NewVendInvoiceJournalLineEntityCompanyLocMappedCustomLookup", false),
     SysODataCollection("_fields", Types::String),
    SysODataFieldLookup(fieldStr(NewVendInvoiceJournalLineEntity, LocationIdCompany))
 ]
 public static str companyLocMappedCustomLookup(Array _fields)
 {
     // Field to return
     RefFieldName companyLocFld = fieldStr(NewVendInvoiceJournalLineEntity, LocationIdCompany);

     // Map fields for Office Add-in
     Map fieldMap = OfficeAppCustomLookupHelper::getFieldMap(
     tableStr(NewVendInvoiceJournalLineEntity),
     _fields
 );

     OfficeAppCustomLookupListResult result = new OfficeAppCustomLookupListResult();
     result.determinationFields().value(1, companyLocFld);

     LogisticsLocation logisticsLoc;
     int counter = 1;

     // Build lookup items
     while select Description,locationId from  logisticsLoc order by locationId
     {
       //  result.items().value(counter, logisticsLoc.Description);
         result.items().value(counter, logisticsLoc.LocationId);
         counter++;
     }

     return result.serialize();

 }

Please help.

Thanks,

Priya

Categories:

Dynamics 365 Finance

while select Description, LocationId from logisticsLoc order by LocationId { // First Column - Location Id if (fieldMap.exists(fieldStr(LogisticsLocation, LocationId))) { result.items().value(counter, logisticsLoc.LocationId, fieldMap.lookup(fieldStr(LogisticsLocation, LocationId))); } else { result.items().value(counter, logisticsLoc.LocationId); } // Second column - Description if (fieldMap.exists(fieldStr(LogisticsLocation, Description))) { result.items().value(counter, logisticsLoc.Description, fieldMap.lookup(fieldStr(LogisticsLocation, Description))); } else { result.items().value(counter, logisticsLoc.Description); } counter++; }

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL