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]

Hi,

sys_group_has_skill 100 grpskill

sys_user_grmember 300 grpmem grpmem_group=grpskill_group

sys_user_has_skill 400 userskill userskill_user=grpmem_user && userskill_skill

Regards
Ankur

[Hareesha]

When i use above query i will be getting all groups,skills and users.But i need a user who is part of parent of group and skill

[Ankur Bawiskar]

I don't think dot walking to parent would work

you might have to include one more table to database view i.e. sys_user_group so that you can use parent field

Regards
Ankur

[Hareesha]

i have tried using sys_user_group table but no luck