I have two external objects A and B in RB that I am building from an external table. These tables are actually VIEWS in the database.
Now I am trying to have a related field in object A, from object B. Creating the related field is allowed normally, but the field keeps coming as empty.
I tried adding different fields as related fields in A, but they are all empty.
I did this same test with external objects mapped to external TABLES (not views, but actual tables in the DB), and it is working fine.
Looks like the issue has something to do with the DB VIEWS.
Any help with that please?
In what DB system and version are the views defined?
This will help QA try to reproduce your issue.
I have created a DB view and I could fetch the related fields without any issue. I have tried for both varchar() and int datatypes.
Can you confirm on what version of Rollbase you are facing this issue?
DB system is MySQL and Rollbase version we are using now is 4.0.4