Tracking user who are changing queries

Payal Sen
Payal Sen
Second Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Raiser's Edge NXT®: General Discussions

I have a couple of people in the team who take in really complex queries and change them, which is causing reporting issues. I know there is a way to turn off the option under tools in the query. But is there a way to track what has already been changed?

Tagged:

Answers

  • Aldera Chisholm
    Aldera Chisholm Community All-Star
    Sixth Anniversary Kudos 5 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge First Reply

    I don't believe you can track "what" has been changed, just who changed it last. This sounds like a training opportunity to educate users - if users can't be trusted to maintain your queries, they shouldn't have access to them as there are likely other issues happening as well. (PS For key queries that impact reports/business rules etc, I add a note in the description "Do not edit - this query is used in x Report")

  • Payal Sen
    Payal Sen
    Second Anniversary Kudos 1 Name Dropper Participant

    Thank you for the tip it this helpful

  • Andrea Wilson
    Andrea Wilson
    Tenth Anniversary Kudos 1 Participant Facilitator 1
    image.png

    When we have set up a query that has dependent reports/processes etc we remove the tick from the 'others can modify' setting, which can be found in the 'Options' area of queries in WebView (in the Tools, Query Options menu in Database View).

    We rarely prevent users from running a query but its nice to have that option too.

Categories