Hi,
I try to find out via (Jira-) Scriptrunner sql, if a confluence space exists or not.
The sql works fine as long as no Ampersand is part of the name.
I therefore replaced '&' with chr(38).
row = sql.firstRow("select count(*) from spaces where spacename = 'Jira ' || chr(38) || ' Confluence bei der R+V'")
Exactly the same sql runs fine and returns "1" in sqldeveloper. But when I execute the sql in my groovy script it returns "0".
Any ideas?
Peter
forget everything I wrote.
I had a typo in my script. Everything works fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.