How to create Database view with condition?

guy
Kilo Contributor

‎01-20-2016 04:52 AM

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.

find_real_file.png

Preview file
132 KB
0 Helpfuls
  • 5,999 Views
5 REPLIES 5

gputker
Tera Contributor

‎06-13-2019 11:02 PM

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.

0 Helpfuls