Create gift query of committed gifts in webview

In database view this is an option that we use to pull our gift batch reports, for auditing purposes, based on the committed number given batch...but in web view we have to create the query once the batch is approved. This has created unnecessary steps and is not efficient.

  • Guest
  • Mar 11 2026
  • Reviewed: Voting Open
  • Attach files
  • Sunshine Reinken Watson ⭐Community All-Star commented
    22 Jul 20:34

    This is very helpful in the DBV, especially when creating acknowledgements by batch or doing an audit of batch gifts.

  • Mikaela Hartmann commented
    09 Jul 22:45

    Yes, please add this! Our Finance team uses the query that is created after a batch is posted to find gifts and push them into FE. If a query does not get created, they cannot find the gifts, so we have to go into database and create a static query for all gifts that get processed in NXT.

  • Nancy Mahala commented
    09 Jul 15:27

    I create a query for every single gift batch I process that requires an acknowledgement (which is about 99% of our gifts). It is an extra step that could easily be eliminated if the static query could be created when approving the batch. It is such a needless extra step that we did not have with database view. I then use the query to run both thank you letters and envelopes in Word via mail merge. I am trying to use NXT batch as much as possible, but I frequently forget to create the query. Really makes gift processing inefficient.