Objective I need to create a new screen (a Mashup) to display quotations (OOQUOH table) filtered by “Object Access group” (= OKACGR - a datum stored into OCUSMA which groups customers).
So, to reach this objective, XXXX give us a solution which consists :
- To create a joined logical file between OOQUOH and OCUSMA
- Used this joined logical file into a Mashup – with customized List Panel
Step1 I have created a joined logical file by MAK and deployed it with LCM (just to have good declarations on differents files...). Step2 I used SQL statements to DROP/CREATE Views and Indexes....
DROP VIEW GEIETST.OOQUOHJ9;
CREATE SUMMARY TABLE GEIETST.OOQUOHJ9
AS ( SELECT OO.QFCONO, OO.QFORNO, OO.QFCUNO, OO.QFSTAT, OO.QFORCD, OC.OKACGR
FROM M3ETST.OOQUOH as OO, M3ETST.OCUSMA as OC
WHERE OO.QFCONO = OC.OKCONO and OO.QFCUNO = OC.OKCUNO )
DATA INITIALLY IMMEDIATE
REFRESH DEFERRED
MAINTAINED BY USER
ENABLE QUERY OPTIMIZATION;
CREATE INDEX GEIETST.OOQUOHJ1 ON GEIETST.OOQUOHJ9 (QFCONO, QFORNO, QFCUNO, OKACGR);
Step3 : Problems :
First problem : impossible to create OOQUOHJ9 index into OOQUOHJ9 view (and I think it’s necessary&hellip. So I created it with OOQUOHJ1 name. Second problem : i can use this joined logical file into CMM310-CMM320 but i can't use "Design" button into Mashup - Customized List Panel.
So, two problems, two questions... : - do you know if it is possible to create (by MAK, maybe...) joined logical file ? - do you know if it is possible to used it into Mashup - Customized List Panel ? I add an attached file for more description... Thanks, Jordane