Overview

From a PhixFlow Datasourcedatasource, you can bring up a list of open a window listing the tables in that database. For example, in the datasource properties tab, in the toolbar click on 

• the data in the table
• a list of the attributes defined in that table

Depending on where you call up open the table list from, it will be either a simple list with only the name of each table, or a detailed list.

...

The database tables list has a toolbar with common buttons. You can export data from a detailed list using the 

See also Datasource.

Detailed Table List

In the detailed table list, the following fields are shown for each table:

HELPDEVTODO: confirm this in the new gui

...

You can do the following things from the table list:

• Show To show data in table - , double-click on the table.
• Bring up To display a simple list of the table attributes, right-click to display the context menu and select Show Table Attributes from the right-click menuBring up a    .
• To display a detailed list of the table attributes, right-click and select Show Attribute Details from the right-click menuCreate ; see Table Attribute Details below.
• To export data from a table, use the 

  Insert excerpt
  _excel_export _excel_export nopanel true

   button; see Download CSV or Excel Data.
• To create a collector for the stream - HELPDEVTODO: drag doesn't currently work drag , 
  • either drag the table onto a model view
  ,
  • or right-click and select Create a Collector
  from the right-click menu

Forms: Table Attributes

...

• • .

Table Attribute Details 

Anchor
list list

Anchor
databaseTableAttributesDetailedList databaseTableAttributesDetailedList

...

Depending on how you display them, database table attributes

...

There are two forms of the Table Attribute list:

• Detailed list - Shows the attribute name plus other (database specific) details
• Simple list - Just shows the attribute names

In both cases the lists show all the attributes for the selected Table.

The list below gives the column headers returned for an Oracle database. See Oracle documentation for more details.may be

• either in a simple list, with only the name of each attribute
• or in  detailed list.

In the detailed list, the following fields are shown for each attribute:

...

Table Attribute Actions

The following actions are possible from a Table Attribute list:

• Selecting several attributes and dragging onto a modelling pane creates a Database Collector which is linked to the original Datasource. The Collector will be set up to fetch just the selected columns and all the table data.

See Also

You can select several attributes and drag them onto a model window. PhixFlow creates a database collector to read the selected fields from that table.