Can I set the “join type” of a relation temporarily while doing sort? The idea is it will only take effect while sorting.
I tried updating the join type temporarily before sorting the records and placing it back when sorting is finished, however, the following exception is displayed:
“java.lang.RuntimeException: java.lang.RuntimeException: Cant modify a relation that is already used in the application:”
Do I have another option other than making another relation that is set to LEFT JOIN?
Erik,
You cannot modify the ‘blue print’ solution model data when objects (relations, forms, etc) have been created from it and are in use.
There is no way to remove an instantiated relation, so your scenario is not possible.
Either you have to create 2 relations or you can simply change the join type to outer-join and use that relation only.
Why not always use outer-join?
Rob
rgansevles:
Erik,You cannot modify the ‘blue print’ solution model data when objects (relations, forms, etc) have been created from it and are in use.
There is no way to remove an instantiated relation, so your scenario is not possible.Either you have to create 2 relations or you can simply change the join type to outer-join and use that relation only.
Why not always use outer-join?Rob
All relations we’ve defined so far have default settings (hence, they’re all based on inner joins).
After we tested Servoy sort on certain columns, records just disappear from the foundset. Those records that don’t have corresponding values in the columns were filtered out by Servoy internal queries as we believe.
Is this the expected behaviour?
Cheers,
Maria
Maria,
Yes this is expected behaviour for inner-join relations.
Use outer-join relations to prevent this.
In future versions we will change the default join type for relations to outer-join.
Rob
rgansevles:
Maria,Yes this is expected behaviour for inner-join relations.
Use outer-join relations to prevent this.In future versions we will change the default join type for relations to outer-join.
Rob
Thanks Rob.