Retrieve a list of people using rows

Some tooltip text!

• 1 minute to read

 • 1 minute to read

Let’s explore how to retrieve a list of persons using rows.

using SuperOffice.CRM.Entities;
using SuperOffice.CRM.Rows;
using SuperOffice;
using(SoSession mySession = SoSession.Authenticate("SAL0", ""))
{
  //get the person rows of the persons we want using the contact id that they belong to
  PersonRows myPersonRows = PersonRows.GetFromIdxContactId(21);
  //iterate through the row collection and access its properties
  if (myPersonRows.Count > 0)
  {
    foreach (PersonRow myPersonRow in myPersonRows)
    {
      cmbPersonName.Items.Add(myPersonRow.Firstname + " " + myPersonRow.Lastname);
    }
  }
}

The code in the above example is similar to retrieving a list of persons using entities. The only difference is that we have used rows to do the operation for us.

Here, we retrieve the list of persons as a person rows collection to a PersonRows object using the contact ID of the contact that the people we want belong to.

Once we have the person row collection, it is a matter of iterating through the collection to access the individual properties of a PersonRow like we have done above in the example.