Filter Code implementation

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

Hello Support,

Yesterday , I created a report with date columns and I implemented a filter on it , but it was not working. anyway I escalated it to RMP Support and They told me that the RMP platform had a bug on filter option, They helped me and deployed a code as workaround in my Web Interface as below , but it's not working now

var date_1 = parseInt(RMPApplication.get("date_1"));
var date_2 = parseInt(RMPApplication.get("date_2"));
var query_as_a_string = '{"$and":[{"CreationDate":{"$gte":'+date_1+'}},{"CreationDate":{"$lte":'+date_2+'}}]}'
id_report.setQuery(query_as_a_string);
id_report.refresh();

Would You Please Help Me


Best Regards,

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

[Richard Manga]

Good Afternoon Mousa,

This is the rigth syntax:

var query_as_a_string ={};

var date_1=RMPApplication.get("date_1");

var date_2 =RMPApplication.get("date_2");

var query_as_a_string={"$and":[{"CreationDate":{"$gte":date_1}},{"CreationDate":{"$lte":date_2}}]};

id_report.setQuery(query_as_a_string);
id_report.refresh();

Regards,

Richard

--
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/573c0666-0f18-4aeb-94ec-6068e9c36a00%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

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

Good Afternoon Richard,

I have implemented your script , and also with no luck.

[Richard Manga]

Good afternoon Mousa,

"date_1" and "date_2" are RMP date fields or they are strings?

If they are strings ("10/12/2014" for exemple) you should transform them in Timestamp for the query.

Regards,

Richard

--
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/78847114-40db-4639-b151-5c7443431614%40runmyprocess.com.

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

Good Afternoon ,

I defined them as a Date input widgets.

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

Hello Richard,

I already defined them as a date widget .

[Richard Manga]

Good afternoon Mousa,

Please can you give me the following info in private message: account email + project name + interface + report you are filtering?

I would like to make some tests.

Regards,

Richard

--
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/8f1d8d1e-a30b-49a0-b0ef-f7b75e9b452a%40runmyprocess.com.

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

Good Afternoon Richard,

Done, Already sent Please check your private email

[mosa gharaibeh]

Hello Richard,

Please Let me know if you have any update?

Best Regards,

Mousa Gharaibeh

Analyst , Business Process Automation

Corporate & Technology Services

Office :  +962 6 5800936

Mobile: +962 796579097          

Email: mousa.g...@sita.aero

--

 

 

 

 

Regrads,

Mousa Gharaibeh

[Richard Manga]

Hello Mousa:

This is the right query:

var query_as_a_string ={};

var date_1=RMPApplication.get("date_1");

var date_2 =RMPApplication.get("date_2");

var query_as_a_string={"$and":[{"CreationDate":{"$gte":date_1}},{"CreationDate":{"$lte":date_2}}]};

id_report.setQuery(JSON.stringify(query_as_a_string));

id_report.refresh();

I check it in you interface, and it works.

If you have any question, please contact me.

regards,

Richard

--

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/CAL-%3Dn-zdkTphd0JzF%2B7umzkpX6X29u5tmPjjoBL%3D%2BtHFE-FtaQ%40mail.gmail.com.

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

Thanks a lot , it's working fine

[mosa gharaibeh]

Hello Support ,

I have received an email from your newsletter that says that you have released a new version with date filter correction , but I have tested it from your side and it's still not working properly.

Best Regards,

Mousa Gharaibeh

Analyst , Business Process Automation

Corporate & Technology Services

Office :  +962 6 5800936

Mobile: +962 796579097          

Email: mousa.g...@sita.aero

On Thu, Oct 16, 2014 at 8:44 AM, <mosa.gh...@gmail.com> wrote:

Thanks a lot , it's working fine

--

 

 

 

 

Regrads,

Mousa Gharaibeh

[Jeremy Le Pré]

Hello,

We're pleased to hear you succeeded in your tests.

I received the following informations about this subject:

Dev team added a Process Id filter on Interface reports and corrected abug on the Current Year filter.
Date filters are supposed to work well. But sometimes, it happens that people forget to select an operator like 'less than' or 'greater than', without it it can't work.

Regards,

______________________________________
Jérémy LE PRÉ

PreSales Engineer at RunMyProcess
Website: Fujitsu RunMyProcess

[mosa gharaibeh]

I have tested between and it's still not working , you can test on my project that already sent to you in previous email.

Please let the team test again , and let me know the progress.

Awaiting for your response.

Best Regards,

Mousa Gharaibeh

Analyst , Business Process Automation

Corporate & Technology Services

Office :  +962 6 5800936

Mobile: +962 796579097          

Email: mousa.g...@sita.aero

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/B4EEiOeAxXI/unsubscribe.
To unsubscribe from this group and all its topics, 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/CADmZqc-QFoGA9525DJ3RJuhGuY_f_jPkVdZ5njUAmyca8foGPw%40mail.gmail.com.

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

--

 

 

 

 

Regrads,

Mousa Gharaibeh

[Richard Manga]

Good Morning Mousa,

Please can you tell me exactly doesn't work?

My script was tested in your interface, and it worked. Are you talking about the default filters in the report date column?

Regards,

Richard

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/CAL-%3Dn-x_ZBykj3k4N_XDVqng7_rLphY3sMD_dw1_s0nw6w0dcA%40mail.gmail.com.

[mosa gharaibeh]

Exactly

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAJ6Gss9_e_1d%2B36_RQb8m9sMQ8Gx%3DL863yVv2G%3DRJRHW8XUKaA%40mail.gmail.com.

[Richard Manga]

Hi Mousa,

Please, can you tell me if you are using collection/process/web interface report?

If it's collection report, how do you insert data inside youir collection?

Regards,

Richard

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAL-%3Dn-xWN%2BprqMMKmHY2BLZyaezuPf7HVoqCLvdS71gdFX0b%3DA%40mail.gmail.com.

[mosa gharaibeh]

Hi Richard,

it's a collection and I defined the date as recommended from RMP support ${timestamp('SECOND')?number}

Then defined it in report as date.

Best Regards,

Mousa Gharaibeh

Analyst , Business Process Automation

Corporate & Technology Services

Office :  +962 6 5800936

Mobile: +962 796579097          

Email: mousa.g...@sita.aero

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAJ6Gss9Bg81fCHb9WrtRjCHTOSTNzhi80%3D%3DWzoRvUgic6MHcFQ%40mail.gmail.com.

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

--

 

 

 

 

Regrads,

Mousa Gharaibeh

[mosa gharaibeh]

Any Update?

--

 

 

 

 

Regrads,

Mousa Gharaibeh