You are not logged in.
Hello
I'm trying to use names with capital letters and spaces in calculated columns in dynamic list
Syntax of select
select 'sometext' as "Field with space", 'sometext' as "Capitals"
When i'm trying to add calculated field using this fields I'm getting message:
concat(Field with space, Capitals) I'm getting error message 'Syntax error'
Using quotations " or parentheses [] or () does not help
Could you, please advice, how to solve that
source database is postgresql
Last edited by asmirnov (2019-06-27 16:11:38)
Offline
Hi asmirnov,
I see the problem. It seems to be a bug. I created ticket RS-3535 for this.
Until then, please use lower case for the column names in you want to use in computed columns.
Regards,
Eduardo
Offline
Hi asmirnov,
I see the problem. It seems to be a bug. I created ticket RS-3535 for this.
Until then, please use lower case for the column names in you want to use in computed columns.Regards,
Eduardo
Thank you, Eduardo
Will it cover also spaces in column names?
Do you have plan to fix in it terms of dates?
Last edited by asmirnov (2019-07-03 10:45:59)
Offline
Hi asmirnov,
we will take a look at this, and then we will have more information on dates / release time. But there is a workaround so please use the workaround until then. I will update here when we have looked into this.
Regards,
Eduardo
Offline