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}
1 Comment:
I have found a workaround which works, using typecasts i set the where clause to be $X{IN,(MyIntgerColoum::varchar), Myparam}