Managing Language Preferences

It is possible to set up the Configurable InBasket to handle multiple languages so that it selects the values appropriate to the client environment.

The following sample shows how to adjust the InBasket to handle the German locale:

1. Edit the Workflow_Task_Step02_Create_Tmp_View SQL item.

   1. Open the Workflow_Task_Step02_Create_Tmp_View SQL item for editing.

   2. Change the query for Instructions column:

      From: COALESCE(CASE WHEN lang.CODE='en’ THEN act.MESSAGE END, act.MESSAGE) AS INSTRUCTIONS,
      To: COALESCE(CASE WHEN lang.CODE='en’ THEN act.MESSAGE WHEN lang.CODE='de’ THEN act.MESSAGE_DE END, act.MESSAGE) AS INSTRUCTIONS,

   3. Change the query for Activity column:
      From: COALESCE(CASE WHEN lang.CODE='en’ THEN act.label END, act.label, act.NAME) AS NAME,
      To: COALESCE(CASE WHEN lang.CODE='en’ THEN act.LABEL WHEN lang.CODE='de’ THEN act.LABEL_DE END, act.LABEL, act.NAME) AS NAME,
   4. Save, unlock, and close the Workflow_Task_Step02_Create_Tmp_View SQL item.

2. Rebuild SQL view for Workflow Item Task.
   
   1. From the search grid, search for Workflow_Task_Step%SQL items.
   2. Right-click on Workflow_Task_Step01_Dropin the search grid and select SQL Execute from the context menu.
   3. Right-click on Workflow_Task_Step02_Create_Tmp_Viewin the search grid and select SQL Execute from the context menu.
   4. Right-click on Workflow_Task_Step03_Rename_Viewin the search grid and select SQL Execute from the context menu.