We have a form that uses fields located in a database separate from the database that the form is based on. We created the relation to display the data, and it works fine…
However now we would like to sort by those fields, and they are not availible in the sort dialog nor does it work via the controller.sort function.
Is this a bug, or has it been addressed already and determined to not be possible?
Not sure about this one. But with Servoy it is rare to get stuck…
You can try to sort manually by attaching a metod to the onshow of the form, or, you could populate your list using databaseManager.datasetFromQuery where you specify a sort in the query.
The latter won’t work:
or, you could populate your list using databaseManager.datasetFromQuery where you specify a sort in the query
since running a query this way can only be done over 1 DB connection.
Paul
Anyone else have any ideas? I’m still waitng for a workaround at the least…
Convert your foundset to a dataset (I think this is possible),
Format the dataset as HTML
If you want to sort, sort the dataset and redo your HTML.
Paul
Ok, I’ll give u credit for coming up with a workaround, but 1, that’s alot of work for a simple sort, and 2, it’s a rather “expensive” workaround especially when dealing with many users and large foundsets.
I’m sure I am not the only one who would like to see this work properly.
Servoy?
You could create a stored calc to display the data via your relation, then just sort on that field.