New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Criteria properties should allow indirect relationships to object's tables #13

Open

tfreitasleal opened this issue Sep 16, 2017 · 0 comments

Assignees

Labels

Collaborator

tfreitasleal commented Sep 16, 2017

Csla object GroupsProperties is a list of GroupProperties (GroupsProperties table)
Table GroupsProperties has a Foreign Key for GroupID of table Groups
There is a UsersGroups table that makes the relation ship between Groups table and Users table (Foreign Keys UserID and GroupID)
The get criteria of GroupsProperties is UserID on table UsersGroups

The generator finds 2 tables:

GroupsProperties (from value properties)
UsersGroups (from properties of the get criteria) that can't be related.
The generator should find out that an INNER JOIN is need to the Groups table.

tfreitasleal added the enhancement label

tfreitasleal self-assigned this

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment