User Guide | Customising SQL Statements

Many of the flexi cart functions return data that can be customised by re-defining the SQL statements used by the function.

User Guide Sections

Querying SQL Results | Defining Custom SQL Statements | Building Custom SQL Queries | Misc. Admin Functions

SQL Queries

Customise SQL statements used by flexi cart functions.
Returning Data from SQL Query Results

Defining Custom SQL Statements

Building Custom SQL Queries
  • SQL SELECT
    Defines the table columns to be returned by the SQL SELECT statement.
  • SQL WHERE
    Defines the table column and comparision value to be used by the SQL WHERE statement.
  • SQL WHERE IN
    Defines the table column and comparision values to be used by the SQL WHERE IN statement.
  • SQL WHERE LIKE
    Defines the table column and comparision values to be used by the SQL WHERE LIKE statement.
  • SQL JOIN
    Defines the table name and join relationship between the to-be-joined tables used by the SQL JOIN statement.
  • SQL ORDER BY
    Defines the table column and sort direction used by the SQL ORDER BY statement.
  • SQL GROUP BY
    Defines the table column used by the SQL GROUP BY statement.
  • SQL LIMIT
    Defines the limit value and offset value used by the SQL LIMIT statement.
  • Clear SQL statements
    Clears any custom user defined SQL Active Record functions.

Admin Data

Run database management functions.
Custom Table CRUD Functions