Hi,
I am trying to store the result of a SELECT query (1) to Cassandra into
a variable to use this within a second (2) query.
Sample of second query (2) where I would like to have a SEQ of
possibilities for the Dynamic Form:
{code}
SELECT * FROM companies WHERE country = '${country=Germany,Germany|USA|
France}';
{/code}
Should be:
{code}
SELECT * FROM companies WHERE country = '${country=Germany,$countries}';
{/code}
Would it be possible to execute a first query (1) like the following to
store the possible country names within a Sequence?
{code}
val countries = SELECT distinct country FROM companies;
{/code}
Is there may be a possibility?
Thank you for any help.
Kind regards,
Andre
--
Andre Schütz
COO / Founder - Wegtam GmbH
[email protected] | P: +49 (0) 381-80 699 041 | M: +49 (0) 176-218 02 604
www.wegtam.com | www.tensei-data.com | www.wegtam.net
