• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Workflow
#1
Hello,

Is it possible to insert a step into a workflow that waits until an action is executed?

I have an approval step. If the approver sends an information request to the recipient, the workflow must wait untill an email is received. Then, it should go again to the approval step.

Is there any way to do this?

Thanks.
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.

#2
(10-30-2018, 09:28 AM)pms23 Wrote: Hello,

Is it possible to insert a step into a workflow that waits until an action is executed?

I have an approval step. If the approver sends an information request to the recipient, the workflow must wait untill an email is received. Then, it should go again to the approval step.

Is there any way to do this?

Thanks.

We use the 'Waiting for external application' step.  In your scenario, I would have the Information Request lead to this step.  You close the step using Business Rule and/or Alert-Business Rule combo.  Let me know if you need more info.

Thumbnail(s)
   
jhendrix, proud to be a member of EV CONNECT FORUM since Apr 2016.

#3
(10-30-2018, 09:38 AM)jhendrix Wrote:
(10-30-2018, 09:28 AM)pms23 Wrote: Hello,

Is it possible to insert a step into a workflow that waits until an action is executed?

I have an approval step. If the approver sends an information request to the recipient, the workflow must wait untill an email is received. Then, it should go again to the approval step.

Is there any way to do this?

Thanks.

We use the 'Waiting for external application' step.  In your scenario, I would have the Information Request lead to this step.  You close the step using Business Rule and/or Alert-Business Rule combo.  Let me know if you need more info.

Hello,
Perhaps there's another solution with TSA (Technical support agent).

You can create an email for workflow "blue arrow" (more information) that used mailto and in the same time suspend ticket.

The forge mailto HTML tag used @SOLUTION@='RESTART' for simple exit (go again to approval)

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#4
(10-31-2018, 05:18 AM)ABBE Philippe Wrote:
(10-30-2018, 09:38 AM)jhendrix Wrote:
(10-30-2018, 09:28 AM)pms23 Wrote: Hello,

Is it possible to insert a step into a workflow that waits until an action is executed?

I have an approval step. If the approver sends an information request to the recipient, the workflow must wait untill an email is received. Then, it should go again to the approval step.

Is there any way to do this?

Thanks.

We use the 'Waiting for external application' step.  In your scenario, I would have the Information Request lead to this step.  You close the step using Business Rule and/or Alert-Business Rule combo.  Let me know if you need more info.

Hello,
Perhaps there's another solution with TSA (Technical support agent).

You can create an email for workflow "blue arrow" (more information) that used mailto and in the same time suspend ticket.

The forge mailto HTML tag used @SOLUTION@='RESTART' for simple exit (go again to approval)

P.ABBE

Thank you for your answers!

I'm trying to use a business rule to advance the workflow to the approval step, as soon as an email is received.
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.

#5
If you want to use a BRule to advance the workflow, you can look for your named action on the SR that has a null end date and close it with a Web Service Step. We have a generic one that we use for a variety of Business Rule definitions.
jhendrix, proud to be a member of EV CONNECT FORUM since Apr 2016.

#6
(11-01-2018, 09:26 AM)jhendrix Wrote: If you want to use a BRule to advance the workflow, you can look for your named action on the SR that has a null end date and close it with a Web Service Step.  We have a generic one that we use for a variety of Business Rule definitions.

I'm using the webservice step in the workflow calling "Finish an action attached to an incident/request".

Consulting the DB (SD_PROCESS_POOL_LAST_ACTIVITY), the BR is created but it doesn't have an end date.

I defined a BR in AM_ACTION table using condition:

Code:
-- Original Version --
IF EXISTS (
select RFC_NUMBER from [50005].SD_REQUEST
inner join [50005].SD_CATALOG on SD_CATALOG.SD_CATALOG_ID = SD_REQUEST.SD_CATALOG_ID
where SD_CATALOG.PACKAGE_NAME = 'DM'
and sd_catalog.SD_CATALOG_ID = 5683
and SD_REQUEST.END_DATE_UT is null
and sd_request.request_id in
(select REQUEST_ID from [50005].am_action
where ((AM_ACTION.ACTION_LABEL_PO in ('Info Request Recipient', 'Info Request Requestor')
and AM_ACTION.END_DATE_UT is null)
and ((AM_ACTION.DONE_BY_ID = SD_REQUEST.REQUESTOR_ID) or (AM_ACTION.DONE_BY_ID = SD_REQUEST.RECIPIENT_ID))))
and sd_request.request_id in
(select am_action.REQUEST_ID from [50005].am_action
inner join [50005].SD_REQUEST on SD_REQUEST.REQUEST_ID = AM_ACTION.REQUEST_ID
inner join [50005].SD_CATALOG on SD_CATALOG.SD_CATALOG_ID = SD_REQUEST.SD_CATALOG_ID
where ACTION_TYPE_ID = 79 and
((AM_ACTION.DONE_BY_ID = SD_REQUEST.REQUESTOR_ID) or (AM_ACTION.DONE_BY_ID = SD_REQUEST.RECIPIENT_ID)))
)
BEGIN
@@FIRETRIGGER@@
END

