Narrowing the database view with a where clause

[miyu]

In the tasks table, I want to display only records whose Task type is Application and Request task (u_application_and_request_task) or Reservation and Result (u_reservation).
I have set the condition in the where clause as follows, but records of other Task types (e.g. incident) are also displayed.

How can I fulfill this requirement?
I do not want to use the filter function.

[Community Alums]

Hi 

In addition to information shared here, you can make use of below article to see which operators are supported in where clause to narrow down your result.
KB0815239 

Thanks

Abhishek Pandey