4 Replies Latest reply on Oct 9, 2013 7:48 AM by I_love_bits

    drag and drop interactive report

    I_love_bits

      Hy!

       

      For an interactive report i would like to implement drag and drop for ordering the rows.

      It is a quit complex query behind the report (joins, ect.)

       

      I need a hidden item like this

      apex_item.hidden(1, rowid) AS Sort
      

       

      The problem is, that rowid is not allowed here (ORA-00918: column ambiguously defined).

      Because of that article I am sure the joins in my query are the problems

      ORA-00918: column ambiguously defined

       

      But I need this rowid for the sorting process.

      How to implement Drag and Drop I have learned from here:

      Read Article - Drag & Drop tabular form rows

       

      Does anybody know a workaround?

       

      Thanks for your help!

      Ilb.

        • 1. Re: drag and drop interactive report
          jariola

          Hi,

           

          Without seeing your query hard to say why you might get ORA-00918.

          As you say report query join tables, you have not probably define from witch table you like have rowid.

           

          Why you must have rowid ?

          Is it because you do not have e.g. primary key in tables?

           

          Regards,

          Jari

          • 2. Re: drag and drop interactive report
            I_love_bits

            Hy Jariola!

             

            I need the rowid for the Update PL/SQL-Process.

            The link above contains the 4 lines of code where we need this rowid.

             

            Yes, I think I did not have defined from witch table I would like to have the rowid. (How?)

            Here is the simplyfied query:

            select
            "EWS_ID",
            "EWS_ETT_ID",
            "EWS_WOT_ID",
            "EWS_LVA_ID",
            "EWS_REIHENFOLGE",
            "EWS_LAE",
            "EWS_GV",
            "KURSE_PO"."LVATITLE" AS "Kurstitel",
            apex_item.checkbox(1, EWS_ID) "Löschen",
            apex_item.checkbox(2, EWS_ID) "Hinzufügen",
            apex_item.hidden(3, rowid) "Sort"
            from "#OWNER#"."ENDGUELTIGEWARTELISTESORT"
            LEFT OUTER JOIN "#OWNER#"."KURSE_PO"
            ON "ENDGUELTIGEWARTELISTESORT"."EWS_LVA_ID" = "KURSE_PO"."LVAID"
            WHERE EWS_PO_LVA_ID = :P0_XLVA 
            ORDER BY "EWS_REIHENFOLGE"
            
            

             

            The problem is the rowid in line 12. Without the rowid keyword it works AND when I delete de join (line 15-16)

            the rowid keyword is accapted.

             

            Thanks a lot!

            ilb

            • 3. Re: drag and drop interactive report
              jariola

              Hi,

               

              You can do update also by e.g. primary key.

               

              In witch table you have column where you store sort order?

              Use that table name e.g. like apex_item.hidden(3, ENDGUELTIGEWARTELISTESORT.rowid)

               

              Regards,

              Jari

              • 4. Re: drag and drop interactive report
                I_love_bits

                "tablename".rowid!!!

                stupid me...

                thx!