Learn about the steps to create entity for requester who needs to make order request.

Procedure

  1. From ONEWEB App Designer screen, click Entities > Create New Entity and then click OK on the popup dialog. The new entity name is "Entity Name" opens.
  2. Edit entity name by click Entity Properties (icon pencil) and then change Entity name to "Doc Order Request - Requester".
  3. From Tools > Tabs drag 2-Layer Tab to the silver box under entity name. The dialog of Add Tab data opens. Put "Order Request" to Title and then click Add.
  4. From Tools > Module drag 1-1 to the box under the Order Request tab.
    • Click icon pencil. The dialog of Module Configuration opens.
    • Change Module Name to "Order Request".
    • Change Table Name to "wf_service_request (T)".
    • Put "select wf_service_request.request_id, wf_service_request.requester, wf_service_request.project, wf_ms_project.project_name, wf_service_request.phase, wf_service_request.description, to_char(wf_service_request.create_date, 'DD/MM/YYYY HH24:MI:SS') as create_date from wf_service_request join wf_ms_project on wf_service_request.project = wf_ms_project.project_id" to SQL Work Queue.
    • Click OK.
    • Click icon Configuration Layout. The dialog opens.
    • Select 2 Column and then click Accept. The table that has 2 columns will show.


  1. From Tools > Field drag Text Box to the first cell of the table. (From step 4.6) The textLabel shows.
    • Click icon pencil. The dialog of Text box Configuration opens.
    • Put "readonly" to Soruce tag.
    • Change FIELD_ID to "REQUEST_ID".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Request Id".
    • Switch ShowSearch to "Y".
    • Change showSearchSeq to "1".
    • Click OK.


  1. From Tools > Field drag Text Box to the second cell of the table. (From step 4.6) The textLabel shows.
    • Click icon pencil. The dialog of Text box Configuration opens.
    • Put "readonly" to Soruce tag.
    • Change FIELD_ID to "REQUESTER".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Requester".
    • Switch ShowSearch to "Y".
    • Change showSearchSeq to "2".
    • Click OK.


  1. From Order Request Module click icon append row. The system will append new row to the table.


  1. From Tools > Field drag Dynamic List to the first cell of new row (From step 7) The dropdownLabel shows.
    • Click icon pencil. The dialog of Dynamic List Box Configuration opens.
    • Change Table Name to "wf_ms_project".  
    • Change Column Show to "PROJECT_NAME".
    • Change Column Value to "PROJECT_ID".
    • Change FIELD_ID to "PROJECT".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Project".
    • Switch SearchCriteria to "Y".
    • Change searchFieldGroup and searchCriteriaSeq to "1".
    • Select "CHECK_NULL" at Validate Code and click icon plus. The new record of Validate Code show.
    • Click OK.


  1. From Tools > Field drag Dynamic List to the second cell of new row (From step 7) The dropdownLabel shows.
    • Click icon pencil. The dialog of Dynamic List Box Configuration opens.
    • Change Table Name to "wf_ms_phase".
    • Change Column Show to "PHASE_NAME".
    • Change Column Value to "PHASE_ID".
    • Change FIELD_ID to "PHASE".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Phase".
    • Click OK.


  1. From Order Request Module click icon append row. The system will append new row to the table.


  1. From Tools > Field drag Textarea to the first cell of new row (From step 10) The textareaLabel shows.
    • Click icon pencil. The dialog of Text Area Configuration opens.
    • Change FIELD_ID to "DESCRIPTION".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Description".
    • Switch SearchCriteria, ShowSearch and searchLike to "Y".
    • Change searchFieldGroup to "1", searchCriteriaSeq to "2" and showSearchSeq to "4".
    • Click OK.


  1. From Tools > Field drag NO Object to the second cell of new row. (From step 10) The noLabel shows.
    • Click icon pencil. The dialog of No Object Field Configuration opens.
    • Change FIELD_ID to "CREATE_DATE".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Create Date".
    • Switch ShowSearch to "Y".
    • Change showSearchSeq to "5".
    • Switch onlyGuiFlag to "Y".
    • Click OK.


  1. From Order Request Module click icon append row. The system will append new row to the table.


  1. From Tools > Field drag NO Object to the first cell of new row. (From step 13) The noLabel shows.
    • Click icon pencil. The dialog of No Object Field Configuration opens.
    • Change FIELD_ID to "PROJECT_NAME".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Project Name".
    • Switch ShowSearch to "Y".
    • Change showSearchSeq to "2".
    • Switch onlyGuiFlag to "Y".
    • Click OK.


  1. From Tools > Field drag Hidden to the second cell of new row. (From step 13) The hiddenLabel shows.
    • Click icon pencil. The dialog of Hidden Field Configuration opens.
    • Put "03" to Default value.
    • Change FIELD_ID to "REQUEST_TYPE".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Request Type".
    • Click OK.


  1. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "SEARCH".
    • Change Page Action to "ENTITY_SEARCH".
    • At Button Action select first radio and change button action to "searchResult()".
    • Click OK.


  1. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "CREATE".
    • Change Page Action to "ENTITY_SEARCH".
    • At Button Action select first radio and change button action to "addEntity()".
    • Click OK.


  1. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "SAVE".
    • Change Page Action to "ENTITY_INSERT".
    • At Button Action select first radio and change button action to "saveEntity()".
    • Click OK.


  1. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "SAVE".
    • Change Page Action to "ENTITY_UPDATE".
    • At Button Action select first radio and change button action to "saveEntity()".
    • Click OK.


  1. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "CANCEL".
    • Change Page Action to "ENTITY_INSERT".
    • At Button Action select first radio and change button action to "cancelEntity()".
    • Click OK.


  1. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "CANCEL".
    • Change Page Action to "ENTITY_UPDATE".
    • At Button Action select first radio and change button action to "cancelEntity()".
    • Click OK.


  1. From Tools > Tabs drag General Tab to the silver box under the table. The dialog of Add Tab data opens. Put "Order Item" to Title, select 1 column and then click Add. The Order Item tab show.


  1. From Tools > Module drag 1-Many to the box under the Order Item tab.
    • Click icon pencil. The dialog of Module Configuration opens.
    • Change Module Name to "Order Request Item".
    • Change Table Name to "wf_order_request_item (T)".
    • Click OK.


  1. From Tools > Field drag Hidden to Module Order Item. The hiddenLabel shows.
    • Click icon pencil. The dialog of Hidden Field Configuration opens.
    • Change FIELD_ID to "REQUEST_ID".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Request Id".
    • Click OK.


  1. From Tools > Field drag Hidden to Module Order Item. The hiddenLabel shows.
    • Click icon pencil. The dialog of Hidden Field Configuration opens.
    • Change FIELD_ID to "ORDER_ITEM_ID".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Order Item Id".
    • Click OK.


  1. From Tools > Field drag Dynamic List to Module Order Item. The dropdownLabel shows.
    • Click icon pencil. The dialog of Dynamic List Box Configuration opens.
    • Change Table Name to "wf_ms_hardware".
    • Change Column Show to "HARDWARE_NAME".
    • Change Column Value to "HARDWARE_ID".
    • Change FIELD_ID to "HARDWAREID".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Hardwareid".
    • Change FieldGroup to "1" and change Seq to "1".
    • Switch ShowSearch to "Y".
    • Change showSearchSeq to "1".
    • Select "CHECK_NULL" at Validate Code and click icon plus. The new record of Validate Code show.
    • Click OK.


  1. From Tools > Field drag Textarea to Module Order Item. The textareaLabel shows.
    • Click icon pencil. The dialog of Text Area Configuration opens.
    • Change FIELD_ID to "SPEC".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Spec".
    • Change FieldGroup to "1" and change Seq to "2".
    • Select "CHECK_NULL" at Validate Code and click icon plus. The new record of Validate Code show.
    • Click OK.


  1. From Tools > Field drag Text Box to Module Order Item. The textLabel shows.
    • Click icon pencil. The dialog of Text box Configuration opens.
    • Select "Integer" at Number Formatter.
    • Change FIELD_ID to "UNIT".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Unit".
    • Change FieldGroup to "2" and change Seq to "1".
    • Switch ShowSearch to "Y".  
    • Change showSearchSeq to "2".
    • Select "CHECK_NULL" at Validate Code and click icon plus. The new record of Validate Code show.
    • Click OK.


  1. From Tools > Field drag Textarea to Module Order Item. The textareaLabel shows.
    • Click icon pencil. The dialog of Text Area Configuration opens.
    • Change FIELD_ID to "REMARK".
    • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Remark".
    • Change FieldGroup to "2" and change Seq to "2".
    • Click OK.


  1. From Tools > Button drag Module Button to space under the Module Order Request Item. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "ADD".
    • Change Page Action to "SUB_SEARCH".
    • At Button Action select first radio and change button action to "popupActionFlow('[MODULE_ID]')".
    • Click OK.


  1. From Tools > Button drag Module Button to space under the Module Order Request Item. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "DELETE".
    • Change Page Action to "SUB_SEARCH".
    • At Button Action select first radio and change button action to "[MODULE_ID]Delete()".
    • Click OK.


  1. From Tools > Button drag Module Button to space under the Module Order Request Item. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "SAVE".
    • Change Page Action to "INSERT".
    • At Button Action select first radio and change button action to "actionFormSubmit('insertMany','Y')".
    • Click OK.


  1. From Tools > Button drag Module Button to space under the Module Order Request Item. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "SAVE".
    • Change Page Action to "UPDATE".
    • At Button Action select first radio and change button action to "actionFormSubmit('insertMany','Y')".
    • Click OK.


  1. From Tools > Button drag Module Button to space under the Module Order Request Item. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "CANCEL".
    • Change Page Action to "INSERT".
    • At Button Action select first radio and change button action to "$('#many_[MODULE_ID]_dialog').dialog('close');".
    • Click OK.


  1. From Tools > Button drag Module Button to space under the Module Order Request Item. The SUBMIT_VALUE show.
    • Click icon pencil. The dialog of Button Configuration opens.
    • Change buttonName to "CANCEL".
    • Change Page Action to "UPDATE".
    • At Button Action select first radio and change button action to "$('#many_[MODULE_ID]_dialog').dialog('close');".
    • Click OK.


  1. Configure Order Request module key.
    • From module Order Request click icon pencil. The dialog of Module Configuration opens.
    • Put "REQUEST_ID to Module Key.
    • Put "OD" to Prefix.
    • Put "8" to KeyLen.
    • Put "REQUEST_ID_SEQ" to Sequence.
    • Click icon plus. The new record of Module Key show.
    • Click OK.


  1. Configure Order Request Item module key.
    • From module Order Request Item click icon pencil. The dialog of Module Configuration opens.
    • Put "ORDER_ITEM_ID" to Module Key.
    • Put "IT" to Prefix.
    • Put "18" to KeyLen.
    • Put "ORDER_ITEM_ID_SEQ" to Sequence.
    • Click icon plus. The new record of Module Key show.
    • Put "REQUEST_ID" to Module Key.
    • Put "REQUEST_ID" to Parent Key.
    • Click icon plus. The new record of Module Key show.
    • Click OK.

The completed entity looks as shown in below diagram