6 Replies Latest reply: Sep 28, 2017 2:53 AM by zahid Rahim RSS

    Date Filter to impact data

    zahid Rahim

      Dear Experts,

       

      I am making an aging report. Suppose i have 2 tables:

       

      Buckets:

      Days     Bucket

      1                 0-30

      2                 0-30

      3                 0-30

      4                 0-30

      5                 0-30

      31               31-60

      32               31-60

      33               31-60

      61               31-60

      62               31-60

      63               31-60

       

      Main_query

      TRDate                    Stock_Qty

      01-SEP-2017          10

      02-SEP-2017          20

      05-SEP-2017          30

      10-SEP-2017          40

       

      Load Script joins these two tables like below:

       

      SYSDATE-TRDATE  = Days

       

      to get the bucket wise quantity.

       

      Now the issue is instead of a fixed SYSDATE i want to give a date filter on front end and the then buckets should be calculated as per the date selected and data change accordingly.

       

      Regards,

       

      Zahid Rahim