22
Views
5
Comments
Widgets II unknown object
Question

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.

2018-04-30 04-17-15
Charles Raphel D

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

UserImage.jpg
eva wong

Charles Raphel D wrote:

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

Hi Charles, 

i try to swap  Movie.GenreId and MovieGenreId and it works. 

THANK YOU VERY MUCH!!!!!

UserImage.jpg
eva wong

Charles Raphel D wrote:

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

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 ?  


2018-04-30 04-17-15
Charles Raphel D

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") + "%"

2021-03-05 13-56-11
Ricardo Pereira
 
MVP

Hi Eva,


Is the variable MovieGenreId set to be of type Genre Identifier?


Best regards,

Ricardo

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.