Skip to content

Linked Records CRUD #575

Closed
Closed
@shogunpurple

Description

@shogunpurple

Users need to be able to link records from different tables together.

For example, a student may attend many classes.

This would include the ability to:

  • Create a linked record column in the student table for classes
  • Select which classes you want to link
  • Have the linked records displayed for a particular record in the backend UI when you click on it. Ie. "Show me all the classes that this student is part of."

Technical notes:
Decide how to link records together. This requires a research spike. We need to know whether to:

  • Keep and improve the current implementation where we link one record to another using their IDs in an array
  • Create a view that keys linked records by the parents ID. You then query this view by ID to get all the linked records for it.

With the view implementation, we could possibly create a view that contains bidirectional links for a specific record using a composite key and query it out using the Id of either the parent or the child. For example:

emit(["childLinkedField", "parentId"], ["childId", "otherChildId"])

emit(["parentLinkedField", "childId"], ["parentId", "otherParentId"])

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions