Grid filter - multi select error

[Theo Kusters]

Hi,

I have a grid with a filter based on a datasource. This works fine until I change it to a Multi select filter.

I receive an error message that the column (PCACCO) that is being filtered can't be found.

The generated sql uses an added WHERE clause on the filter field with the name F1.PCACCO while the file is opened with 'prcbes AS h' . The single choice filter adds the name H.PCACCO to the WHERE clause correctly.

Regards,
Theo

[Theo Kusters]

I changed the

FROM prcbes AS h 

to

FROM prcbes AS F1 

That workaround works for now.

[Johnny Major]

Hi Theo,

We were able to replicate this issue and it will be fixed in the next Valence 6 update

Thanks

[Theo Kusters]

Thanks Johnny! :)