Make reciprocated status of relationships searchable

Currently there's no way to run a query on RE based on relationships that are connected to full constituent records, but that were not chosen to be reciprocated at the time they were created. It would be very useful for pinpointing clean-up efforts if there was a field within queries that would indicate if a relationship is reciprocated or not.

My organization uses relationships heavily, and we've had RE for many years. I have a strong suspicion that there are many existing relationship records between individual and org records that were created without the relationship record being reciprocated onto the org's record (or vice versa) -- this would have been done in error. I've stumbled across some records that support this suspicion, and now I'm running into a situation where my Crystal Report that is pulling in two separate data sets that are basically tied together via relationship data and numbers of how many individuals have a relationship with a given organization record is off for no apparent reason (the count is higher than what actually appears on the org's RE record in the relationship tab).

  • Guest
  • Jan 30 2016
  • Attach files