Difference between revisions of "SQL Browser"

From AgileApps Support Wiki
imported>Aeric
m (Text replace - 'Designer > Data >' to 'Designer >')
imported>Aeric
m (Text replace - 'Designer > Objects' to 'File:GearIcon.png > Customization > Objects')
Line 1: Line 1:
'''Designer > Objects > [SQL Browser]'''
'''[[File:GearIcon.png]] > Customization > Objects > [SQL Browser]'''


The SQL Browser gives you a graphical interface that lets you enter a SQL query and view the results:
The SQL Browser gives you a graphical interface that lets you enter a SQL query and view the results:

Revision as of 18:43, 14 May 2013

GearIcon.png > Customization > Objects > [SQL Browser]

The SQL Browser gives you a graphical interface that lets you enter a SQL query and view the results:

SQLBrowserSelect.png
How it works
  • The navigation pane on the left shows all of the Object tables in your database.
  • Clicking the arrow next to one expands the tree, showing the columns in the table
  • Double-clicking a table populates the statement pane with a default query (SELECT *) from that table.
  • To run the query, press Ctrl+Enter or click the triangle-button on the right.
SQLBrowserGoButton.png

Notepad.png

Note:
When you make a SQL query, you are not querying the platform database directly. Rather, you are querying a view of the database that is restricted by your role permissions, so the records and fields you can see using SQL are the same as those you see when using the GUI. In addition, the platform implements various safeguards to prevent SQL Injection attacks.

Considerations
  • SQL syntax is not case-sensitive, except for table names and field names.
  • Backticks are (`) are needed around any table or field name that is one of the SQL Reserved Words.
For example: SELECT * FROM `Order`
Without the backticks, you get an error like this:
Encountered "Order" at line column 15. Was expecting one of (...
That error means the parser found a word it recognized, but didn't find other things it expected before it got to that word.
  • When either a table name or a field name is reserved word, and both are used together, then backticks are needed around the combination.
For example: `Order.order_number`
  • If you do a query on different tables that have fields with the same name, you should provide column aliases for those fields. (Otherwise, a query for A.phone and B.phone identifies both sets of values as "phone". A column alias like A.phone AS A-phone makes it possible to tell which table a set of values came from.)
Learn more: column_expr

Learn more: SQL Syntax