Hi,
Hoping someone can shed some light on this as I couldn't find anything online or in the forums on it.
I have a BIRT report that has some custom javascript interaction on images. Clicking on an image changes the status of the data row by Javascript changing the image (toggles a tick for selecting the row), and also posts the row's id off to a backend java service using ajax. This service updates the status column on the data row in the dB. This is all successful and I am quite proud of myself as I'm new to BIRT
The status of said data row started off as unselected, and now is selected both on screen, as Javascript has changed the image on the client side, and in the dB. However, if I go to page two of my BIRT report results, and then come back to page 1 again, the image defaults back to the previous image. My understanding is that this is due to the report have the status unselected against that data row cached somewhere, rather than re-querying the dB to see if it has changed. If I come out of the report and run it afresh, the data row and it's image are correct (selected status) as it has retrieved the updated status from the dB this time.
Can I force this report to do a re-query for the data on a page jump each time the user jumps to the next page? Or is there another way of doing this - maybe updating the data row in the BIRT report cache that the report uses?
Anyone's help on this would be greatly appreciated!
Thanks in advance,
Neil
