Home      Members   Calendar   Who's On

Welcome Guest ( Login | Register )
      

Home » Skelta BPM.NET 2006 » Skelta BPM.NET 2006 » Application Development » Queue WorkItem Allocated


Queue WorkItem AllocatedExpand / Collapse
Author
Message
Posted Saturday, January 23, 2010
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior 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.

Post #1794
Posted Monday, January 25, 2010
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme 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

Post #1797
Posted Monday, January 25, 2010
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior 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 

Post #1798
Posted Friday, February 19, 2010
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior 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 here

SELECT @Status=InternalStatus

FROM INSERTED

IF @Status = 'AW'

BEGIN

SELECT @Conteo=COUNT(*)

FROM INSERTED si, SKQueue s, SKVirtualActor sa

WHERE si.QueueId=s.Id

AND s.[Name]='CExternas'

AND si.VirtualActorId = sa.Id

IF @Conteo > 0

BEGIN

INSERT INTO Notificaciones

(WorkItemID,ActivityDisplayName,NotesId,SubjectId,UserIDString,[Status])

SELECT si.Id, si.ActivityDisplayName, si.NotesId, si.SubjectId, sa.UserIDString,0

FROM INSERTED si, SKQueue s, SKVirtualActor sa

WHERE si.QueueId=s.Id

AND s.[Name]='CExternas'

AND si.VirtualActorId = sa.Id

AND si.id NOT IN (SELECT WorkItemID FROM Notificaciones)

END

END

END

Post #1832
Posted Monday, February 22, 2010
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme 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
Post #1835
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
-
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:57am

 
Execution: 0.125.10 queries.Compression Enabled.

Copyright © 2002 - 2009 Skelta Software. All rights reserved. Tel: 1 (678) 306 4110 | Email:sales@skelta.com
Skelta - A BPM Workflow Software Company