Browsing Data

Record List Screen

 

After creating a connection to your database and selecting the connection, you will be taken to the schema browser, where you can browse through the schemas, tables, and views defined in your database. Tapping on any of the tables or views will take you into a screen with the complete list of contents of the table.

 

droppedImage-3.png

 

The interface for the record list consists of the following components:

 

droppedImage-4.png In the upper-left corner is a back button that will return you to the previous screen.

droppedImage-5.png In the upper-right corner is a search button you can use to bring up the query builder screen as well as recent searches and search bookmarks. See: “Query Builder

droppedImage-6.png Below the top buttons is a list of the column names of the current table. Tapping on any of the column buttons will sort the currently-loaded records based on that field in ascending order. Tapping a second time will sort the records in reverse order.

droppedImage-7.png Below the column list is the quick search field, where you can enter a search term. See: “Quick Search

droppedImage-8.png Below the search field is the actual list of records in the database. Tapping on any of the records will bring you into a screen with more details about the records, as well as the ability to edit or delete the record. Also, when a record list has more columns than can fit on the current screen, you can tap and hold a record and drag your finger to the left to scroll to see more columns in the table list.

droppedImage-9.png The circular toolbar button in the lower-left corner is the refresh button, which you can use to re-execute the most recent query. This can be useful if your database contents have changed and you want to see the new contents.

droppedImage-10.png The next toolbar plus button can be used to add a new record to the current table. See: “Creating New Records

droppedImage-11.png The double arrow button is used when the number of records is greater than the default maximum to show at once (the default is 100 records, although this can be changed in the settings for the app). Tapping the double down arrows will load the next batch of 100 records.

droppedImage-12.png The double arrow ending in a square in the toolbar will try to load all of the query results. Note that this could result in memory and performance slowdowns if your table contains millions of rows, since those rows all need to be transferred the the app.

droppedImage-13.png The line chart toolbar button can be tapped to bring up the chart builder.

droppedImage-14.png The toolbar button in the lower-right corner can be used to export, mail, or print the current list of records.

 


Record Detail Screen

 

When you tap on any record in the Record List Screen, you will be taken to the Record Detail Screen, which contains more information about the record, as well as the ability to edit, delete, and drill into relationships.

 

droppedImage-15.png

 

The interface for the record list consists of the following components:

 

droppedImage-16.png In the upper-left corner is the back button that will take you to the previous record list screen.

droppedImage-17.png In the upper-right corner is the “Edit” button that will allow you to make changes to the record, provided you have sufficient permissions and the record contains database “primary keys” to uniquely identify it. See: “Editing Existing Records”.

In the center of the screen are the individual fields and relationships that make up the record. Tapping on any of the fields with the chevron mark to the right will drill into the relationship or open a viewer for attached photos or text. droppedImage-18.png

droppedImage-19.png The left-facing arrow on the bottom left will move to the previous record in the current record list.

droppedImage-20.png The plus button in the bottom toolbar will allow you to create a new record or duplicate the current record. See: “Creating New Records”.

droppedImage-21.png The numbers in the center of the bottom of the toolbar indicate which record from the parent record list you are currently viewing.

droppedImage-22.png The trash icon in the bottom toolbar offers you the ability to delete the record. See: “Deleting Records”.

droppedImage-23.png The right-facing arrow in the bottom right will move to the next record for the current record list.