×

Please give details of the problem

Docs

Find

    Developer Guide

      1. Todo Validation
    1. Release Your User Login
    1. Markdown Template
      1. Backloop
      2. JavaScript Inclusion
      3. Task Reminder Email
      4. Variable Mapping
      5. SubProcess
      6. PDF
    2. Trigger
      1. Lock
      2. Dynamic Variable
      3. List 1000+ Objects
      4. JSONObject Creation
      5. JSONArray Conversion
      6. Number Currency Format
      7. Error Handling
      8. JSONObject Concatenation
      9. Freemarker Container Test
      10. Number Test
      11. Loop
      12. File Visibility
      13. List Hash Sequence
      14. Special Freemarker Characters
      15. Array To List
      16. Salesforce Computation
      17. Metadata
      18. JSONObject Keys Values
    1. Delegation
    2. Access Rights
    3. Dynamic Lanes
    4. Runtime Lanes
    5. Scripted Lanes
    6. Compound Organization Hierarchy
      1. Array From WS
      2. Column Inactivation
      3. Holidays
      4. List Reinitialization
      5. ArrayJSON to JSONArray
      6. Print JSONObject
      7. Invalid Fields
      8. Number Currency Format
      9. Google Tables
      10. Initialization Widget Date
      11. Date
      12. JQuery
      13. Round
      14. Inject JSONObject
      15. Label Modification
      16. Launch Process JQuery
      1. CSS Personalization
      2. CSS Examples
      1. Tags
      2. Retrieving Variables Values
      3. Dialog Window
      4. Autocomplete Widget
      5. JavaScript Report
      6. User Lane Picker
        1. Chart Dashboard Collection
        2. Chart Dashboard
        3. Report Chart
        4. Google Visualization
      7. Collection
      8. Dynamic List
      9. Summing Array
      10. API Listener
      11. File Preview
    1. Performance
      1. Custom Login Page
      2. Redirection ExecutionMode
      3. Mobile Devices
        1. homepage.js
        2. homepage.css
      4. Logout
      5. Header
      6. Menu Bar
      7. Information Tags
      8. Basket
    1. Mobile
    2. Offline
        1. Collections
          1. Process General Tab
            1. Process Step Output Variables
              1. Process Task Email Tab
              2. Process Task SubProcess Tab
              3. Process Task Functional Tab
              4. Process Task Connector Tab
              5. Process Task Manual Tab
              6. Process Task Loop Tab
              7. Process Task Script Tab
            2. Process Step Input Variables
            3. Gate
            4. Process Step Testing Variables
              1. Process Intermediary Event
              2. Process Timer Event
              3. Process Start Event
          2. Process Variables Tab
          3. Process Measures Tab
          4. Process Design
          5. Process Input Tab
          1. Organization
          2. Roles entities
          1. Project Collection Tab
          2. Project Definition Tab
          3. Version
          4. Project Versioned Files Tab
          5. Project Files Tab
          6. Project Description Tab
          7. Project Version Tab
          8. Project Rights Tab
          1. Connectors
          2. Providers
          3. Processes
          1. Composite API Configuration Tab
          2. Composite API Design Tab
        2. Custom Lists
        3. Revision
            1. Image Widget
            2. Spinner Widget
            3. FileUpload Widget
            4. Section Widget
            5. Multi Checkbox Widget
            6. URLInput Widget
            7. RadioButton Widget
            8. Array Widget
            9. Captcha Widget
            10. Checkbox Widget
            11. Report Widget
            12. Geolocation Widget
            13. Button Widget
            14. Custom Widget
            15. TextInput Widget
            16. Tree Widget
            17. List Widget
            18. StaticText Widget
            19. HTML Editor Widget
            20. JavaScript Widget
            21. Tab Widget
            22. HTML Widget
            23. ProgressBar Widget
            24. History Widget
          1. Web Interface Stylesheet Tab
          2. Web Interface Design Tab
          3. Web Interface Analytics Tab
          4. Web Interface Collection Tab
          5. Web Interface API Tab
          6. Web Interface Implementation Tab
          7. Web Interface JS Tab
        1. Scheduled Process
        2. Messages
        1. Configuration
        2. Users
        3. Usage
        1. Connectors
        2. Process Examples
      1. Customer Management
          1. Measuring
          2. Parameters
          3. Execution Path
          4. Runtime Users
        1. Web Interface Reports
        1. Files
        2. Home
        3. My Applications
      1. Collections To Array
      2. Collections BackOffice
      3. Collection JS Freemarker
      4. Collections To List
      1. Composite API Example
      1. Process Reporting API

    Report Widget

    1. Overview

    This widget allows you to present either a web interface report, a process report, a collection or a custom source of data (JavaScript report) to the end user on a web interface.

    application_report

    2. Configuring a Report

    There are three tabs for configuring the report - Properties, Layout and Rules.

    2.1 Properties

    The first thing you must decide is the type of report you wish to display - collection, web interface report, process report or a JavaScript report. It is defaulted to collection but you can change this by choosing the Other Report option.

    ReportType

    You can choose to either use an existing report that is already defined in your web interface project or to create a new one (not possible for JavaScript reports). Choosing to create a new report will enable you to design and save a new report before returning to configure the widget.

    picto_wrench: click on this icon, to configure the columns displayed in the report. You can define the width (in pixels) of each column, set a column as visible or not and add a calculated column. To define the content of a calculated column, enter your javascript : ${P_user.name} "[[mycolumname]]" and "[[propertyname]]" and "[[MEASURE_1]]" at index "[[_row_]]" or if("[[myvar]]"=="0"){"bad";}else{"good";}.

    info_3 You can't filter on a calculated column and calculated column won't be exported.

    info_4 You can use "P_index" to get the index of the current row.

    Most of the properties that can be configured from the Properties tab are common to all types of reports but some are specific to the type of report you are configuring.

    2.1.1 Collection Properties

    The following properties are specific to collection reports:

    Property Description
    Collection URL The URL for the collection
    Query Enter a query to be run on your collection. If empty, all records will be displayed. The query is a pattern : {"lastname":"Smith"} or {"$and":[{"field1":"value1"}, {"field2":value2}]}. The Query can also contain a more advanced pattern (display all records that match a given pattern, order by a given key : {"$query":{"field":value},"$orderby":{ "field":1}}.
    Aggregate This allows you to perform an aggregation query on your collection. For example, {"$group":{"_id":{"service":"$uo"}}},{"$project":{"service":"$_id.service","_id":0}} will display unique "service" of your collection.
    Post loaded script This allows you to execute a script when the report is completely loaded in the web page. For example, you could set a javascript filter on your report. For more information, please refer to the JavaScript report tutorial. An example is id_report.addMeasureFilter("mymeasure",RMP_FilterOperator.EQUAL,"myvalue");id_report.refresh(); Please note that the post loaded script of a report used in a web interface created after the Lifou v3 release is executed each time the report's data is refreshed (after a reset filter, manual or dynamic refresh etc )

    Learn more about collections here.

    2.1.2 Process and Web Interface Report Properties

    The following properties are specific to process and web interface reports:

    Property Description
    Name column name This property allows you to change the title of the first column of your report. This is available for process and web interface reports.
    Post loaded script This allows you to execute a script when the report is completely loaded in the web page. For example, you could set a javascript filter on your report. For more information, please refer to the JavaScript report tutorial. An example is id_report.addMeasureFilter("mymeasure",RMP_FilterOperator.EQUAL,"myvalue");id_report.refresh(); Please note that the post loaded script of a report used in a web interface created after the Lifou v3 release is executed each time the report's data is refreshed (after a reset filter, manual or dynamic refresh etc )

    2.1.3 JavaScript Report Properties

    The following properties are specific to JavaScript reports:

    Property Description
    Loading data script This allows you to define a script that will enable the display of data from any source as long as they are formatted as a JSONArray.
    Export by email If you want to export all of the data you will need to create a process to do this for you (or you may already have one). Once you have this process configured, you can attach it to your JavaScript report here.

    For more information, visit the JavaScript Report page.

    2.1.4 Shared Report Properties

    The following properties are common to each type of report - collection, process, web interface and JavaScript.

    Property Description
    Open links in the same window Choose this if you want users to remain in the same window (or iframe) when they click on a link (instead of opening a new tab with manual task web page).
    Enable filters Choose this if you want to allow user to filter your report. This field must not be checked if you are using Javascript to filter your report.
    Show filter at start Check this box if you want to open the filter section when opening the web interface.
    Sortable Check this box if you want to allow the users to sort on a column of your report.
    Visible items The maximum number of lines displayed on a screen report (it is linked to the Table height).
    Table height The height in pixels of your report.
    Allow users to select rows You can choose to allow users to select "Only One" or "All" rows from the report. When the user makes a selection the JavaScript declared in the "On row select / deselect" field will run. Choosing "None" here will disable this functionality.
    On row select / deselect This option is enabled only if you have chosen to allow users to select rows (one or all). Enter the JavaScript that will be triggered when a user selects or deselects a row from the report or when running dedicated JavaScript functions (refresh, selectAll...). JavaScript function getLatestSelectedLineValues() will return the values of the selected line or null if the lastest action was the deselection of a line.
    Date format Allows you to customize the date format used to display the date fields in your report and when exporting the data. The format must follow the ISO 8601 format.
    Listen to variables Populate this field with a variable name that should be listened to.
    Identifier The id of the widget. This is only needed if you intend to use Javascript functions in your web page.

    info_7 Please note that if a widget report is "Active" (cf. Rules tab), the end users will be able to modify the configuration of the report directly from their web interface without using the RunMyProcess back office interface.

    2.2 Layout

    The Layout tab enables you to tailor the look of your report.

    2.3 Rules

    The rules tab enables you to set rules for the availability of the report widget.

    3. Filtering on Process Status

    When presented with a process report on a Web Interface, the user can choose to filter on process status (if enable filtering has been set on the report widget properties). Here is the list of the status available for filtering by:

    Status ID Server Description Web Interface Label Description
    0 NONE Initialized The process is in a queue for processing but has not started yet.
    100 READY Processing Process step is being processed (Temporary status).
    102 WAITING Waiting The process is waiting for en external action to restart (e.g. a Manual Task)
    103 WAITING RESUME Waiting (Resume) The process is in waiting resume state.
    201 COMPLETED Completed The process has completed.
    301 ABORDED Aborted The process has been aborted.
    302 KILLED Killed The process has been killed.
    400 CANCELLED Cancelled The process was cancelled by a user.
    401 OUTDATED Outdated The Process has ended because it has timed out.

    All status are included as default.