2. Custom SQL

fmCustomSQL - Custom SQL Section

Here you can create a query using SQL language. This section will help you work with your store DB, fetching data easier and faster.

When you open Custom SQL page, you'll see that it looks similar to Create New Report page. This page has 2 tabs: Edit and Logs; and is divided in two sections: the one at the top is showing the query content (SQL text), and the one at the bottom lists all available queries. You can also open an SQL Query file that was previously saved by clicking the corresponding icon.

In the process of creating a new query (New SQL icon), you need to specify its name and click OK. At the bottom part of the page you'll see the query with this name created. Now you can either run a Query builder or write query text in the top part of Edit tab directly. When you're finished with this query hit Save button. Then you can execute it by pressing the Execute SQL button. The Results tab will appear, showing the returned data, arranged according to a certain condition.

If the query wasn't executed, you can check the Logs tab for errors. Logs tab will be cleared after you close Store Manager.

When constructing complicated queries it's more convenient to use Visual Query Builder.

Important note: We strongly recommend to make full DataBase Backup before making any major changes.

By eMagicOne Inc.