How to get records from selected company.

Hi All,

In this blog we will learn how to get data from table for the selectable company.

CustTable custTable;
container containerCompany = ['DAT','USMF'];

while select crossCompany :conCompanies
    * from custTable
{
    //do the logic here.
}

In the above code we are declaring the list of companies to the container variable. In the select statement we are mentioning the container using colon operator - This makes the select statement to return only data from the company mentioned in the container variable.

Thanks.