Monday, May 26, 2025

X++ code to get the specific legal entities locations

 public void MultiSelectLookup(FormStringControl _control)

{
     Query          query = new  query();
     Container      cont;
     CompanyInfo    companyInfo = CompanyInfo::findDataArea("INMF");

 

     QueryBuildDataSource    qbds = query.addDataSource(tableNum(DirPartyPostalAddressView));

 

     QueryBuildRange    qbr1,qbr = qbds.addRange(fieldNum(DirPartyPostalAddressView,Party));
     qbr.value(SysQuery::value(companyInfo.RecId));

 

     qbr1 = qbds.addRange(fieldNum(DirPartyPostalAddressView, ValidTo));
     qbr1.value(strFmt(">%1", date2Str(today(), 123, DateDay::Digits2, DateSeparator::Slash,
                                  DateMonth::Digits2, DateSeparator::Slash, DateYear::Digits4)));
     qbds.addSelectionField(fieldNum(DirPartyPostalAddressView, LocationName));
     qbds.addSelectionField(fieldNum(DirPartyPostalAddressView, Address));
     sysLookupMultiSelectGrid::lookup(query, _control, _control, _control, cont);
}


---------------------------------------






No comments:

Post a Comment