Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

1.7k questions

3.2k answers

401 users

Categories

1.7k questions

3.2k answers

401 users

HI,

Wonder if anyone here could help us. we are looking at extending the constituent relationship manager function. The Out of the Box table named RELATIONSHIPMANAGER has the following fields

ID
CONSTITUENTID
FUNDRAISERID
ADDEDBYID
CHANGEDBYID
DATEADDED
DATECHANGED
TS
TSLONG

In addition to the above fields we would like to add four more columns to the table

Context
Start Date
End Date
Comments

We have not made any table level customisation yet in our organisations, so this is our first attempt and I wonder if you any of have done anything like this.
My questions are
Can we directly change the underlying table?
If no, I guess we need to create a new user defined table but we will not be able to make use of other OTB functions related to RELATIONSHIPMANAGER. Is there any recommended to method to making changes such as this?

Many thanks in advance
Anbu

asked by
edited

1 Answer

Extending a table spec is not supported. The recommended way to do this is to create another table that links to relationship manager. For example, USR_RELATIONSHIPMANAGER_EXT, with the columns ID (same as RELATIONSHIPMANAGER.ID via PrimaryKeyAsForeignKeyTablename metadata) and your additional fields. That way you can take advantage of any OOB functionality and extend that functionality as needed with your new fields.

answered by christi (717 points)
...