Hi, i am following the pdf to develop my osmdb application and when i am trying to show the entrire crew and cast information by clicking on a screen i am getting this error:-
Hi Satvik,
Can you please check your service center for any error logged while you are trying to open this page and share it here?
Go to service center click Monitoring => Errors
If you can share your OML also this will help
Hi, this is the error i am getting in the service center, i think this is related to the sql query that we have to add
You can click icon in screenshot below and after opening service center web page login with your username and password
Its issue in order by clause please remove @MovieId from this line and keep it like this:
Order by Fullname
Here is my working file...
Please add new person to same movie with role Actor or Crew from "Add Cast/Crew" screen
Thanks! i was thinking that data was added automatically when i created the entity of person role
Not all entities in this exercise auto populated with data. So regarding this entity you need to start using screens functionalities to save data
Please match the SQL query.
SELECT {Person}.[Id], {Person}.[Name] + ' ' + {Person}.[Surname] Fullname FROM {Person} JOIN {PersonMovieRole} ON {PersonMovieRole}.[PersonId] = {Person}.[Id] JOIN {PersonRole} ON {PersonRole}.[Id] = {PersonMovieRole}.[PersonRoleId] WHERE {PersonMovieRole}.[MovieId] = @MovieId AND {PersonMovieRole}.[PersonRoleId] IN (@ActorRole, @CrewRole) ORDER BY Fullname
to your sql query.
it seems , "ORDER BY Fullname@MovieId" this is incorrect. It should be ORDER BY Fullname
I am getting no rows returned when i am running this sql query
First thing make sure you are passing values to input parameters into Test Inputs tab
Second thing make sure that following tables have data:
- Person
- PersonMovieRole
- PersonRole
If not please open you web application and start adding data
Check your PersonMovieRole database. There should some record to show data. Then provide the input for example:
You will see output like below:
Hope this help
I am still getting this, please help me
Also i am seeing this data for person movie role:-