WebInterfaceReport - filter using dynamic date

[rcpet...@gmail.com]

Hi guys,

I've being trying to include a filter in my WebInterfaceReport to get only results with a measure End_Date (defined as Date type in the process) greater than current date.

According to User Guide, that is possible by using [[day_0]] as filter. But I couldn't manage to make it work.

If I put the timestamp of the current date in the filter it works fine, so I believe there is some problem with the way I'm using the dynamic date variable.

Can you guys help me?

Regards,
Rodrigo

[Pankaj Kumar]

Hi,

Please share the web-interface report configuration screen-print and the values in the measure "End_Date " to suggest you more on this,

Thank you,

Pankaj Kumar

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/4979ab66-2bf3-4aa8-b16e-10b6434b0c0b%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[rcpet...@gmail.com]

Hi Pankaj,

please find attached the configuration and also a print of the result without filter, where you can see the measure existing values.

Regards,
Rodrigo

On Wednesday, May 9, 2018 at 2:54:41 PM UTC-3, Pankaj Kumar wrote:
> Hi,
>
>
> Please share the web-interface report configuration screen-print and the values in the measure "End_Date " to suggest you more on this,
>
>
>
>
>
> Thank you,
> Pankaj Kumar
> Fujitsu RunMyProcess Support
>
>
> On Wed, May 9, 2018 at 6:12 PM, <rcpet...@gmail.com> wrote:
> Hi guys,
>
>
>
> I've being trying to include a filter in my WebInterfaceReport to get only results with a measure End_Date (defined as Date type in the process) greater than current date.
>
>
>
> According to User Guide, that is possible by using [[day_0]] as filter. But I couldn't manage to make it work.
>
>
>
> If I put the timestamp of the current date in the filter it works fine, so I believe there is some problem with the way I'm using the dynamic date variable.
>
>
>
> Can you guys help me?
>
>
>
> Regards,
>
> Rodrigo
>
>
>
> --
>
> 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.

[Pankaj Kumar]

Hi Rodrigo,

As discussed in call, I will suggest you workaround on this issue.

Thank you,

Pankaj Kumar

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/9c453a6d-abcc-42f1-bcdd-1cfe3d351a7a%40runmyprocess.com.

[rcpet...@gmail.com]

Hi Pankaj,

thanks for your help.

after you explained to me the problem with the [[day_0]] dynamic date (that doesn't convert to timestamp, but to a date formated as yyyyMMddHHmmss, I could make a workaround.

I basically created a measure of type Number with my date converted to this format:
${get_date(<my_date>?number,"yyyyMMddHHmmss")?number}

this way the filter works fine. But if you have a better solution please let me know.

Thanks again.

Best Regards,
Rodrigo