Add Opportunity ID (system record ID) as an output field in constituent queries.

Please, just need to be able to pull the opportunity IDs from a query :)

  • Nicole Holt
  • Sep 29 2025
Query
  • Attach files
  • Lucy Ruiz commented
    10 Feb 15:27

    Having an Opportunity ID or System Record ID will allow users to develop comprehensive reports as unique counts and other metrics may occur.

    Attachments Open full size
  • James Parsons commented
    05 Feb 15:58

    The system record ID appears to the be primary key for a given record and has become my go-to for joining tables in PowerBI, so it would be important to see this available in query for all records.

    Attachments Open full size
  • Guest commented
    October 22, 2025 15:05

    Seems odd that a system record ID is visible in Query for Constituents, Gifts, Actions, and even Events – but not for Opportunities?

    Attachments Open full size
  • Melody Penner commented
    October 15, 2025 20:42

    Yes, this is important to have all available system ids (or import ids as they are called in database view export tool) - in query and Export when it eventually comes over.


    Attachments Open full size
  • Zoe Feder commented
    October 10, 2025 18:17

    Yes please! My fundraisers update opportunity fields on a spreadsheet during quarterly reviews and if it was possible to output opportunity ID then it would be so much easier to bulk upload those changes.

    Attachments Open full size

Related ideas