1. Create a new constituent query of the desired records.
  2. Create a new constituent export and include the query created in Step 1.
  3. On the Output tab, select Relationships, Assigned Solicitors, Name.
  4. In the Criteria window, enter 2 in the Number of Assigned Solicitors to export field.
    NOTE: Even if only one assigned solicitor is desired, at least 2 must be exported for the sort option to function. Otherwise, only the first one found will export.
  5. Select the desired Solicitor types (if necessary).
  6. In the Order By field, select Date Added and mark the Descending radio button.
  7. Click OK
  8. Click Export Now.