Servoy Log issue

Classic Servoy
1

Hi All,

There is a table view . One of the related field is accessed from a different table . When I am trying to sort on that field by hitting on the top of the column header . A servoy log warning is getting produced : Cannot sort on dataprovider “rel.calculation_name”.

I have also tried by making in the current table a calculation and then accessing the required field through relation . Still the log issue persists.

How can I eliminate the log Issue ? . Does the log issues have any impact on the performance of the application ? . Please provide some suggestions .

Thanks,
Ashutos.

2

are you trying to sort a none stored calculation? this can’t be done by using the sql sort (foundset.sort(string)) because the data is not there.

3

Hi All,

This is a stored calculation . Still the log issue is getting created.

Thanks,
Ashutos.

4

that relation is there right? and it is not a global relation or goes to a different server? (primary->foreign)
and the relations primaryDataSource is the same one of the main table/foundset where you call sort() on?

5

Hi All,

All the other conditions are right . But the relation goes to a different server.

Thanks,
Ashutos.

6

that is then the problem, you can’t sort over multiply servers