Can I have a reference using the list of ids to that schema where the current reference is?
The way the application currently works is that a question can have an ancestor with a reference via id, and based on the answer in it, it is displayed. I now need to store a list of question ids using multi select instead of question id, and the ids from the list should reference the selected ancestors.
What should the given reference look like please, if it is possible to create it? So far my experience is only with the basic reference type and I can’t find a solution, thank you.
Current code with reference through one id:
schema "assessment_questions" do field :question, :string field :temp_id, :string, virtual: true . . . belongs_to :ancestor_question, MyApp.AssessmentPipelines.AssessmentPipeline.AssessmentQuestion timestamps() end def changeset(assessment_question, attrs) do assessment_question |> Map.put(:temp_id, assessment_question.temp_id || attrs["temp_id"]) |> cast(attrs, [ :question, . . . :ancestor_question_id ]) . . . end
def change do alter table("assessment_questions") do add :ancestor_question_id, references(:assessment_questions, on_delete: :nothing, type: :binary_id) end end
Thanks for any help.