a record view with data from multiple objects

Posted by intuita on 12-May-2016 05:37

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?

Posted by Anoop Premachandran on 17-May-2016 03:32

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

Posted by Shivani Silveri on 12-May-2016 05:51

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.

Posted by intuita on 12-May-2016 06:02

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?

Posted by Anoop Premachandran on 17-May-2016 03:32

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.

Posted by intuita on 25-May-2016 03:02

thanks for your help - we can look at doing that

This thread is closed