Is there a way to refresh data in a form/report once it has been opened? The prime example of this need is "My Activities" under Business Partner Reports. A person could leave this window open and see all new activities assigned to them.
When you open any report in the system including a user query, the current data is loaded to the report, however when there is a modification to the data while the form is open, it will not be refreshed. You must run it again.
Using relational databases such as SQL, you must activate a query in order to receive current data, and that is the reason why any application that uses these databases, would behave the same