Using CONCAT to view data from multiple Elements in Dropdown

[ArjanM]

We are using a Databasejoin with Dropdown to select from the list of generators (generatoren.generator_description). So far, so good... But in the same Dropdown we also want to add the name of the location where the generator is stationed (generatoren.generator_stationed) by using CONCAT. Unfortunately, when we try, we only get the value of 'generatoren.generator_stationed' and not the real name of the location because generatoren.generator_stationed' is a Databasejoin with 'generatoren_standplaatsen.generator_stationed' where the real placenames are residing. What would be the right formulation for the CONCAT-command?

-- Arjan.

 

[cheesegrits]

You would have to use a subquery in the concat, like ...

{thistable}.generator_description,  ' - ', (SELECT generator_location FROM generatoren_standplaatsen WHERE id = {thistable}.generator_stationed)

Obviously tweak those names to suit.

-- hugh

 

[ArjanM]

Cool! Thanks for putting me on the right track.

-- Arjan.