Add GFLink Field to Query Output

Currently, Query (in both database view and web view) does not allow the GFLink (the field that indicates which pledge a payment or write-off is connected to) to be added to the output. Without this field it is impossible to connect a pledge payment or write-off to the original pledge, which in turn makes it very difficult to report on pledges.

  • James Belich
  • Jun 2 2025
  • Reviewed: Voting Open
Analysis
  • Attach files
  • Alex Wong commented
    06 Oct 15:55

    If Blackbaud really want to get granular...

    • Pledge A $500

      • Installment 1 $200

      • Installment 2 $200

      • Installment 3 $100

    • Pledge B $800

      • Installment 1 $400

      • Installment 2 $400

    • Payment A $1000

      • GFLink Pledge A Installment 1 $200

      • GFLink Pledge A Installment 2 $150

      • GFLink Pledge B Installment 1 $400

      • GFLink Pledge B Installment 2 $250

    • Writeoff A $150

      • GFLink Pledge A Installment 2 $50

      • GFLink Pledge A Installment 3 $100

    • Writeoff B $100

      • GFLink Pledge B Installment 2 $100

    Pledge A Balance $0, Payment $350, Writeoff $150

    Pledge B Balance $50, Payment $650, Writeoff $100

    Attachments Open full size
  • Alex Wong commented
    06 Oct 15:48

    Adding to the original GFLink output request is the Amount Applied field.

    Pledge A of $500
    Pledge B of $800
    Payment A of $1000, $400 applied to Pledge A, $600 applied to Pledge B

    The output for Payment A needs to be multi-rowed where it states GFLink Pledge A $400 and GFLlink Pledge B $600

    Attachments Open full size
  • Alex Wong commented
    06 Oct 15:45

    @Di Anne Want, note that the KB article does not work for Pledge Payment that is applied to multiple pledges. See Community post: https://community.blackbaud.com/discussion/84889/finding-giftlink-for-payments-applied-to-multiple-pledges

    Attachments Open full size
  • James Belich commented
    October 23, 2025 15:21

    A note on the workaround: This works for pledge payments but does not appear to work for write offs. Both need to be connected to a pledge to get an accurate picture of what's happening with the pledge. A pledge for $500, for example, isn't really a $500 gift if $200 was written off. The lack of the GFLink field makes it difficult to capture these sorts of situations.

    Attachments Open full size
  • Di Anne Wang commented
    June 06, 2025 17:39

    Yes, please get this fixed before database view goes away. Meanwhile, here's the workaround: https://kb.blackbaud.com/knowledgebase/Article/75198

    Attachments Open full size

Related ideas