Error while filtering and sorting

Classic Servoy
1

Hello,

We keep on getting below error when we try to filter or sort the data in our custom component.
WARN com.servoy.j2db.util.Debug - Find: skip related search for ‘logging_to_sec_user’, relation cannot be used in search, because: multi server
at D:\Globtec\globtecdevexcomponents\DataGrid\DataGridServer.js:85
ERROR com.servoy.j2db.util.Debug - Relation logging_to_sec_user cannot be used in a find (multi server)
at D:\Globtec\globtecdevexcomponents\DataGrid\DataGridServer.js:85

This was never the case previously while developing,we have now migrated to 8.2.2rc version. This filtering and sorting used to work very smoothly earlier which was also tested 100% OK .Now whenever we try to filter it starts throwing this error and also the sorting doesn’t work anymore, we simply sort using fs.sort and sortcolumns and also were in working condition in previous versions for us.I wouldn’t say its totally related to version , please suggest.

Thanks,
Jay

2

I can’t tell from what you are writing what you are trying to sort. The warning says you are trying to sort over a relation that connects two different database (the one containing “logging” and the one containing “sec_user”). That was never supported, because that needs a join and cross database joins don’t exist. So I’m pretty sure this is not because of 8.2.2.