Database views is not showing records but showing the count

[Hareesha]

Database views is not showing records but showing the count.

Below are the where clause i have used.

[Ankur Bawiskar]

share the where clause when you are using 5 tables

[Hareesha]

[Ankur Bawiskar]

Hi,

update where clause for sys_user_group as this

usergrp_parent=grpmem_group

Regards
Ankur

[Hareesha]

I am getting No records found

[Ankur Bawiskar]

share your latest conditions

Also are you sure you have records satisfying the where clause.