Problem:
I must transfer a selection from the dynamic view back to the base app. It works from base app to the dynamic view, but data in the dynamic view is not linked to the data model of the base app. Selections in the view have no effect on the base app.
Situation:
The base app consists e.g. of an inventory of products. Consider it as a shopping app where you select products and put them into a shopping basket. One a selection is done, we use a custom writeback extension to transfer this selection via REST-API to an order management system where the workflow continues. In that system, there is a database with all placed orders.
Today, we read back the content of the order management system during each reload of the base app and display it in the base app a bit like using it as an oursourced bookmark collection. If you select an order-number, all related products are filtered in the base app. That works fine... but
You see new orders in the database only after a reload of the base app because the order-tables are part of the data model. And a partial reload is currently not possible. So you never see the current status of the order table. But the users want the orders table to be updated in REAL TIME or at least on request.
Solution: Dynamic view.
The dynamicc view shall be a table with metadata of placed orders, order number, date of order, customer etc. from that order management database. One line of data per order. The template app shall contain in addition to this metadata table a fact table with order details, specifically which products belong to this order. That works fine, too and we could e.g. see by selecting a product in the base app, which orders contained this product (stored in the template app and linked e.g. via product-number).
Now, if an order number in the dynamic view table is selected, i want to be able to do two things in the BASE app:
1. Use the respective order number in a formula or write it to a variable
2. Apply a filter in the base app on all products, that belong to the order number (as derived from the template app)
Unfortunately a selection in the dynamic view seems to be not reflected in the base app as the linkage works only one-directional.
Any ideas?
Please do not consider bookmarks as orders can be created in many other ways, not only by this one base app. As well, we already consider partial reload but this seems to be a longer story and I hope dynamic views is faster, as it is already available.
