You are here: Utilities > Administration > Server > Utilities: Administration: Server: Database Administration: View Query Results

Utilities: Administration: Server: Database: View and Edit Data: View Query Results

 

You will be taken to this page if you view a table, view a segment, or run your own SQL query.

 

Finding Data

Twenty rows are shown at a time. To view more, click Show more. Repeatedly clicking Show morewill show greater numbers of rows at a time. Click Next to see the next twenty rows, Previousto see the last twenty.

 

You may change the sorting order by clicking the up or down triangles next to each field. By clicking the top triangle, the sort order will be ascending (a-z); clicking the bottom arrow makes the sort order descending (z-a).

 

Viewing or Editing an Existing Row

Click "view" next to the row to view it. You will be taken to the View Row page, where you can view the data, edit it, or delete it entirely (you may not edit or delete results from your own SQL queries).

 

Use caution when editing or deleting data directly in this manner. Changes made directly to the database may cause ListManager to malfunction in unpredictable ways, and should be used at your own risk.

 

Consult a database administrator if you are uncertain about changes you'd like to make. Information about the ListManager tables is available in the Programmer's Guide:

 

http://www.lyris.com/support/listmanager/software/

 

Download as a File

Click on the disk icon to download the data in CSV format.

More

 

1. Utilities: Administration: Server: Database Administration

2. Utilities: Administration: Server: Database Administration: View and Edit Data

1. Utilities: Administration: Server: Database Administration: View Member Table

2. Utilities: Administration: Server: Database Administration: View Table

3. Utilities: Administration: Server: Database Administration: View Segment

4. Utilities: Administration: Server: Database Administration: Run Your Own SQL Query

5. Utilities: Administration: Server: Database Administration: View Query Results

6. Utilities: Administration: Server: Database Administration: View Row

3. Utilities: Administration: Server: Database Administration: Add/Remove Member Columns

1. Utilities: Administration: Server: Database Administration: Add Member Column

2. Utilities: Administration: Server: Database Administration: Add Member Column: Wizard

3. Utilities: Administration: Server: Database Administration: Delete Member Column

4. Utilities: Administration: Server Database: Demographic Definitions

1. Utilities: Administration: Server Database: Demographic Definitions: New Definition

5. Utilities: Administration: Server: Database Administration: Insert Row