Version: GeneXus 16

GeneXus course

Analyst Level

How to list related information

How to use nested For eachs to print related information (the categories and their tourist attractions). This case is known as join. 

Junior level

Analyst Level

Optional



Click here for a PDF transcript of the video.

A procedure is implemented with a couple of nested For eachs, where the information of the external For each is related to that of the internal For each with a relation of one to many. An explanation is given regarding the difference between this case (join) and cases where there is no evident relation between the information (Cartesian product).

We recommend that you view the "Introduction to procedures and listings. Command to query the database" video.

Additionally: nested For eachs –related navigations, independent For eachs, join, print, Cartesian product, printblock, layout, source, base table, extended table, pdf report. 

 

Lessons

Presentation

Objective:
Provide the key theoretical concepts behind GeneXus and skills to apply them in practice, in order to make the best use of the program. This course includes the knowledge offered at the Junior level, complementing it with more in-depth concepts and adding topics of greater complexity.  

Designed for:
Those who want to achieve sufficient mastery of GeneXus so as to develop applications of medium complexity without the need for support, except for complex issues. 

Course requirements:
For those who don’t have prior programming and database knowledge, reading this material before starting the course is recommended.

Suggested methodology for this course:
  • Instructor-led: Follow the instructions in the recommendations and suggestions document, which you can download from the download center together with the course materials.
  • Self-study: Watch each video and try to replicate in GeneXus the demos made by the teacher (except GeneXus Demo). Then do the practical exercises corresponding to the topic discussed in the video.

Suggested course duration: 100 hours
Introduction and demo: 1 hour
Theory/Practice: 72 hours
Workshop: 12 hours
Review of fundamental concepts: 12 hours
Exam preparation: 3 hours

Exam:
Students will be able to take the exam corresponding to the GeneXus Analyst certification. This exam is taken on a computer and includes multiple choice and true/false questions about the topics learned throughout the course, to confirm that the student has effectively learned the essential concepts required for developing applications with GeneXus, according to the Analyst Level.

In preparation for the exam, it is suggested that candidates study the material titled Review of fundamental concepts, and work on this practice exam.
Exam duration: 120 minutes.

>> To take the instructor-led course, we recommend that you check the Course Calendar, contact an Academic Partner in your country, or send us an email to training@genexus.com
 

Accelerate your learning with teacher support

With instructors and fellow students, it's even easier to learn.

Materials

In this section, you will find a PDF document with practical exercises similar to those carried out in each class/video. Some new and optional exercises are included. We recommend that you work on them as you study each topic.

You will also find all the Theory of the course in PDF format (transcript of all videos) to read / print it. 

Images: This file contains the images that you will have to use in the Practice exercises.

Conceptual summary: PDF document with a summary of the most important concepts of the course. You are encouraged to read this document at the end of the course, after watching all the videos and doing all the Practice exercises.

Bonus Material

To take the course and work on the exercises you need the trial version of GeneXus.
 
GeneXus  Trial  

KB solution of practical exercises
This KB is provided so that you can compare it with yours after doing all the practice exercises:

Name: TravelAgency_GX16Course
Server: http://samples.genexusserver.com/v16