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:

SELECT * FROM companies WHERE country = '${country=Germany,Germany|USA|

Should be:

SELECT * FROM companies WHERE country = '${country=Germany,$countries}';

Would it be possible to execute a first query (1) like the following to
store the possible country names within a Sequence?

val countries = SELECT distinct country FROM companies;

Is there may be a possibility?

Thank you for any help.

Kind regards,

Andre Schütz
COO / Founder - Wegtam GmbH
an...@wegtam.com | P: +49 (0) 381-80 699 041 | M: +49 (0) 176-218 02 604
www.wegtam.com | www.tensei-data.com | www.wegtam.net

Reply via email to