Currently our team is trying to connect to an external Postgres database and has been successful doing that. Once that was completed, we've had a hard time accessing the data inside the rows of that external database. We can see the column names, but not the data within the rows. We can also see that we have exposed properties within that table that corresponds to the correct number of rows within the external database.
My question is, would using a declare index be the proper way to access the data within those exposed properties so we can use it with our UI sections and if so, how do we do it?
Have you tried using the Database Table Class Mapping tool to help you create the data class and connect to your external Postgres table? Declare index is not necessary if you are not exposing properties from a BLOB.