Welcome, Guest
Username: Password: Remember me
This category is read only
  • Page:
  • 1

TOPIC: About relational databases and JooDB

About relational databases and JooDB 7 years 1 week ago #2328

  • Dirk
  • Dirk's Avatar Topic Author
  • Offline
  • Posts: 1112
  • Karma: 21
  • Thank you received: 202
The Pro-Version is able to display relational linked tables (content) within the main table.
The relational feature is realized very simple by subtemplates.
You just must tell JooDB how the tables are linked. Normally by the table id's.

Example
TABLE_MOVIES.id_directors is the same value than the related TABLE_DIRECTORS.id. If you now have a list of directors and you want to show all movies by a director you just create a subtemplate MOVIES, set TABLE_MOVIES.id_directors related to TABLE_DIRECTORS an customize the output. If you now insert a {subtemplate MOVIES} into your main template JooDB will display a list of movies from that director.


For more info about relative databases:
en.wikipedia.org/wiki/Relational_model

The relational Support is not complete and for simple purposes only!
  • You can not edit subtable data directly at the backend yet.
  • You can not search in subtables

This message has an attachment image.
Please log in or register to see it.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1