Hi,
i am working on the data queries and widgets II exercise, when i doing page 33, part f.
When i try to add filter (MovieGenreId = NullIdentifier() or Movie.GenreId = MovieGenreId),
It has an error, said MovieGenreId is unknow object
I have create a combo box and it's variable MovieGenreId On Part 4.
So how can i fixed it ?
Thank you.
Hi Eva,
I'm guessing it is a simple problem where you typed MovieGenreId instead of Movie.GenreId. Let me know if this helped.
Thanks
Charles Raphel D wrote:
Hi Charles,
i try to swap Movie.GenreId and MovieGenreId and it works.
THANK YOU VERY MUCH!!!!!
HI Charles,
when i swsp it, it does not show any error, but however i open on the browser, use filter to chose the movie genre, its does not working.
The filter setting does not working ?
Hi eva,
Im guessing you are using a drop down to filter the movie listing. And i guess the functionality is to show the whole record when the movie genre in null.
If this is the try using the following filter
Movie.GenreId = MovieGenreId or IntergerTOText(MovieGenreId) like "%" + if(MovieGenreId = NullIdentifier(), "", "NULL") + "%"
Is the variable MovieGenreId set to be of type Genre Identifier?
Best regards,
Ricardo