Dear support team,
when Query by example is used for handling SQL statements on tables containing column names with blanks or small and big letters in it, the query by example feature does not work. The column names are not put under quotes and so the column names in the query do not fit the column names of the tables/views.
Examples:
select * from dwc_article t
where article like :qbe_var1
Whereas article should be "Article".
select * from dwc_article t
where article name like :qbe_var3
whereas article name should be "Article Name".
Hope you can fix this bug soon.
Thx and best regards,
Klaus.
when Query by example is used for handling SQL statements on tables containing column names with blanks or small and big letters in it, the query by example feature does not work. The column names are not put under quotes and so the column names in the query do not fit the column names of the tables/views.
Examples:
select * from dwc_article t
where article like :qbe_var1
Whereas article should be "Article".
select * from dwc_article t
where article name like :qbe_var3
whereas article name should be "Article Name".
Hope you can fix this bug soon.
Thx and best regards,
Klaus.
Last edited:
