The following query fields are only available in web view. Use this reference to see where each field is available and which query types support it.
| Field name |
Description |
Node |
Query types |
| Sort Name With Import ID |
Displays the constituent's sort name and import ID as a combined value, useful for uniquely sorting constituents |
Constituent Information |
Available wherever Sort Name exists |
| Address |
Displays the complete address for a constituent or related entity |
Constituent Information |
- Constituent
- Gift
- Event
- Participant
- Action
- Relationship
|
| Organization Name |
Displays the name of an organization constituent |
- Address Processing
- Preferred Address
- Address
|
- Constituent
- Gift
- Action
- Participant
- Relationship
- Event
|
| Position |
Displays the role or title held by an individual at an organization |
- Address Processing
- Preferred Address
- Address
|
- Constituent
- Gift
- Action
- Participant
- Event
- Relationship
|
| Country Long Description |
Displays the full descriptive name of a country rather than standard country codes or abbreviations |
- Address Processing
- Preferred Address
- Address
|
- Constituent
- Gift
- Event
- Participant
- Membership
- Campaign
- Action
- Relationship
|
| Country Short Description |
Displays the abbreviated or short form of country names |
- Address Processing
- Preferred Address
- Address
|
- Constituent
- Gift
- Participant
- Event
- Membership
|
| Preferred Address |
Displays the constituent's preferred address with all address lines consolidated into one field |
Constituent information |
- Constituent
- Gift
- Individual
- Organization
|
| Fundraiser List |
Displays a semicolon-separated list of fundraisers and solicitors associated with actions |
Actions |
- Constituent
- Gift
- Event
- Relationship
|
| Fund List |
Displays all funds associated with a gift as a semicolon-separated list in a single cell, useful for split gifts |
- Gifts
- Matching Gifts
- Linked Gifts
- Gift Information
|
- Constituent
- Individual
- Organization
|
| Payment Transaction ID |
Displays the payment transaction ID from Blackbaud Payment Services for gifts processed through Donation Forms or Raiser's Edge NXT web view, useful for gift reconciliation |
Gift Information |
Gift |
| Appeal List |
Displays all appeals associated with a gift as a semicolon-separated list in a single cell, useful for split gifts |
- Gifts
- Matching Gifts
- Linked Gifts
- Gift Information
|
- Constituent
- Membership
- Campaign
- Fund
- Gift
- Participant
- Event
- Relationship
|
| Campaign List |
Displays all campaigns associated with a gift as a semicolon-separated list in a single cell, useful for split gifts |
- Gifts
- Matching Gifts
- Linked Gifts
- Gift Information
|
- Constituent
- Campaign
- Fund
- Appeal
- Event
- Gift
- Membership
|