2 Replies Latest reply: Jun 12, 2014 6:26 AM by Kalyana Sundaram RSS

    How import/call function from PostgreSQL to QV

      I have a problem with function from my DB in PostgreSQL, I need call or import the function but ONLY appear the TABLES when I try select it.

       

      I need something like that:

      SQL     (

       

           SELECT    IO.DOCUMENTNO AS DOCUMENT,

                    FUNCTION_DB(IOLINE.M_PRODUCT_ID, IO.MOVEMENTDATE, 'AV') AS TOTAL

               FROM IO LEFT JOIN IOLINE ON IO.TABLE_IO_ID = IOLINE.TABLE_IO_ID

          

      )

       

      How can I do this when I am loading the tables in QlikView ?