Sorting and Filtering by lookup fields

I have a table with one integer columns that relate to a lookup table. DataGrid Sort function is ok, but column filter field accepts only integers resulting in error:
GET http://localhost:5000/odata/cprojtest/Projetos?$filter=Pessoa/Nome%20eq%201&$top=5&$skip=0&$orderby=Pessoa/Nome&$count=true&$expand=Pessoa 400 (Bad Request)
Trial version downloaded today

Hi @villar,

Thank you very much for your report! Please change the column type to string, we will fix the auto-generated columns/pages immediately.

Best Regards,
Vladimir

It worked!

Thank you.

Hi @villar,

Just to let you know that we’ve released Radzen 2.1.3 with fix for auto-generated lookup columns type. You will get the new version automatically on next Radzen start.

Best Regards,
Vladimir