Demonstrates how to use the read from xml file sql commands. You can store all your predefined sql commands in simple xml file where every command is identfied by id and then just tell the jqGrid which file to use and which sql. See the example. Here in this example we use the following xml file <?xml version="1.0" encoding="UTF-8"?> <queries> <sql Id="getProducts"> SELECT * FROM products </sql> <sql Id="getOrders"> SELECT * FROM orders </sql> </queries>