a record view with data from multiple objects - Forum - Rollbase - Progress Community

a record view with data from multiple objects

 Forum

a record view with data from multiple objects

This question is answered

Hi I have an object 'customer type' which has a 'description' field. This is linked to another object 'customer'. They are related with many customers for a customer type. In a view of customer records i want to display the customer type 'description' field. Am I able to do this?

Verified Answer
  • As of now for external objects we don't support related fields. But what you can do is create a view in the database that uses joins to get column from related table and then map this view to Rollbase object.

All Replies
  • Hi,

    You can create a Related Field in the "Customer" object.

    Please refer to this link  documentation.progress.com/.../index.html

    Hope this helps!

    Thanks,

    Shivani.

  • Hi Thanks that works really well. Am I able to do the same thing with external objects? I am connecting via data direct cloud to an open edge db. I have imported a couple of tables to create objects. In the view of such objects can i reference fields in another object?

  • As of now for external objects we don't support related fields. But what you can do is create a view in the database that uses joins to get column from related table and then map this view to Rollbase object.

  • thanks for your help - we can look at doing that