How to join table in LCDS

[Former Community Member]

Hello,

How can I join tables in LCDS and show them in a datagrid?

I run LCDS3 and tomcat.

All help is appricitated

[Former Community Member]

If an entity has relationships, joins are implicit e.g.: A customer can have multiple orders - Having access to customer gives you access to all the orders associated with the customer. Here the joins are implicit.

However, we don’t support randomly joining tables (that don't have a relationship in the data model) in this release. You are required to create a custom data management assembler, which gives you full control over the SQL. It is likely that the next release may support joining tables directly from the data model.

-Anil

[Former Community Member]

Thank you very much Amil for this information.

In my example, how can I show data from two tables joined implicitly in one datagrid? I can create 2 datagrids, but that is now what I need.

Thank you for time.

[Former Community Member · Accepted solution]

User (firstName, lastName,Address)

Address(streetAddress,State, Country,Zipcode)

If you wanted to show the data below in your data grid

---------------------------------------------------------------------------

firstName        |       lastName   |  State

---------------------------------------------------------------------------

user.firstName | user.lastName | user.address.state