Hello
I'm using APEX 23.2 over a 21C db.
I'm building a calendar, and set up a DA for a “View Changed” Event to get the current month shown in the calendar, setting the P170_BP item with the this.data.startDate javascript Expression.
The issue I have is that when I pass the value of the P170_BP to the query it is getting the old value, like the query is getting the value form P170_BP before the DA run and set it. For example, if I scroll the calendar to the month 8 (August) of 2023 coming from 2024, the query instead of getting the value of the current month (8), get 9 for September This also happens if start on January 2023, but this time instead of getting 8 (August), it get 7 (July)
Anyone knows if there is a way to set the value of the item P170_BP, before its send to the query?
Thanks