"On hold for" not working properly in report

[panci...@gmail.com]

Hello,
I have created a web interface report and I added the column "on hold for".
Now I am checking the report and I see that the field "on hold for" holds wrong values, for some tasks. For instance there is a process that has been completed the same day that it was launched and shows 9 in the "on hold for" column.
I don't understand the reason of this bizarre behaviour.
Thanks,
Daniela

[Prachi Chandak]

Hi Daniela,

Please let me know what type of values you are expecting in "on hold for" column and from where you are setting these values.

Also share the screen shot if possible.

If you have any other query feel free to ask.

Thanks & Regards,

Prachi Chandak

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/e619af41-d22f-41ed-bc2a-b90155c77da3%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[panci...@gmail.com]

Hello,
I'm referring to the default "on hold for" column offered by runmyprocess, as described at the following link (The number of days since the Web Interface has been waiting for a manual task validation (process is waiting for a manual task to be performed))

http://docs.runmyprocess.com/Developer_Guide/Development_Environment/Reports/Web_Interface_Reports

I attach an example: the screenshot shows the history of a task that is marked as COMPLETED. This process has been opened and closed on May, 17. And still, the 'on hold for', shows 9.

On Friday, May 26, 2017 at 6:16:58 PM UTC+2, pchandak wrote:
> Hi Daniela,
>
>
> Please let me know what type of values you are expecting in "on hold for" column and from where you are setting these values.
> Also share the screen shot if possible.
> If you have any other query feel free to ask.
>
>
>
>
> Thanks & Regards,
> Prachi Chandak
> Fujitsu RunMyProcess Support
>
>
> On Fri, May 26, 2017 at 9:10 PM, <panci...@gmail.com> wrote:
> Hello,
>
> I have created a web interface report and I added the column "on hold for".
>
> Now I am checking the report and I see that the field "on hold for" holds wrong values, for some tasks. For instance there is a process that has been completed the same day that it was launched and shows 9 in the "on hold for" column.
>
> I don't understand the reason of this bizarre behaviour.
>
> Thanks,
>
> Daniela
>
>
>
> --
>
> Fujitsu - RunMyProcess
>
> ---
>
> You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
>

> To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.

[daniela...@gmail.com]

Moreover, I noticed another problem: if there is a timer, when the timer end, the "on hold for" value resets!
Now, I would like to compute this value myself, using a measure that holds the time of the last action. But, I can't compute inside a measure the subraction between the current moment and the time of the last action.
I managed to do a similar thing inside an output variable, BUT for this purpose I need to do it directly inside a measure.
How can I do that?

[Dipen Raval]

Hi Daniela,

In the web interface report, "on hold for" column consists all instances like completed, pending and cancelled requests.

If you want only pending requests,then  check only "start" status check box.(Please refer the screenshot)By default all three status check boxes are checked, you have to uncheck the status "End" and "Cancel" check boxes.



Thanks & Regards,
Dipen Raval
Fujitsu RunMyProcess Support

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/54430085-0e67-47c8-b580-4f214bf8a152%40runmyprocess.com.

[panci...@gmail.com]

Hello Raval,
thank you for your answer, but it's not what I asked.

By definition, the on hold column should display the number of days since the Web Interface has been waiting for a manual task validation.

That is not what happens. For instance, imagine that I have a manual task that has a timer, which every 2 days does a loop and resends the task. Let's say that I start the process today. Tomorrow the on hold column will display 1. When 2 days passes and the timer expires, the on hold column will display 0, because the on hold value resets when the timer expires. That is not correct.

So, now that we have understood that the on hold value has some kind of problem and so I can't use it, I would like to create a measure with which I can compute a 'on hold'-like measure, on my own. I have a measure that holds the date of the last performed manual task. How can I compute the days between 'today' and the date of the last manual task, inside a measure?

Thank you.
Daniela

[Abhilash Sambhare]

Hi Daniela,

Apology for delay in response.

Yes.You can compute the days between 'today' and the date of the last manual task, inside a measure.You need to take one measure into the process.For eg : date(Please find the attached screenshot-measure_date.png)

Then put the following code inside the measure

 

Code Snippet:

<#assign a1=get_time(now("yyyy-MM-dd"))>  // Current Date

<#assign a2=get_time("2017-06-08")>      //Date from the manual task      

<#assign a3=((a2-a1)/(60*60*24))?number>  //Difference between the two dates.

${a3}

Then add the measure into the process report(Please find the attached screenshot-date_report.png).

Hope this helps you.Please let us know if you any further query.

Thanks & Regards,

Abhilash Sambhare

Fujitsu RunMyProcess Support

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/12a10529-6013-43a0-a4d1-ff31b4f2ec93%40runmyprocess.com.

[panci...@gmail.com]

Hello Abhilash Sambhare,
I have to thank you a lot, this was exactly what I needed. I am not skilled in the freemarker language so I tried js, but I didn't manage to make it work. With your help I'm getting the result I need.

I used a date variable, called last_sent_date that I compute as a output variable every time that a manual task is validated.
So I used:

<#assign last_sent = last_sent_date?number> //Date from the manual task

And it seems to work fine.
So again, thank you a lot.
Daniela

[Abhilash Sambhare]

Hi Daniela,

Glad to know it works!

Thanks & Regards,

Abhilash Sambhare

Fujitsu RunMyProcess Support

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/5e08d5b2-7ac0-411c-bfeb-2b8f1e588cfd%40runmyprocess.com.

[panci...@gmail.com]

Hello Abhilash,
unfortunately it's me again on this problem.
The solution seemed to work, but when I checked the day following day, I noticed it wasn't working well.
Doing some tests I noticed that the value is computed the first time, when the measure is saved, but then if I refresh the report the day after, the value doesn't change and so the calculation is not correct.


Here is the code:

<#assign status = status1>
<#if status == "archive">
-
<#else>
<#assign last_sent = last_mod?number>
<#assign now=get_time(now("yyyy-MM-dd"))>
<#assign a3=(((now+43200)-last_sent)/(60*60*24))?number>
${a3}
</#if>

I did some test making the code print the current timestamp. The first time I open the report the current timestamp is correctly displayed, but then if I refresh the page after 1 minute, the timestamp is still the same than 1 minute ago.

Any thoughts why this happens?
Thank you.
Daniela

[Abhilash Sambhare]

Hi Daniela,

Good Day.

We are working on your issue.Will let you know soon.

Don't hesitate to contact us for any further query.

Thanks & Regards,

Abhilash Sambhare

Fujitsu RunMyProcess Support

To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/95fac705-b055-487a-899b-7298f1ca89f6%40runmyprocess.com.

[panci...@gmail.com]

Thanks.
In the meantime I tried another solution that I recently find on this forum.
I computed the number of days directly inside a new column in the report, containing this script:

if("[[MEASURE_34]]"=="Archive")
{ "-";}
else {
current_time = new Date();
current_time.setHours(14,00,00,00);
((current_time.getTime())/1000-[[MEASURE_38]])/(60*60*24);
}

where MEASURE_38 is the time when the last manual task has been performed.

According to the tests I have done this seems to work: the Current time updates everytime I refresh the report.
So I will implement this solution inside the report and let you know if any problems arises for this new solution.