Hello,
I have developed a page in our APEX 20.2 environment that has 2 form regions. The first region displays information on a database cluster (based on a previous button click which redirects to this page) and the source is from “Local Database” called CLUSTERS. The 2nd form region should display the contents from another table (SERVER) based on the clustername from the first region (P14_SOURCE_CLUSTERNAME) and I'm using source type of SQL Query with the following query:
select CLUSTERNAME,
SERVER,
OS,
NOTES,
LOCATION,
CPU,
CORESPERCPU,
VIP
from SERVER
where clustername = :P14_SOURCE_CLUSTERNAME;
I have verified there is a record in the SERVER table that corresponds with a record in the CLUSTERS table but for some reason no information is being displayed in the 2nd form region on the page. I had this working at one point but I apparently changed something on the page to keep this data from displaying.
I'm fairly new to APEX so I'm assuming it's something fairly obvious but I've checked everything I can think of and nothing seems to be working.
Below is a screen print of the page I'm attempting to develop. I have other regions I will need to add to this page that displays additional information on the source cluster but I would like to get this region working before adding additional regions.
Let me know if I need to provide more information.
Thanks in advance for any help.