To allow add fields like Activity in ad-hoc query it's required to add this query view.
Have you tried the Recurring Gift Payments query view?
Hi Pat, we only have available Recurring Gift Installment in ad-hoc queries
Please contact support to get further assistance with this. You should see several query views for Recurring Gifts.
You won't be notified about changes to this idea.