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
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.
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
This is covered by the v2 feature of virtual relationships. Just commenting for the sake of marking this resolved.