stuck in tutorial step - please help

stuck in tutorial step - please help

  

Hi, I stuck in the tutorial which is "Data Queries and Widgets II Exercise.pdf" , page 8 , step J.

I don't know how to fetch the Title from GetMovieById Aggregate. Anyone can show me the step on getting Title from GetMovieById ? 


Thank You~ : )

What is the problem exactly?



Solution

Hi Jack,

You have an aggregate in preparation that has a filter on the form Movie.Id = MovieId (don't know if the names are correct).

So, you have the LIST (with a single record, because there are no two ID's repeated in the table) and the LIST.CURRENT <= First record returned from database.

To use in the page you simply type like this:

GetMovieById.List.Current.Movie.Title (or GetMovieById.List.Current.Title, don't remember).
But as you type, everytime you type the dot "." after an element, (like GetMovieById), it will fill automatically (when there is only a single option) or show you a list for you to pick.

Cheers,
Eduardo Jauch 

Solution

Hi Jack,
Its always better to choose it from the selection items as in the attached photo

Eduardo Jauch wrote:

Hi Jack,

You have an aggregate in preparation that has a filter on the form Movie.Id = MovieId (don't know if the names are correct).

So, you have the LIST (with a single record, because there are no two ID's repeated in the table) and the LIST.CURRENT <= First record returned from database.

To use in the page you simply type like this:

GetMovieById.List.Current.Movie.Title (or GetMovieById.List.Current.Title, don't remember).
But as you type, everytime you type the dot "." after an element, (like GetMovieById), it will fill automatically (when there is only a single option) or show you a list for you to pick.

Cheers,
Eduardo Jauch 

Thank you for your help ~


Mohamed ElMokadem wrote:

Hi Jack,
Its always better to choose it from the selection items as in the attached photo

This is useful for me , Thanks : )


Hi Guys,

I´ve gonne through the PDF and these help comments here but i kept getting the first movie in the "Add Cast/Crew to" title: "Star Wars: The Force Awakens". I'm guessing the MovieId is not getting passed from the MovieDetails screen to the "AddMovieParticipant" screen. Any hint?

Thanks!

José Reis wrote:

Hi Guys,

I´ve gonne through the PDF and these help comments here but i kept getting the first movie in the "Add Cast/Crew to" title: "Star Wars: The Force Awakens". I'm guessing the MovieId is not getting passed from the MovieDetails screen to the "AddMovieParticipant" screen. Any hint?

Thanks!

People, people, people...

In the aggregation i had "Movie.Id = Movie.Id" instead of "Movie.Id = MovieId". The left side seems to be the screen argument variable and not the structure item like I had it, watering in the rain...

I don't know if this is the right place to suggest tutorial enhancements, but in text "b) Add a GetMovieById Aggregate to the preparation to fetch the movie specified by the MovieId parameter." of page 6 of "Data Queries and Widgets II Exercise.PDF" I would be handy to refer to pages 16-17 of "Widgets I Exercise.pdf"