Use of Joined logical file into a Customized List Panel with Mashup

Sort:
You are not authorized to post a reply.
Author
Messages
Jordane
Basic Member
Posts: 16
Basic Member

    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

    Attachments
    Jordane
    Basic Member
    Posts: 16
    Basic Member
      No response...
      Can be that my problem is not very well explained ?
      Give me some response please...
      You are not authorized to post a reply.