$X function does not support column name formatted by built-in SQL function with comma delimited parameters

Changed Assigned User from - to @shertage

---

Hi,

 

the $X syntax does not accept parameters in the column name section.

As a workaround, you could define a String parameter and use it in the query:

 

$P{Days}.toString().replace("[","(").replace("]",")")

...

select * from my_table where dayname(from_utc_timestamp(timestamp,$P!{Time_Zone})) IN $P!{Days_text}

 

Please note the $P! notation used in the query, instead of $P.

Try this workaround first and let us know if it works for you.

 

Thank you,

Sanda

 

 

 

Changed Status from New to Feedback Requested

---

Thanks for your response, but in this way, I will miss the feature from $X syntax, if $P{Days} is Null, this will not work.