modifying the viewobject means in the sense change/altering query you mean?
I was using a view criteria to change the view object content.
I managed to fix the problem by setting
fetchSize = -1
rangeSize = -1
I don't know if it's ok what i did, but it works now .
If you guys know any other way to fix it, or if my logic is wrong please tell me.
Your solution will break your system if the table you export has many rows (e.g. >1000) as all rows are read into memory.
It sounds strange that you don't get any result of you apply a view criteria to your vo. Have you executed the query before trying to export the result?
Can you post the code used for the export?
<af:exportCollectionActionListener type="excelHTML" exportedId="foodTable"
I just use the component.
Have you executed the query before trying to export the result?
Yes, i have a another button that applies the view criteria.
I don't think that there will be a problem with >1000 because i don't render the tables.. Or it doesn't matter?
I didn't fix anything with the changes made .
The problem is like this, i can modify as many times as i want the table before exporting it, but if i modify it even once after exporting, then the second time that i try the export it doesn't work.
The memory conception is not dependant on rendering the table, the memory is used reading the data from the table into memory. Seeing the fetch size to -1 will read all dies into memory at once, disabling all caving or other memory techniques.
You may want to check some sample https://pinboard.in/search/u:OracleADF/?query=export
I tried close to everything that you gave me.
I will try to explain again, as good as i can.
two tables on the page (render = false) T1 and T2
two buttons with exportCollectionActionListener in them B1 and B2
and another button that adds applies view criteria to the view objects. B3
If i don't click on B3 the other components work ok.
If i don't click on B1 or B2, and click on B3.. the export works just the first time.
I simply don't get why it doesn't work.
The problem was from "exportCollectionActionListener", if the view object has just one row then the export works just the first time, the second time doesn't work. If it has more than one row, then there is no problem.
JDeveloper Version 22.214.171.124.0