Enable Query of Constituent Recognition Credit Defaults
We discovered that constituent recognition credit defaults are not removed when the relationship that generated them is deleted. We have a separate Idea Bank request to generate a warning when deleting a relationship that generates rec credit defaults. But we also need to be able to use the Query tool to find constituents who have multiple Spouse/Life Partner Recognition Credit Defaults (for example). The Constituent Recognition Credit Default fields are not available in the Query tool and we request that they be added. Thanks.
-
Guest
- Jun 29 2015
- Reviewed: Voting Open
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- +9
Related ideas
I've also found that when the 'Apply to...' box on the relationship form is unticked when disolving a relationship, the row in the recognition defaults table is not removed, leading to orphaned data in the database.
In our case, it's lead to the inability to remove a code table entry until all instances of it are removed, even though they don't show on the relationship record. Only BB can query on these entries so I'm reliant on them to run a script to get the data, and then we need to manually adjust the record so that the table entry can be deleted.
The removal of the tick should be remove the rows in the back end, not orphan records.
We've discovered over 7000 recognition credits without a specified type. In the process of researching this issue, we'd like to look at the recognition defaults for each of these revenue transactions, but without the query tool - we can't.
That is a good idea-I don't always think about the recognition credits when I dissolve a household in the event of a divorce...