BEST Offers , For All Sximo 5 LTS licence Holer , Upgrade Licence For only $14 Normal Price on Codecanyon $31
New product Sximopress ( Wordpress Builder ) 1.0 has been realesed . download it now !

Sximo 5 LTS - Builder

Create Awesome & Professional CRUD Web Application CMS Within Minutes

MYSQL Editor

Go to : Control Panel -> Code Builder -> Your module -> Click button gear -> Edit -> SQL
At the first time you create module, system will create automatic single query table

Why SXIMO BUILDER Creating automatic \“ *WHERE employee.EmployeeId IS NOT NULL* \” ?

this is for prevent error when users submit search form.

Every fields included on query select, will be displaying at grid table including fields from join table. so make sure every field you want to show on table grid and view detail, must be on your query statement.
Everytime you made changes with SQL editor , you have to rebuild Files

Working with join Query ( Displaying 2 or more table )

Example Join Query
    SELECT customer.*,tb_users.* FROM customer LEFT JOIN tb_users
    ON customer.staffid = tb_users.id 
If we using above statment , Grid table will automatically dispaying all SELECT statment from 2 tables.
Keep in your mind , althought we can displaying table grid form 2 or more table , form , insert , edit and remove operation only affected for 1 table (primary table).

Please Register Purchased Code for full access Docs


Last Update : 2017-04-09 00:34:10