# Create Order Request Entity
*(Order Management App – Web Tutorial)*
This section explains how to create the **Order Request Entity** using **App Designer**.\
This entity represents the main data entry screen for requesters who submit hardware order requests.
The entity consists of:
* **Order Request (Header)** – 1‑1 module
* **Order Request Item (Detail)** – 1‑Many module
***
### Objective
By completing this section, you will learn how to:
* Create an entity in App Designer
* Design form layout with Tabs and Modules
* Configure SQL Work Queue
* Define fields and validations
* Configure Search, Insert, Update actions
* Configure Module Keys and parent‑child relationships
***
### Step 1: Create Entity
1. From **AppSpace**, click **Form**
2. A popup dialog opens
3. Enter **Component Name**
4. Click **Start Design**
***
### Step 2: Create Main Tab (Order Request)
1. From **Tools → Tabs**
2. Drag **2‑Layer Tab** into the entity
3. Set **Title**: `Order Request`
4. Click **Add**
***
### Step 3: Create Order Request Module (1‑1)
1. From **Tools → Module**
2. Drag **1‑1 Module** under Order Request tab
3. Click **pencil icon**
4. Configure Module:
* **Module Name**: `Order Request`
* **Table Name**: `wf_service_request (T)`
5. Set **SQL Work Queue**:
```
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
```
6. Click **OK**
***
### Step 4: Configure Layout
1. Click **Configuration Layout**
2. Select **2 Column**
3. Click **Accept**
***
### Step 5–15: Configure Fields (Order Request)
> **Fields Created (exactly as original):**
#### Row 1
* **REQUEST\_ID** (Text Box, readonly, searchable, seq 1)
* **REQUESTER** (Text Box, readonly, searchable, seq 2)
***
#### Row 2
* **PROJECT** (Dynamic List → wf\_ms\_project)
* **PHASE** (Dynamic List → wf\_ms\_phase)
***
#### Row 3
* **DESCRIPTION** (Textarea, searchable, like enabled)
* **CREATE\_DATE** (No Object, GUI only)
***
#### Row 4
* **PROJECT\_NAME** (No Object, GUI only)
* **REQUEST\_TYPE** (Hidden, default = 03)
***
### Step 16–21: Configure Entity Buttons (Order Request)
Buttons created:
* **SEARCH** → `ENTITY_SEARCH`, `searchResult()`
* **CREATE** → `ENTITY_SEARCH`, `addEntity()`
* **SAVE** (Insert) → `saveEntity()`
* **SAVE** (Update) → `saveEntity()`
* **CANCEL** (Insert) → `cancelEntity()`
* **CANCEL** (Update) → `cancelEntity()`
***
### Step 22–35: Create Order Item Tab & Module (1‑Many)
1. Add **Normal Tab**
* Title: `Order Item`
2. Add **1‑Many Module**
* Table: `wf_order_request_item (T)`
#### Fields in Order Item:
* REQUEST\_ID (Hidden)
* ORDER\_ITEM\_ID (Hidden)
* HARDWAREID (Dynamic List → wf\_ms\_hardware)
* SPEC (Textarea)
* UNIT (Text Box – Integer)
* REMARK (Textarea)
#### Module Buttons:
* ADD
* DELETE
* SAVE (Insert)
* SAVE (Update)
* CANCEL (Insert)
* CANCEL (Update)
***
### Step 36–37: Configure Module Keys
#### Order Request
* Key: REQUEST\_ID
* Prefix: OD
* Length: 8
* Sequence: REQUEST\_ID\_SEQ
#### Order Request Item
* Key: ORDER\_ITEM\_ID (Prefix IT, Seq ORDER\_ITEM\_ID\_SEQ)
* Parent Key: REQUEST\_ID
***
### Final Result
The completed entity structure appears as follows:
***
### Summary
In this section, you have:
* Created the **Order Request entity**
* Configured master/detail modules
* Designed searchable UI fields
* Added entity buttons
* Defined module keys and relationships
This entity serves as the **main entry point** for requesters in the Order Management App.\
In the next section, you will design screens for **BackOffice, Approval, and Admin PO** roles.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.onewebstack.com/oneweb-platform-th/tutorials-examples/order-management-app-web/app-designer/create-order-request-entity.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
