| | | Junior Member
       
Group: Forum Members Last Login: Friday, January 28, 2011 Posts: 5, Visits: 28 |
| | Hello Fellows, First of all, sorry for my english. I have an approval action first, once it is done (approved) the next activity is a choice activity bind to a queue, I need to send an information or an email to the actor who approved telling the actor who was allocated that task. The queue assign tasks automatically. I need to get the Actor who the queue allocates a task to. |
| | | | Supreme Being
       
Group: Forum Members Last Login: Thursday, January 12, 2012 Posts: 93, Visits: 121 |
| | Hi, Basically you are trying to get the name of the actor to whom the task is allocated through Queue (auto or manual)..right? The details of the actor(s) to whom the approval/human work item gets assigned can be accessed by declaring a variable of type array with the following syntax: '^'+CurrentActivity.Name+'ActingUsers' For example, ^ManagerApprovalActingUsers. This would work only if the activity is assgined to an actor directly. In case of Queue workitems, there is no such built-in variable/option at this moment, however it may be incorporated in the future as it's in the wish list. Thanks, Sri |
| | | | Junior Member
       
Group: Forum Members Last Login: Friday, January 28, 2011 Posts: 5, Visits: 28 |
| | Hi Rao, Thanks for your reply. Exactly what I need is when the assign is made automatically. I think that exist a way because when the process get to that particulary action, in the BAM I can see the user who was assigned and the status = "Queue Item Allocated". Regards, Javier |
| | | | Junior Member
       
Group: Forum Members Last Login: Friday, January 28, 2011 Posts: 5, Visits: 28 |
| | I made a trigger in the SKWorkItem Table. This trigger stored data in another table [Notificaciones] and build a service that read from thar table and send an email to notify who are going to act for a particular task. Everything is working great !!!!!! This is the trigger code: CREATE TRIGGER [dbo].[Informa_Notifcacion] ON [dbo].[SKWorkItem] FOR UPDATE, INSERT AS DECLARE @Conteo AS INT DECLARE @Status AS CHAR(2)BEGIN SET NOCOUNT ON;-- Insert statements for trigger hereSELECT @Status=InternalStatusFROM INSERTEDIF @Status = 'AW'BEGINSELECT @Conteo=COUNT(*)FROM INSERTED si, SKQueue s, SKVirtualActor saWHERE si.QueueId=s.IdAND s.[Name]='CExternas'AND si.VirtualActorId = sa.IdIF @Conteo > 0BEGININSERT INTO Notificaciones(WorkItemID,ActivityDisplayName,NotesId,SubjectId,UserIDString,[Status])SELECT si.Id, si.ActivityDisplayName, si.NotesId, si.SubjectId, sa.UserIDString,0FROM INSERTED si, SKQueue s, SKVirtualActor saWHERE si.QueueId=s.IdAND s.[Name]='CExternas'AND si.VirtualActorId = sa.IdAND si.id NOT IN (SELECT WorkItemID FROM Notificaciones)ENDENDEND |
| | | | Supreme Being
       
Group: Forum Members Last Login: Thursday, June 02, 2011 Posts: 90, Visits: 150 |
| Please note that Skelta doesn't recommend writing trigger on Skelta transaction tables.
You can use Implementation of Custom WorkItemForm to capture the User Workitem events. Refer the Skelta BPM.Net Developer guide for the same. Also note that as of now WorkItemForm doesn't support events for Queue Workitems.
Regards,
Moderator |
| |
|
|