Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Simeon Ostberg 123 posts 389 karma points
    Jan 29, 2020 @ 13:04
    Simeon Ostberg
    0

    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)
    

    Is there any way to achieve this?

  • Simeon Ostberg 123 posts 389 karma points
    Jan 31, 2020 @ 11:22
    Simeon Ostberg
    0

    pushing it up

    I would be happy, if anyone could help me with that...

Please Sign in or register to post replies

Write your reply to:

Draft