This topic provides step-by-step instructions for building an Asset Management app using the WaveMaker Rapid-Application Development Platform.
Pre-Requisite: You are advised to understand the WaveMaker App Development Essentials before starting to build the app.
The following concepts are covered in building this application.
- Creating Basic Application
- Building the UI – Layouts, Templates and Widgets
- Importing an SQL Database
- Creating Variables to access database
- Creating Variables to access queries
- Securing the App
- Running the App
- Deploying the App
WM App Overview
WMFirst Steps - Page Creation, Page Navigation, Create DatabaseSQL File for Database Import: Download and extract the zip file for use in this step: AssetsDB
WMBuilding Pages - Browse Catalog, View Device Inventory & Review Requests
WMWorkflows - Request Device & Assign DevicesQueries needed in this step:
UPDATE REQUESTED, DEVICE_INVENTORY SET REQUESTED.ASSIGNED=true, REQUESTED.ASSIGNED_QTY = REQUESTED.ASSIGNED_QTY + 1, REQUESTED.REQUESTED_QTY = REQUESTED.REQUESTED_QTY - 1, DEVICE_INVENTORY.QTY = DEVICE_INVENTORY.QTY - 1 where DEVICE_INVENTORY.`DEVICE ID` = :devID and REQUESTED.ID = :id
WMDashboard using Charts