Start a new topic

Table Filter truncates and changes values using IN clause

anonymous

started a topic about 15 years ago

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

From the screen shot attached, you can see that the filter values entered had the last character lost and the dashes "-" had spaces added before and after them. This is undesired behavior.

Values entered:
DOH-4272, DOH-3999, DOH-4029, DOH-242, DOH-242C

What filter produced:
PRODUCTID IN  ( 'DOH - 4272', 'DOH - 3999', 'DOH - 4029', 'DOH - 242', 'DOH - 242' )

Version is 6.5.4

Edited by: Timothy Troy on Mar 9, 2009 6:16 PM

1 Comment

Hans Bergsten

said about 15 years ago

[This reply is migrated from our old forums.]

Re: Table Filter truncates and changes values using IN clause

Hi Timothy,

Thanks for reporting this. The problem occurs when using an IN/NOT IN condition for a character column where the comma separated values contain special characters like "-". A work-around is to manually quote the values, i.e. enter the list like this instead:

'DOH-4272', 'DOH-3999', 'DOH-4029', 'DOH-242', 'DOH-242C'

We will look into a way to handle the quoting automatically even for this case.

Kind Regards,
Hans

How can we help you today?

Table Filter truncates and changes values using IN clause

anonymous

Hans Bergsten