Howdy, Stranger!

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

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.

Export Mapping for ca_objects.type_id preferred_labels name


Does anyone know how to map the exporting of the ca_objects.type_id preferred_labels name ?

It's good to be able to export the code mapping to ca_objects.type_id , but it would be great if I could send out the preferred_labels name from the ca_lists.object_types, to which it's linked. I've tried the obvious stab-in-the-dark stuff (e.g. appending a .preferred_labels), but my attempts have only resulted in a number being returned instead.

Thank you very much for any help or suggestions,


  • Hi,
    I don't know if I understood the question correctly,
    but if you want to extract the type of the preferred label of the object you can write like this:

    ca_objects.preferred_labels.type_id {"convertCodesToDisplayText": 1}

    if instead you want to extract the text of the type of the object you can write like this:

    ca_objects.type_id {"convertCodesToDisplayText": 1}


  • Thanks Antonio! This is just what I needed.

Sign In or Register to comment.