Joins in Serenity Platform
Due to relationships, we frequently do joins when searching databases. These joins tend to be LEFT or INNER joins.
Entities created using Serenity can be used in the same ways as SQL views, allowing you to add fields from other tables and query them as if they were one large merged table.
A. Scenario - if there is some master table like city master as its primary key in User Table
1. Show City Information in User Entity & User Form using LeftJoin Attribute
2. Show Country Information in User Entity & User Form Where Country table is directly related with City instead of User
B. Scenario - if there User Table has referenced/Primary Key in another table as Foreign Key
Entity classes can additionally have the LeftJoin attribute attached to them. For Example User is Userd in in UserDetail Table and we want to show address from User detail table into User Entity