Is it possible to filter screen column in webinterface report

130 views
Skip to first unread message

bestfri...@gmail.com

unread,
Oct 15, 2013, 11:22:50 PM10/15/13
to suppor...@runmyprocess.com
Hi,

I am trying apply filter on screen column of the webinterface but the script or customizing the default columns are not getting visible for the webinterface report.


RMP.PNG

Gareth Thiveux

unread,
Oct 16, 2013, 3:57:39 AM10/16/13
to suppor...@runmyprocess.com
Hi,

These are the functions you'll need to be able to filter on report column :

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

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

widgetID.addRowStyle(rowId, className) :: this function sets a class name on a given row identified by its identifier

widgetID.clearFilter(standardColumnName): this function clears a filter on a given standard column.

widgetID.clearMeasureFilter(columnName): this function clears a filter on a given measure. Column name for measure is name of measure

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

An operator can be : RMP_FilterOperator.EQUAL, RMP_FilterOperator.NOT_EQUAL, RMP_FilterOperator.LESS_THAN, RMP_FilterOperator.GREATER_THAN, RMP_FilterOperator.LESS_THAN_EQUAL, RMP_FilterOperator.GREATER_THAN_EQUAL, RMP_FilterOperator.BETWEEN, RMP_FilterOperator.CONTAINS, RMP_FilterOperator.IN, RMP_FilterOperator.NOT_IN

A standardColumnName can be for application : RMP_AppliReport.NAME, RMP_AppliReport.PUBLISHED, RMP_AppliReport.STATE (id of screen starting on 0), RMP_AppliReport.AGE, RMP_AppliReport.ONHOLD, RMP_AppliReport.OWNER, RMP_AppliReport.CONTRIBUTOR

A standardColumnName can be for process : RMP_ProcessReport.NAME, RMP_ProcessReport.DURATION, RMP_ProcessReport.DELAY, RMP_ProcessReport.YEAR, RMP_ProcessReport.MONTH, RMP_ProcessReport.DAY, RMP_ProcessReport.ID, RMP_ProcessReport.PARENT, RMP_ProcessReport.PUBLISHED, RMP_ProcessReport.UPDATED, RMP_ProcessReport.STATUS, RMP_ProcessReport.EVENTS, RMP_ProcessReport.OWNER, RMP_ProcessReport.CONTRIBUTOR

Example : id_report.addMeasureFilter("mymeasure",RMP_FilterOperator.EQUAL,"myvalue");id_report.refresh();



Regards,

Pre-Sales Consultant / Consultant Avant-Vente
 Fujitsu RunMyProcess
22 rue Chauchat, 75009 Paris - France (GMT+1)

     


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.


Hi,

I am trying apply filter on screen column of the webinterface but the script or customizing the default columns are not getting visible for the webinterface report.


--
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/6ed43c6a-7f0b-4bcc-b16c-2b7127cf2984%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

bestfri...@gmail.com

unread,
Oct 16, 2013, 10:29:26 AM10/16/13
to suppor...@runmyprocess.com
Hi Gareth,

We tried above by adding addFilter but it didnot work out

I have added js widget and added the addFilter option but there is no change in the report

PLease find the attachment for reference


On Wednesday, October 16, 2013 3:57:39 AM UTC-4, Gareth Thiveux wrote:
> Hi,
>
>
> These are the functions you'll need to be able to filter on report column :
>
>
>
>
>
> widgetID.addFilter(standardColumnName,operator,primaryValue,secondaryValue): this function sets a filter on a given column for a standard process or application column.
>
>
> 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
>
>
> widgetID.addRowStyle(rowId, className) :: this function sets a class name on a given row identified by its identifier
>
>
> widgetID.clearFilter(standardColumnName): this function clears a filter on a given standard column.
>
>
> widgetID.clearMeasureFilter(columnName): this function clears a filter on a given measure. Column name for measure is name of measure
>
> These functions can only be used if "Enable filter" of report is not checked.
>
>
> An operator can be : RMP_FilterOperator.EQUAL, RMP_FilterOperator.NOT_EQUAL, RMP_FilterOperator.LESS_THAN, RMP_FilterOperator.GREATER_THAN, RMP_FilterOperator.LESS_THAN_EQUAL, RMP_FilterOperator.GREATER_THAN_EQUAL, RMP_FilterOperator.BETWEEN, RMP_FilterOperator.CONTAINS, RMP_FilterOperator.IN, RMP_FilterOperator.NOT_IN
>
>
> A standardColumnName can be for application : RMP_AppliReport.NAME, RMP_AppliReport.PUBLISHED, RMP_AppliReport.STATE (id of screen starting on 0), RMP_AppliReport.AGE, RMP_AppliReport.ONHOLD, RMP_AppliReport.OWNER, RMP_AppliReport.CONTRIBUTOR
>
>
> A standardColumnName can be for process : RMP_ProcessReport.NAME, RMP_ProcessReport.DURATION, RMP_ProcessReport.DELAY, RMP_ProcessReport.YEAR, RMP_ProcessReport.MONTH, RMP_ProcessReport.DAY, RMP_ProcessReport.ID, RMP_ProcessReport.PARENT, RMP_ProcessReport.PUBLISHED, RMP_ProcessReport.UPDATED, RMP_ProcessReport.STATUS, RMP_ProcessReport.EVENTS, RMP_ProcessReport.OWNER, RMP_ProcessReport.CONTRIBUTOR
>
>
> Example : id_report.addMeasureFilter("mymeasure",RMP_FilterOperator.EQUAL,"myvalue");id_report.refresh();
>
>
>
>
>
>
> Regards,
>
>
>
>
> Gareth THIVEUX
>
>
>
> Pre-Sales Consultant / Consultant Avant-Vente
>
>
>  Fujitsu RunMyProcess
>
>
> 22 rue Chauchat, 75009 Paris - France (GMT+1)
>
>
> website : Fujitsu RunMyProcess
>
>
>
>
>
>
>      
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
rmpCapture.PNG

Sabine El Rassy

unread,
Oct 16, 2013, 11:07:13 AM10/16/13
to RunMyProcess Support Forum
Hello Nagasai,

Try this:

id_report.addMeasureFilter("pcn",RMP_FilterOperator.EQUAL,"7");
id_report.refresh();


Regards,

Sabine
Reply all
Reply to author
Forward
0 new messages