0 Replies Latest reply: Apr 4, 2013 1:11 AM by Carlos Adolfo Renteria RSS

    Execute a Sql from presentation qvw

      i have 3 documents in the aplication architecture

      Extraction

      Model

      Presentation

       

      in the extraction qvw i make a sql in the data base and store it in a qvd file

      then i load it and transform it in the model qvw.

      and in the presentation qvw show some data (expresions calculations charts)

       

      this sql is executing with a date parameter Today.

       

      but now in the presentation qvw i have a calendar table

       

      and i need

       

      if i select a date in this calendar filters make the sql extraction not with the parameter today

      make sql from presentation with this selected date

      transform it in the model qvw

      and show the same data (expresions calculations charts) but of the selection i made.

       

      how i can do this.....