Please give details of the problem



    Developer Guide

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

    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.


    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.


    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.

    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.

    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.
    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 )
    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.