Asset Management App

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.

1. Creating Basic Application
2. Building the UI – Layouts, Templates and Widgets
3. Importing an SQL Database
4. Creating Variables to access database
5. Creating Variables to access queries
6. Binding
7. Securing the App
8. Running the App
9. Deploying the App

WM App Overview

WM First Steps

Page Creation, Page Navigation, Create DatabaseSQL File for Database Import: Download and extract the zip file for use in this step: AssetsDB

WM Building Pages

Browse Catalog, View Device Inventory & Review Requests

WM Securing App

WM Workflows

Request Device & Assign DevicesQueries needed in this step:

1. ReduceQuantityPostAssignment:

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

WM Dashboard using Charts