how can I check an attachment on requested item table attached or not in every 5 minutes for 40 days from workflow.

Imatiaz
Kilo Contributor

how can I check an attachment on requested item table attached or not in every 5 minutes for 40 days from workflow

Need to run the gliderecord  for checking attachment after every 5 mins for 40 days if attachement is not there on the record for 40 days then cancel the request and RITM from workflow.

 

@Ankur Bawiskar 

13 REPLIES 13

Filipe Cruz
Kilo Sage
Kilo Sage

Hi Imatiaz,

You can create a workflow like this one:

find_real_file.png

In the "If" activity to "Attachment already exists?" do a query to the sys_attachment table to see if there are attachments with table_sys_id equals to the requested item.


If not, go to the "Wait 5 minutes" timer activity. From there, return again to the if statement to validate if there is already an attachment.

If there is an attachment then end up your workflow.

Hope this helps!

Please mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

 

 

Hello lmatiaz,

You can also use flow designer to achieve this! 
Flow designer surpasses the legacy workflows feature. You can get more information in the following community post:

Is your work flowing? What makes Flow Designer and IntegrationHub better and why you should migrate ...

Hope this helps!

Please mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

How can I make it to run for 40 days ?

 

I am able to validate the attachment on the RITM record , but, if attachment is not there then it should check for attachment in every 5 mins for next 40 days until it found any attachment on the RITM, if attachment is not there for more than 40 days on RITM then it should send the reminder email through an event.

 

Hello lmatiaz,

Put a timer connected to the "Begin" activity with a duration of 40 days. After that it will move to the end and the workflow will be completed.

Please mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz