Filter on IDO Collection List Source

Pavel Matras

Hi,

I am trying to apply Filter on my DropList component filled from IDO Collection. To show only result where username Property is equal to Form variable varCurrUser, where I have current Username stored.

But when I open DropList on Form, I am receiving this error:

Please what am I doing wrong in Filter condition?

Thanks.

Legacy Contributor

Hi Pavel,

Its because you are using a text field so you need quotes around the variable value. Try using

username = FV(varCurrUser)

or

username = 'V(varCurrUser)'