Configure MX Query Builder

Depending on your database management system (DBMS), there are some MX Query Builder settings which may need to be modified. For example, some database management systems use "!=" for a "not equals" comparison, others use "<>".

To reach the settings interface, open the MX Query Builder menu and select the Settings option:

 

The following dialog box will appear:

 

To configure it, follow the next steps:

  1. In the Enclose date between text box enter the character that will delimit a date. For example, '04-03-2004' using single quotes, or "04-03-2004" with double quotes.

  2. In the Not equals drop-down menu select the symbol that your DBMS is using for the "not equals" comparison. The query builder default is "!=", but you can change this depending on your configuration to "<>".

  3. Check the Use AS in order by checkbox if your DBMS syntax allows it.

  4. Click OK when you are done.

By using MX Query Builder, a folder named qub will be created in your includes folder. Do not forget to upload this folder on the server. MX Query Builder also creates 3 tables in your database. To get more information about this, consult What is MX Query Builder repository?.