Hi everyone,

This is what I would like to do: In one datatype I choose an event edition:

select ID_EDITION as 'Key', EDITION as 'Label' from EDITIONS

This datatype is used in a configuration document type, where the site takes it's from.

In another datatype I would like to filter data based on the chosen Edition:

select ID_FILM_EDITION as 'Key', TITLE_ENGLISH as 'Label' from FILMS INNER JOIN FILM_EDITIONS ON FILM_EDITIONS.ID_FILM=FILMS.ID_FILM WHERE ID_EDITION=10 AND WEB_PUBLISHING=1

Instead of "ID_EDITION=10" I would like to get something like

ID_EDITION=(value of editions datatype in node ID XX)

Is there any way to achieve this?