I have a test project where I have following Entities:
- Order (Master) , OrderLine (Deatil - composite)
- Production (Master), ProductionLine (detail - composite)
Product is Associated in OrderLine and Production.
In Production UI, user will select Order from LookupField that will refresh Product LookupField be filtering the products according to the Products in OrderLine Entity related to the selected Order.
My question is related to Production user Interface is:
- I tried to filter the product combo box using the following query in the DataSource, but it doesn’t work. Is it the right way in the above explained situation?
select a from demodscontext$OrderLine e join demodscontext$Product a where e.order.id = :ds$ordersDs.id
- Is a DsContext is suggested in datasource listener in the controller to setSQL as per the selected Order DS? If yes, how can I set order as query parameter?
I have attached the project file, thanks for your help.