The query field Constituent/Prospect/Prospect Manager/Name returns prospect managers that have been end-dated.
The query field Constituent/Prospect/Prospect Manager/Name field returns prospect managers that have been end-dated, if no new prospect manager has been assigned.
This makes it difficult to pull a simple list of prospects without managers. It would be much cleaner if this field considered the current date and displayed a blank for prospect managers whose time as lapsed.
This makes it difficult to pull a simple list of prospects without managers. It would be much cleaner if this field considered the current date and displayed a blank for prospect managers whose time as lapsed.
-
Guest
- Nov 9 2015
- Reviewed: Voting Open
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +10
Related ideas
The query field Wealth Information/Prospect Manager Name also returns a value for an end-dated prospect manager.
Additionally, on the Wealth and Ratings page, the end-dated prospect manager shows under the "Research Details" sections with the label: "Prospect manager"
Attachments Open full size
In my query criteria, I used "Prospect\Prospect Manager\Date to" is blank. I should have gone up 1 level, and used "Prospect\Prospect manager end date" is blank. This worked for me.
Attachments Open full size