[#5853] - Listed values defined as Strings

Category:
Bug report
Priority:
High
Status:
New
Project: Severity:
Block
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

Hi,
I am trying to filter my reports using a list of values or SQL queries, Each time I use the multiselect option I get an error stating the field is not an integer. I believe this is because the lists are defined as strings.

I tried to use the work around where defining the coloumn as a VARChar, But this brings up a similar issue.

When using single Select queries though it works fine, because the end parameter is set as a Integer.

I use the where $X{IN, MyIntgerColoum, Myparam}

curbish's picture
152
Joined: Oct 25 2011 - 8:30am
Last seen: 8 years 17 hours ago

1 Comment:

#1

I have found a workaround which works, using typecasts i set the where clause to be $X{IN,(MyIntgerColoum::varchar), Myparam}

Feedback