I am trying to get a rolling number whenever proposals get activated. I am able to execute the following SQL script which gets me a figure for proposals activated today using this:
select * from cr_managementinformation where activation_date >= '06-JUNE-23'
order by proposal_status
When I change the input type to Batch then i use this:
SELECT * FROM cr_managementinformation
WHERE PROPOSAL_NUMBER > ?
AND activation_date = TO_DATE(current_date)
ORDER BY PROPOSAL_NUMBER ASC
The rising number does not match the batch number. i.e. the batch number of activations today is 302 but the rising number is only 5.
Can you help?