Example query for Charts widget

  1. Create a query for CHARTS and select the Visible in API check box.
  2. Add the code below to the Query Text. Click Save. 
    SELECT PROJECT_CODE, DESCRIPTION, PROJECTMGR, PROJ_CUSTOMER, TARGET_UNIT_PRICE, TARGET_UNIT_COST, PLANNED_COST, ACTUAL_COST, BUDGETED_COST FROM FSPROJECT WHERE PLANNED_COST > 0 AND TARGET_UNIT_PRICE > 5
    query_charts_multilang
  3. Open the Lookup Set form.
  4. Create a Lookup Set for WIDGETLOOKUP.
  5. Add a row in the Lookup tab and specify this information:
    Lookup Code
    CHARTLANG
    Description
    Specify any description. Example: Chart based on Language
    Auto Start
    Yes
    Query Code
    CHARTS
    lookup_set_charts
  6. Add column labels below in Lookup Language tab.
    Language Code Column Labels
    English 
    Project Code;Description;Project Manager;Project Customer;Target Unit Price;Target Unit Cost;Planned Cost;Actual Cost;Budgeted Cost
    French 
    Code de projet;Description;Gestionnaire de projet;Client du projet;Prix unitaire cible;Coût unitaire cible;Coût prévu;Coût réel;Coût budgété
    lookup_lang_tab_charts
  7. Add the information below to the Lookup Set tab:
    Lookup Code
    CHARTLANG
    Set Code
    WIDGETLOOKUP
    Format
    A
    lookup_set_tab_charts
  8. Click Save.
  9. Go to the Homepage. A separate Home Page for French must be configured and published to the Infor OS Pages Catalog for customers to define Language specific pages. The chart widget text is not translated automatically on the English Home Page, but the browser language is applied to other forms and available translations will be displayed. Add the PLM Process Charts widget.
  10. In the PLM Process Charts widget, click Configure and provide the details below:
    Title
    Graphiques PLM Process
    Database
    Widgets
    Query Code
    WIDGETLOOKUP\CHARTLANG
    Label Column
    Code de projet
    Value Column
    Prix unitaire cible;Coût unitaire cible
    configure_charts_widget_french
  11. Select any chart type and click Save.
  12. Now, the Charts widget displays the data.
    charts_french