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.
  • Guest
  • Nov 9 2015
  • Reviewed: Voting Open
Organization Name (Please enter full organization name)
Reported Version
  • Attach files
  • Pong Yeung commented
    July 19, 2016 20:24

    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.

  • Rob Downs commented
    July 05, 2018 15:24

    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"