Announcement Announcement Module
Collapse
No announcement yet.
DBRE Concatentated Foreign Key Reference in List.jspx, show.jspx, & Create.jspx Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • DBRE Concatentated Foreign Key Reference in List.jspx, show.jspx, & Create.jspx

    I have two tables, people and users. People has an ID(Primary Key), first name, and last name field. Users has an ID(Primary Key), Person ID(Foreign Key - related to people primary key), username, and password. The foreign key reference on users is shown as the first name and last name from the People table concatenated (based on foreign key reference), which is fine for this example but is it possible to have just one field of those fields show, i.e. just the first name? Thanks.

  • #2
    You can create a property with @Transient annotation. Transient properties are no stored or retrieved from database. Then, push-in get/set methods and implement your requirement.

    Comment

    Working...
    X