With the most recent RE update, Export has reverted to behavior from before RE version 7.96.6401 Patch 5. About 2-1/2 years ago, once Patch 5 was installed, we were able to export a current solicitor by choosing to output only one Assigned Solicitor with a specific solicitor type and by putting the current date in the Date From criteria. This was true of exporting a primary constituency code as well. Today, when following the same steps, the recent updates now export a past solicitor who has an End Date filled in. And, in the case of constituent codes, either NO constituency code exports or you get an incorrect code (with a Date To filled in). According to Blackbaud Support, "The way you were previously using it was actually an issue in the system and in the recent patch was fixed." So they took something that was working and made it no longer work. Here's the Knowledgebase Article information, I saved from 2016:
In a Constituent Export, using Start Date and/or End Date criteria when exporting Assigned Solicitor information to filter on Date from and Date to on the assigned solicitor relationship, The Raiser's Edge incorrectly outputs assigned solicitors that do not meet the criteria.
Article Number: 74279
Products: Raiser's Edge RE
This was resolved in Raiser's Edge 7.96, which was released in fall 2016 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, if applicable.