Logged in Position's Child Position Count

In this post we are going to see the SQL used to find logged in position's child position count. Using this SQL we can find the count of child position added to a parent position.


Siebel will show all the records mapped to the user's active position and its child position in user interface.

Using this SQL we can estimate approximate count of records displayed for position in the User interface.

User Child Position Count SQL:

Select a.party_id, count(*)
from siebel.s_party_rpt_rel a,
siebel.s_party b,
siebel.s_party_per c
where a.party_id =c.party_id
and c.person_id = (Select row_id from siebel.s_user where login = '')
and a.sub_party_id = b.row_id
group by a.party_id;


Thanks! for reading the post. Hope this is helpful.