<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <includeTree xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.adichatz.org/xsd/v0.8.7/generator/includeTree.xsd"> <grid rowHeaderVisible="true" sortedColumn="customerIdTC" entityURI="adi://myproject/model.customer/CustomerMM" id="table"> <crossReferences> <crossReference entitySetId="rentals" description="#MSG(customer, rentals)" axmlDetailURI="adi://myproject/model.rental/RentalDI" axmlTableURI="adi://myproject/model.rental/RentalTI" axmlQueryURI="adi://myproject/model.rental/RentalQUERY"/> <crossReference entitySetId="payments" description="#MSG(customer, payments)" axmlDetailURI="adi://myproject/model.payment/PaymentDI" axmlTableURI="adi://myproject/model.payment/PaymentTI" axmlQueryURI="adi://myproject/model.payment/PaymentQUERY"/> </crossReferences> <include adiResourceURI="#PARAM(CONTEXT_MENU)" id="tableContextMenu"/> <gridColumn property="customerId" pattern="######" sorted="true" id="customerIdTC"/> <gridColumnGroup text="coordinates" expanded="true" headerFont="#FONT(JFaceResources.HEADER_FONT)" headerWordWrap="false" id="coordinates"> <gridColumn summary="true" property="store" sorted="true" id="storeTC"> <columnText>return null != #ROW().store ? #MSG(customer, store) + ":" + #ROW().store.address.city.city + " - " + #ROW().store.address.city.country.country + " (" + #ROW().store.staff.lastName + ")" : "";</columnText> </gridColumn> <gridColumn property="address" sorted="true" id="addressTC"> <columnText>return null != #ROW().address ? #ROW().address.address + " - " + #ROW().address.city.city
 + " - " + #ROW().address.city.country.country : "";</columnText> </gridColumn> </gridColumnGroup> <gridColumn property="firstName" sorted="true" id="firstNameTC"> <columnBackground>return !row.isActive() ? #COLOR(SWT.COLOR_YELLOW) : null;</columnBackground> </gridColumn> <gridColumn property="lastName" sorted="true" id="lastNameTC"> <columnBackground>return !row.isActive() ? #COLOR(SWT.COLOR_YELLOW) : null;</columnBackground> </gridColumn> <gridColumn property="email" sorted="true" id="emailTC"/> <gridColumn property="active" pattern="CHECK_ONLY" sorted="true" id="activeTC"/> <gridColumn property="createDate" sorted="true" id="createDateTC"/> <gridColumn property="lastUpdate" sorted="true" id="lastUpdateTC"/> </grid> </includeTree>
Explanations:
<columnText>return null != #ROW().address ? #ROW().address.address + " - " + #ROW().address.city.city + " - " + #ROW().address.city.country.country : "";</columnText>
is equivalent to
<columnText> if (null != customer.getAddress()) return customer.getAddress().getAddress() + " - " + customer.getAddress().getCity().getCity() + " - " + customer.getAddress().getCity().getCountry().getCountry(); else return ""; </columnText>
So, this grid controller works with query containing all needed jointures. E.g. use example query described in page complete query.