How to create Database view with condition?

[guy]

Hi,

I'm trying to create a table view that displays only the approvals with status in "requested". Somehow the table shows all approvals without a filter. Below is attached the view created and conditions.

Thanks,

Guy.

[gputker]

I got this working on a choice (TRUE/FALSE) field:

(cirel_child=eaapps_sys_id || cirel_parent=eaapps_sys_id) && eaapps_u_critical_application=1

The text in black joins two of the same tables with an OR condition.  The text in red returns only TRUE values for the critical application field.

Took a lot of tries - I'm rapt.