Sign in Register
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 96 posts 341 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?

    Copy Link
  • Simeon Ostberg 96 posts 341 karma points
    Jan 31, 2020 @ 11:22
    Simeon Ostberg
    0

    pushing it up

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

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies