Webreports and distinct value

[stor...@gmail.com]

Hi there!

Is it possible possible to filter web or process reports by distinct values?

That is, being able to set a specific column to only contain unique values?

I am building a resource handling system and I would like to have a report which shows where all the resources are currently. So I am only interested in the latest proccess of any given resource, as older would be finalized anyway.

Regards
Svensson, Peter

[Vitthal Jivrag]

Hi Peter,

The Add Filter button allows you to include only web interfaces that meet a specific criteria in your report. You can have more than one filter, the logical operation between each filter is an AND.

If a web interface has been selected, you can also filter by any measures defined in the process launched by the selected web interface.

For a guide how can you do this you can go through given article on our help center.

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

Thanks & Regards,

Vitthal Jivrag

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/c5ad6f19-be0a-4777-bc7e-bc29be3abb9a%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[stor...@gmail.com]

Hi there.

I am aware of this feature, but I don't know how to use it for my needs.

How can I make a filter where a resource is only presented once, despite existing in several forms?

Regards
Svensson, Peter

[Pankaj Kumar]

Hi Peter,

RunMyProcess do not offer any direct feature to  set a specific column to only contain unique values.

However you may implement it by implementing an java-script report, please find reference link as below:-

https://docs.runmyprocess.com/Developer_Guide/Web_Interface/Design/JavaScript_Report

Another workaround (on 100 records of the data) can be, you can design web-interface report fetching 100 record, and using the post-loaded script, you can loop 100 record and remove the unnecessary record (same measure value)  and using "setData" method of the report, display the filter record.,

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...@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/c6a0ff7c-04fb-4ff8-af8f-c8ea62a37aa5%40runmyprocess.com.

[stor...@gmail.com]

Hi there.

That's a shame, I had hopes that the database would do it for me. It'd likely be quicker.

But javascript will work as a solution. Thank you for the assistance :)

Regards
Svensson, Peter