In the process, I'm using a conditional step to find the ACTION_ID. The ACTION_ID is stored as a variable.

Code:
select AM_ACTION.ACTION_ID from [50005].AM_ACTION
inner join [50005].SD_REQUEST on SD_REQUEST.REQUEST_ID = AM_ACTION.REQUEST_ID
inner join [50005].SD_CATALOG on SD_CATALOG.SD_CATALOG_ID = SD_REQUEST.SD_CATALOG_ID
where AM_ACTION.ACTION_LABEL_PO in ('Info Request Recipient', 'Info Request Requestor')
and SD_CATALOG.PACKAGE_NAME = 'DM'
and ((AM_ACTION.DONE_BY_ID = SD_REQUEST.REQUESTOR_ID) or (AM_ACTION.DONE_BY_ID = SD_REQUEST.RECIPIENT_ID))
and AM_ACTION.END_DATE_UT is null
and sd_catalog.SD_CATALOG_ID = 5683
and SD_REQUEST.REQUEST_ID = @@ID@@


In the webservice step, the variable is used in parameter ACTION_ID.

Any idea on what's wrong?

Thank you!
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.

#7
(11-02-2018, 09:57 AM)pms23 Wrote:
(11-01-2018, 09:26 AM)jhendrix Wrote: If you want to use a BRule to advance the workflow, you can look for your named action on the SR that has a null end date and close it with a Web Service Step.  We have a generic one that we use for a variety of Business Rule definitions.

I'm using the webservice step in the workflow calling "Finish an action attached to an incident/request".

Consulting the DB (SD_PROCESS_POOL_LAST_ACTIVITY), the BR is created but it doesn't have an end date.

I defined a BR in AM_ACTION table using condition:

Code:
-- Original Version --
IF EXISTS (
select RFC_NUMBER from [50005].SD_REQUEST
inner join [50005].SD_CATALOG on SD_CATALOG.SD_CATALOG_ID = SD_REQUEST.SD_CATALOG_ID
where SD_CATALOG.PACKAGE_NAME = 'DM'
and sd_catalog.SD_CATALOG_ID = 5683
and SD_REQUEST.END_DATE_UT is null
and sd_request.request_id in
(select REQUEST_ID from [50005].am_action
where ((AM_ACTION.ACTION_LABEL_PO in ('Info Request Recipient', 'Info Request Requestor')
and AM_ACTION.END_DATE_UT is null)
and ((AM_ACTION.DONE_BY_ID = SD_REQUEST.REQUESTOR_ID) or (AM_ACTION.DONE_BY_ID = SD_REQUEST.RECIPIENT_ID))))
and sd_request.request_id in
(select am_action.REQUEST_ID from [50005].am_action
inner join [50005].SD_REQUEST on SD_REQUEST.REQUEST_ID = AM_ACTION.REQUEST_ID
inner join [50005].SD_CATALOG on SD_CATALOG.SD_CATALOG_ID = SD_REQUEST.SD_CATALOG_ID
where ACTION_TYPE_ID = 79 and
((AM_ACTION.DONE_BY_ID = SD_REQUEST.REQUESTOR_ID) or (AM_ACTION.DONE_BY_ID = SD_REQUEST.RECIPIENT_ID)))
)
BEGIN
@@FIRETRIGGER@@
END

In the process, I'm using a conditional step to find the ACTION_ID. The ACTION_ID is stored as a variable.

Code:
select AM_ACTION.ACTION_ID from [50005].AM_ACTION
inner join [50005].SD_REQUEST on SD_REQUEST.REQUEST_ID = AM_ACTION.REQUEST_ID
inner join [50005].SD_CATALOG on SD_CATALOG.SD_CATALOG_ID = SD_REQUEST.SD_CATALOG_ID
where AM_ACTION.ACTION_LABEL_PO in ('Info Request Recipient', 'Info Request Requestor')
and SD_CATALOG.PACKAGE_NAME = 'DM'
and ((AM_ACTION.DONE_BY_ID = SD_REQUEST.REQUESTOR_ID) or (AM_ACTION.DONE_BY_ID = SD_REQUEST.RECIPIENT_ID))
and AM_ACTION.END_DATE_UT is null
and sd_catalog.SD_CATALOG_ID = 5683
and SD_REQUEST.REQUEST_ID = @@ID@@


In the webservice step, the variable is used in parameter ACTION_ID.

Any idea on what's wrong?

Thank you!

SOLVED

Two business rules were created. It's working fine. Smile
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.






Users browsing this thread: 1 Guest(s)