alert when file is not RECEIVED 3RD TIME

[DishaSharma]

i want to run a import workflow between 7am to 10am and set schedular to run 3times a day..

so workflow will run 3 times between this duration

now when file is received i want the workflow to move to file loadign acitity

but in case file is not received between 7am to 10am i wan to send alert but not evEry hour(ASSSUME FILE NOT RECEIVED WHEN RUN FIR THE FIRST TIME)

but only after Wkf run comlpleteD for 3imes a day and file is not received EVEN THENthen i want TO SEND ALERT

please let me know how can we achieve this

@ParthaSarathy

@ParthaSarathy 

@ParthaS 

@AkshayAnand 

@Craig_Thonis 

@Manoj_Kumar_ 

@Amine_Abedour 

@Marcel_Szimonisz

@DavidKangni 

@Amit_Kumar 

@ShashankNigam02

@Ganesh5067

@Jonathon_wodnicki

[_Manoj_Kumar_]

Hello @DishaSharma 

If you know the timing of the 3rd run then use this:

You will have to use JavaScript to achieve this.

After the scheduler activity add JavaScript code activity and write this code.

instance.vars.myRunHour=formatDate(new Date(), "%2H");

This will give you the hour when the 3rd run is happening.

Then add a test activity in your workflow to check if the the variable hour is matching with the timing of 3rd run. If yes then it is the third run and send the alert.

If you are not sure the timings of the workflow run

You can use the JavaScript  to update value of an option. You can increase the value of this option every time the WF is run.

On every run check if the value of that option is 3 and file status.

// set Option
setOption('WFrunCounter',0);


//get Option
getOption('WFrunCounter');

[jefrii]

@_Manoj_Kumar_ 

thank you for your help but m facing one challenge here

If you are not sure the timings of the workflow run

You can use the JavaScript  to update value of an option. You can increase the value of this option every time the WF is run.

On every run check if the value of that option is 3 and file status.

what i am doing is:

this m doing before file transfer activity:

Option
setOption('WFrunCounter',0);

 now after file tranafer acitity when no file received m incrementing counter

but when file not received for for first time and then m incmrenting counter

but later on when wkf run fir 2nd time it is stgarting from 0

please please help to provide how can I set these counters AND USE IT WHN FILE NOT RECEIEVD FOR 3RD TIME

RELLAY CONfused and not able to achieve results please help

[Shruti1]

@_Manoj_Kumar_ 

plrase reply

plrase help m stuck

[_Manoj_Kumar_]

Hello @Shruti1 

Do not set the WFrunCounter to 0 at the start of the workflow.

Set it to zero if the file ingestion is complete

[DishaSharma]

@Manoj_Kumar_ 

thank you for your help but m facing one challenge here

If you are not sure the timings of the workflow run

You can use the JavaScript  to update value of an option. You can increase the value of this option every time the WF is run.

On every run check if the value of that option is 3 and file status.

what i am doing is:

this m doing before file transfer activity:

Option
setOption('WFrunCounter',0);

 now after file tranafer acitity when no file received m incrementing counter

but when file not received for for first time and then m incmrenting counter

but later on when wkf run fir 2nd time it is stgarting from 0

please please help to provide how can I set these counters AND USE IT WHN FILE NOT RECEIEVD FOR 3RD TIME

RELLAY CONfused and not able to achieve results please help

[ParthaSarathy · Accepted solution]

Hi @DishaSharma ,

You can try the same approach mentioned in this thread and modify the query condition as below,

File Transfer:

In File transfer activity's Advanced tab, add the below script

vars.hour = formatDate(new Date(), "%2H");

Query:

Targeting & Filtering Dimension: xtk:workflow

Filtering Condition:

(Highlighted in BOLD fonts are newly added/modified condition compared to the reference thread's query condition)

$(vars/@hour)   equal to 10

AND

@internalName equal to internal_name_of_current_workflow

AND

Message (log)   do not exist such as

        @message                 equal to    File Processed

         AND

        ToDate(@logDate)     equal to  ToDate( GetDate())