We are working for update doc for SXIMO 5.1.7

MySQL Editor

At the first time you create module, system will create automatic single query table


Alt Text

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 Model Files