online giving query

Options
Laura Marcinkowski
Laura Marcinkowski ✭
Facilitator 1 Name Dropper First Anniversary
in Blackbaud Raiser's Edge NXT®: General Discussion

I am trying to run a query in DB view that includes our online giving from our donation forms. Is this possible? Currently, they are not showing up.

Tagged:

Comments

  • Mark Guncheon 2
    Mark Guncheon 2 ✭
    Tenth Anniversary Facilitator 2 Name Dropper Photogenic

    @Laura Marcinkowski Some questions:
    How are you filtering in donors - gift date, fund, appeal, etc.?
    Do your online donation form gifts have the field used by your filter? If not, then you need to adjust your filters.

  • Dariel Dixon 2
    Dariel Dixon 2 ✭✭✭✭✭
    Seventh Anniversary Facilitator 4 Name Dropper Photogenic

    @Mark Guncheon is correct. As long as your gifts have already been committed, the gifts should show up as long as they are part of your criteria. I think you need to look and double check your criteria @Laura Marcinkowski.

  • Laura Marcinkowski
    Laura Marcinkowski ✭
    Facilitator 1 Name Dropper First Anniversary

    @Dariel Dixon @Mark Guncheon the only filters I have set up is the date range and the funds. Which online gifts should fit into- but they still don't show up.

  • Dariel Dixon 2
    Dariel Dixon 2 ✭✭✭✭✭
    Seventh Anniversary Facilitator 4 Name Dropper Photogenic

    @Laura Marcinkowski I would then check to see how your online gifts are coming into the system. If the only criteria are date and fund, then they should come in without issue, unless there's an error in your criteria logic.

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Laura Marcinkowski
    assuming by donation forms, you mean RE NXT donation form, the gifts made on these forms does not “count as gift” when it's made. Someone has to go and approve the web gift batch before it is reportable (both database view and webview).

  • Laura Marcinkowski
    Laura Marcinkowski ✭
    Facilitator 1 Name Dropper First Anniversary

    @Alex Wong thank you! Once its approved…is there any other delay? It seems that even when I've approved it…sometimes it doesn't show up. But, I just changed the date range to “Last Month” and they show up now.

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Laura Marcinkowski
    yes, there is a delay on webview list and report:

    if you are using database view query, then there is no delay

Categories