fixed the 'related accounts' query return type so that it would screen out related accounts which have end dates

Logically, a "related accounts" query should pull accounts which currently have a relationship. If I put an 'end date' on a relationship, it means the relationship no longer exists, and the corresponding accounts should not show up - but they do. For example, we track our member churches and their staff, using a "church /staff memberf" relationship. We can't get a list of people currently working in our churches, because the former employees (with end dates) show up too. (A workaround compound query screening out all relationships with "end dates" is not an option, because that will screen out all people who have ever left a job at one church, even if they are now working at another.)
  • Guest
  • Aug 7 2015
  • Attach files
  • +45