I need some help with a basic problem.
I have an association with many to many relationship. For this Studio automatically generates a nested collectiondatasource and the editor wizzard generates a nested table with add / remove buttons. I really need the nested table to be displayed in a custom order. Because the nested datasource does not allow any queries I created my datasource as a non-nested one, by using this query:
select p from myapp$Projects p join p.customers c where c.id = :ds$customersDs order by p.date_start, p.id
It works for displaying nested table in the desired order and editing it, but add and remove fail. For example when removing a row (customer) from the nested table, the customer is removed cascaded from everywhere. This behaviour has to do with the fact that the datasource is not nested anymore, although the query looks ok.