implementing a filter on Report

[mosa.gh...@gmail.com]

Hello Support,

I have a question is "Can I implement a filter on Web interface Report as below "

Between 31st July 2014 11:59 PM TO 31st Aug 2014 11:59 PM , What I mean is , Can I filter on full date as a above?

Please assist and help.

Best Regards,

Mousa Gharaibeh
Analyst , Business Process Automation
Corporate & Technology Services
Office :  +962 6 5800936
Mobile: +962 796579097          
Email: mousa.g...@sita.aero

[mosa.gh...@gmail.com]

Hello Support ,

Also I have another question , the question is : how can I Define date as a string and with enabling a filter with Between option "FROM 31st July 2014 11:59 PM TO 31st Aug 2014 11:59 PM" for example. is there any option to define date with enabling filter with between option without define date as a string?

[Sweta Suman]

Hi Mosa,

Query 1: Yes, you can implement filter on a web interface or process report using following JavaScript :

These functions can only be used if "Enable filter" of report is not checked.

 

1)   widgetID.addFilter(standardColumnName,operator,primaryValue,secondaryValue): this function sets a filter on a given column         for a standard process or application column.

     e.g    

                   id_report.addFilter("date",RMP_FilterOperator.BETWEEN,'31/07/2014 HH:mm','31/08/2014 HH:mm');

                    id_report.refresh();

2)   widgetID.addMeasureFilter(columnName,operator,primaryValue,secondaryValue): this function sets a filter on a given column         for a measure. Column name for measure is name of measure

      e.g 

                    id_report.addMeasureFilter("my_measure",RMP_FilterOperator.BETWEEN,'31/07/2014 HH:mm','31/08/2014 HH:mm');

                    id_report.refresh();

  

Query 2:  "Enable filter " is pre-defined filter, and if it is checked and you are applying external filter as well then it won't work.

 

If you still have any queries, feel free to ask.

Thanks and Regards,

Sweta

[mosa.gh...@gmail.com]

Hello Sweta,

What I need is to implement a filter by user by click on above filter button and then customer type a period that he needs in between option.

Can user implement like this filter?

[Gareth Thiveux]

Hi Mosa,

In order to have the "In between" filter, your column has to be set as a "Date" column (you can specify a column type where you've defined your measures), and has to contain a timestamp.

Regards,

Gareth THIVEUX

Customer Solutions Engineer

 Fujitsu RunMyProcess

3 rue de Gramont, 75002 Paris - France

website : Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" 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 http://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/f62cef41-adc4-4bb8-b994-19d7a7a5d50b%40runmyprocess.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[mosa.gh...@gmail.com]

Hi Gareth,

I have reached to the maximum definition of measures (20 Measures) in my process , Anyway I will create a new collection report to include a new measure in report .

My Question now : Shall I define a measure as a timestamp ${gettime()} and define them in Web interface report as date column? is this will serve my requirements?

Thank you for your prompt response.

[Gareth Thiveux]

Hi Mousa,

Yes, you can use ${timestamp('SECOND')?number} and then specify that your column is a date column.

Regards,

Gareth THIVEUX

Customer Solutions Engineer

 Fujitsu RunMyProcess

3 rue de Gramont, 75002 Paris - France

website : Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" 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 http://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/9608b07c-c1e2-44bd-a15d-b52dfd7cccc2%40runmyprocess.com.

[mosa.gh...@gmail.com]

Hi Gareth,

Thanks a lot for your prompt response, I have just a quick question : what is the difference between ${get_time()} and ${timestamp('SECOND')?number} ?

I have implemented both of them , and I've got the below result:

${get_time()} = 1409642823
${timestamp('SECOND')?number} = 1409642729

Your prompt response is highly appreciated.

[Gareth Thiveux]

Hi Mosa,

get_time() should be used to convert a string date to its corresponding timestamp : http://docs.runmyprocess.com/API_Reference/FM/Utilities.html#get_time

Regards,

Gareth THIVEUX

Customer Solutions Engineer

 Fujitsu RunMyProcess

3 rue de Gramont, 75002 Paris - France

website : Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" 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 http://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/cfed689a-2899-437a-96a7-fd3bf3d8c523%40runmyprocess.com.

[mosa.gh...@gmail.com]

Hi Gareth,

Sorry for multiple emails , I have another critical question that says how many collection can we create under the same project?

Please advise again.

[Sweta Suman]

Hi.

You can create maximum 10 authorized collections in an account.

Thanks and Regards,

Sweta

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" 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 http://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/b8595b2b-84eb-4140-a6b0-9ead3a759244%40runmyprocess.com.

[mosa.gh...@gmail.com]

Hello Support,

Sorry again for multiple multiple emails :-) , This is final question Can We implement a filter when I define a column as a date with full period Date and Time.As below:

Between 31st July 2014 11:59 PM TO 31st Aug 2014 11:59 PM

[Shobhit Tripathi]

Hi Mosa,

Yes, you can implement. 

Please follow up with the above solutions provided by the Gareth and Sweta.

Thanks & Regards,

Shobhit

[Shobhit Tripathi]

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" 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 http://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/75639489-a65a-4d81-9356-8792fb634632%40runmyprocess.com.