This document provides step by step instructions for building Asset Management Application using 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
SQL File for Database Import: Download and extract the zip file for use in this step:
Queries needed in this step:
MySQL12345UPDATE REQUESTED, DEVICE_INVENTORYSET REQUESTED.ASSIGNED=true, REQUESTED.ASSIGNED_QTY = REQUESTED.ASSIGNED_QTY + 1,REQUESTED.REQUESTED_QTY = REQUESTED.REQUESTED_QTY - 1,DEVICE_INVENTORY.QTY = DEVICE_INVENTORY.QTY - 1where DEVICE_INVENTORY.`DEVICE ID` = :devID and REQUESTED.ID = :id