0 Replies Latest reply on Jul 11, 2019 2:21 PM by 3883369

    Implementation of TREE functionality

    3883369

      Guys, good morning.

       

      I need to create in Apex two TREE lists that will tinker with two different information in my database. One would return dates for processing that I would have to search for data in my application.

       

      Example I have a list of processing dates that are stored by Month / Year Ex: 20170101/20171201, where yyyy / mm / dd.

       

      inside this I need my list to appear as follows.

       

      2019

           07/2019

           06/2019

           05/2019

           04/2019

           03/2019

           02/2019

           01/2019

      2018

           12/2018

           ...

           01/2018

           ...

      2016

          12/2016

          ...

       

      In this case my query does not have the Hieraquias because I bring the dates even though I can process in the standard  20190701 / 20190601 / 20190501 ... 20161201.

       

      I've been thinking of creating a table and this is popular or if you have any idea how to do this using a query of mine.

       

      select 'Jul/19' AS DISPLAY_VALUE,

             20190701 AS RETURN_VALUE

        from dual    

      union

      select 'Jun/19' AS DISPLAY_VALUE,

             20190601 AS RETURN_VALUE

        from dual  

       

      The query is similar, but would return the values already in a pattern that I need.

       

      SELECT DISTINCT FNC_FORMAT_PERIOD_1(VLIN_PERIOD,0) AS DISPLAY_VALUE,

             VLIN_PERIOD AS RETURN_VALUE

        from indicators

      where vlin_proj_id = :P1_PROJ

      ORDER BY 2 DESC