Related data when relationships don't exist in database


#1

Hi,

Is it possible to get related data back where physical relationships don’t exist in the database. We have a data mart, and we have logical relationships not enforced by referential integrity, but need to join tables on an ad-hoc basis.

Regards

S


#2

Currently the relationships are determined solely on the database schema detected, so these logical relationships can’t be returned by DreamFactory. This is not a bad idea for a feature request for v2.0, so I’ve recorded it for our engineers.


#3

Hi

That would be great. Often you might want to join a table to a view for example. Being able to define the child table and the join would be very helpful.

Regards

S


#4

This is covered by the v2 feature of virtual relationships. Just commenting for the sake of marking this resolved.