Error while filtering and sorting

Forum to discuss the new web client version of Servoy.

Error while filtering and sorting

Postby jay.rao » Fri Dec 22, 2017 12:05 pm

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
jay.rao
 
Posts: 46
Joined: Mon Apr 10, 2017 1:32 pm

Re: Error while filtering and sorting

Postby patrick » Sat Dec 23, 2017 6:55 pm

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.
Patrick Ruhsert
Servoy DACH
patrick
 
Posts: 3630
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany


Return to Servoy NGClient

Who is online

Users browsing this forum: No registered users and 2 guests

cron