1 Reply by daniel.vergien

  • daniel.vergien
  • Veteran
  • Offline
  • Registered: 28-10-2010
  • Posts: 55

Re: Extending person attributes

Hi,

I need to extend the attributes of the people table with:
* external_key - varchar(50)
* date_of_birth - date
* date_of_death - date

Changing the model for all attributes and the view for the external_key worked fine, but how do I add the dates to the view?

Can this fields be made as "standard" fields for indicia? The date of death we would like to have since we also want to put historical data in our system and we only want to suggest finder and determiner which are alive at the date of the sample.

Regards

Daniel

2 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: Extending person attributes

I remember a previous suggestion to add custom person attributes which might be a better way to do this.

Jim Bacon

3 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Extending person attributes

Yes, I agree, custom attributes for people would be a more flexible approach than adding the date of birth and death which are only relevant in some scenarios. However I think external_key should be added to the core to match the use of this field elsewhere. Daniel, can you send me a patch for the work you have done on external key to include please?

John van Breda
Biodiverse IT

johnvanbreda's Website