Add parent relationships

carlosTF

Is it possible to add a new parent relationship type? When I try, I get:
Invalid parameter type 1 for parent_id [value was undefined]

The relationship I'm trying to add is Occurence (Event) <-> Entity (Organization). An example would be:

MUSEUM (Entity) was venue of EXPOSITION (Occurrence)

Thanks

darrigan

Hi, I know it's possible because I made this some years ago... I remember I used a trick, but I don't remember how.🤔

carlosTF

Thank you C.

I've updated the entity ⇔ occurrence relationship by including a 'hosted' item with 'had as venue' as its reverse. This should make it unnecessary to create a parent occurrence ⇔ entity relationship.

monica

carlosTF you can’t have a parent relationship between different primary tables like this, with the exception of collection a parent of an object.

To create data that sits inside the relationship, you need to create a new UI for entity x occurrence with the fields you want. You can then edit these using the paperclip icon on the relationship. It’s under ‘interstitial data’ in the documentation. https://docs.collectiveaccess.org/providence/user/dataModelling/interstitial

carlosTF

In this same area, is it possible to include additional fields as part of a relationship? For instance, the role of an individual or the starting/ending of the relationship.

carlosTF

Thank you Monica, I will take a look at this and see if it's worth the effort.