NuPickers: datatype shall show data based on other datatype
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)
NuPickers: datatype shall show data based on other datatype
Hi everyone,
This is what I would like to do: In one datatype I choose an event edition:
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:
Instead of "ID_EDITION=10" I would like to get something like
Is there any way to achieve this?
pushing it up
I would be happy, if anyone could help me with that...
is working on a reply...