I am creating an application for my organization but I am faced with a baffling error. More specifically, I have a very basic interactive grid report that is populated by the following SQL query:
select * from mp_disposal_events;
At the moment I only have 1 row in the table mp_disposal_events as evidenced by viewing the table in Object Browser as well as executing the above SQL query in SQL commands. However, in the application the report has 3 rows. Could someone explain what could be causing this behaviour and what I should be looking into to address it? I am relatively new with Oracle APEX.
I can provide more information if it would help debug the issue. Thank you in advance.