Saturday, September 7, 2013

How to query 'My' Activity

My activity means, all the activities where I am associated as employee.
Its MVF, so an activity can be associated to more then one employee.

Siebel maintains this association in S_ACT_EMP table, So every time an activity is created and associated to emp, a record is created in S_ACT_EMP.

Steps to query My Activity

1. Create Link
     Parent BC: Action Employee
     Child BC: Action
     Source Field: Activity Id
     Destination Field: Id

2. Create IO based on parent BC as Action Employee and Child BC as Action and using the link created above in BO

3. Once IO is created
query on Action Employee.Employee Id,
it will fetch all My Activity in parent child hierarchy.


No comments:

Post a Comment