Example query for multi-language

  1. Create a query for QUERYWIDGET and select the Visible in API check box.
  2. Add the code below to the Query Text. Click Save. 
    SELECT FORMULA_CODE, VERSION, DESCRIPTION, STATUS_IND, MODIFY_DATE, FORMULA_CODE + '\'+ VERSION AS DR_FORMULA_FORMULA_CODE,
CASE STATUS_IND
WHEN '0' THEN '#CFF5F5'
WHEN '100' THEN '#F4B8C4'
WHEN '401' THEN 'PALEGREEN'
WHEN '999' THEN 'BURLYWOOD'
END AS F_BG_STATUS_IND,
CASE STATUS_IND
WHEN '0' THEN 'MINOR_DELAY'
WHEN '100' THEN 'ON_TIME'
WHEN '401' THEN 'MAJOR_DELAY'
WHEN '999' THEN 'MAJOR_DELAY'
END AS F_STATUS_ICON_FORMULA_STATUS
FROM FSFORMULA
WHERE FORMULA_CODE LIKE 'F%'
    multi_lang_query_code
  3. Open the Lookup Set form.
  4. Create a Lookup Set for WIDGETLOOKUP.
  5. Add a row in the Lookup tab using the information below.
    Lookup Code
    WIDGETLANG
    Description
    Specify any description. Example: Query based on Language
    Auto Start
    Yes
    Query Code
    QUERYWIDGET
    lookup_WIDGETLANG
  6. Add the column labels in the Lookup Language tab in the same order of the columns in the QUERYWIDGET query. The prefixes that indicate conditional formatting are codes and must be upper case.
    Below are the labels mentioned for columns in the Lookup Language tab for the Lookup Code:
    Language code Column Labels
    German 
    Formelcode;Version;Beschreibung;Status;Änderungsdatum;DR_FORMULA_Formelcode;F_BG_Status;F_STATUS_ICON_Formelstatus
    English 
    Formula Code;Version;Description;Status;Modify Date;DR_FORMULA_Formula Code;F_BG_Status;F_STATUS_ICON_Formula Status
    Spanish 
    Código de fórmula;Versión;Descripción;Estado;Fecha de modificación;DR_FORMULA_Código de fórmula;F_BG_Estado;F_STATUS_ICON_Estado de la fórmula
    Finnish 
    Kaavakoodi;Versio;Kuvaus;Tila;Muuta päivämäärää;DR_FORMULA_Kaavakoodi;F_BG_Tila;F_STATUS_ICON_Kaavan tila
    French 
    Code de formule;Version;Description;Statut;Date de modification;DR_FORMULA_Code de formule;F_BG_Statut;F_STATUS_ICON_Statut de la formule
    Italian 
    Codice formula;Versione;Descrizione;Stato;Data modifica;DR_FORMULA_Codice formula;F_BG_Stato;F_STATUS_ICON_Stato formula
    Japanese 
    式コード;バージョン;説明;ステータス;日付の変更;DR_FORMULA_式コード;F_BG_ステータス;F_STATUS_ICON_フォーミュラステータス
    Portugese 
    Código da fórmula;Versão;Descrição;Status;Data de modificação;DR_FORMULA_Código da fórmula;F_BG_Status;F_STATUS_ICON_Status da fórmula
    Swedish 
    Formelkod;Version;Beskrivning;Status;Ändringsdatum;DR_FORMULA_Formelkod;F_BG_Status;F_STATUS_ICON_Formelstatus
    Chinese 
    公式代码;版本;说明;状态;修改日期;DR_FORMULA_公式代码;F_BG_状态;F_STATUS_ICON_公式状态
    lookup_language_tab
  7. Configure the WIDGETLANG lookup code in the Lookup Set tab.
    Lookup Code
    WIDGETLANG
    Set Code
    WIDGETLOOKUP
    Format
    A
    lookup_set_tab
  8. Click Save.
  9. Add the widget in the Homepage.
  10. In the Query widget, click Configure. Specify PLM Process Query for the title, Widgets for the database and WIDGETLOOKUP\QUERYLANG for the Query Code.
    configure_query_widget
  11. Now, the Query widget displays the data grid with the conditional formatting.
    query_conditional_formatting