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.
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
select 'Jun/19' AS DISPLAY_VALUE,
20190601 AS RETURN_VALUE
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
where vlin_proj_id = :P1_PROJ
ORDER BY 2 DESC