Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.

If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping

Answers may be delayed for posts that do not include sufficient information.

entity <-> place relationship with effective dates

I'm trying to configure my "entity ⇔ place relationships" with an additional time attribute. I already created the UI that allows me to register the "Effective dates" on this relationship (standard_ca_entities_x_places_ui). However, i can't register more than one working period for the same location.


  • Entity1 worked in Berlin from 2002 to 2004
  • Entity1 worked in Zurich from 2004 to 2006
  • Entity1 worked in Berlin from 2006 to 2010

If i want to register all three of the above, the last one is automatically dropped. Because the entity already has a "worked in" relationship with the place Berlin, i can't register it.

Is there a way to allow multiple "Effective dates" on a relationship?

Providence version 1.7.6
Firefox / Windows


  • Solved it:

    <metadataElement code="effectiveDate" datatype="DateRange"> <labels> <label locale="en_US"> <name>effectiveDate</name> <description>effectiveDate</description> </label> </labels> <typeRestrictions> <restriction> <table>ca_entities_x_places</table> <type/> <settings> <setting name="minAttributesPerRow">0</setting> <setting name="maxAttributesPerRow">99</setting> <setting name="minimumAttributeBundlesToDisplay">1</setting> </settings> </restriction> </typeRestrictions> </metadataElement>

    User Interface
    <userInterface code="standard_ca_entities_x_places_" type="ca_entities_x_places"> <labels> <label locale="en_US"> <name>Entity - Places</name> </label> </labels> <userAccess> <permission user="administrator" access="edit"/> </userAccess> <screens> <screen idno="entity_place" default="1" color="000000"> <labels> <label locale="en_US"> <name>Basic</name> </label> </labels> <bundlePlacements> <placement code="ca_attribute_effectiveDate"> <bundle>ca_attribute_effectiveDate</bundle> </placement> </bundlePlacements> </screen> </screens> </userInterface> </userInterfaces>

Sign In or Register to comment.