| Insert excerpt |
|---|
| _remote_database_table |
|---|
| _remote_database_table |
|---|
| nopanel | true |
|---|
|
s feature in PhixFlow v12.1+.
Overview
| Insert excerpt |
|---|
| _remote_database_table |
|---|
| _remote_database_table |
|---|
| nopanel | true |
|---|
|
s allow tables
from external databases to be used in PhixFlowin external databases to be used in PhixFlow and data written back to the database.They are created in an ERD and backed by a
| Insert excerpt |
|---|
| _datasource |
|---|
| _datasource |
|---|
| nopanel | true |
|---|
|
.Changes can be made to remote database tables in PhixFlow, such as updating or inserting, and saved in an Actionflow using a
| Insert excerpt |
|---|
| _action_save |
|---|
| _action_save |
|---|
| nopanel | true |
|---|
|
action. These changes will be saved back to the external database.Use | Insert excerpt |
|---|
| _remote_database_table |
|---|
| _remote_database_table |
|---|
| nopanel | true |
|---|
|
s in:
| Insert excerpt |
|---|
| _actionflow |
|---|
| _actionflow |
|---|
| nopanel | true |
|---|
|
s for direct reading and writing to external tables | Insert excerpt |
|---|
| _screen |
|---|
| _screen |
|---|
| nopanel | true |
|---|
|
s to provide real time views of data in external databases
| Excerpt |
|---|
|
| Note |
|---|
| title | Important Considerations |
|---|
| - On ERDs, relations between two Remote Database Tables cannot be created unless both remote tables have the same backing datasource
- Relations cannot be created between Remote Database Tables and
| Insert excerpt |
|---|
| _tables |
|---|
| _tables |
|---|
| nopanel | true |
|---|
|
s - Remote Database Tables cannot be used in Analysis Models
- Changes made to Remote Database Tables in PhixFlow do not have an audit trail and their recordsets cannot be rolled back
|
|
For how to create a
| Insert excerpt |
|---|
| _remote_database_table |
|---|
| _remote_database_table |
|---|
| nopanel | true |
|---|
|
, see Adding Data and Tables to an ERD.
| Insert excerpt |
|---|
| _property_tabs |
|---|
| _property_tabs |
|---|
| name | basic-h |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _parent |
|---|
| _parent |
|---|
| nopanel | true |
|---|
|
Basic SettingsSettings
| Field | Description |
|---|
| Name | The name of the File Remote Database Table. |
| Enabled | Enable to allow a file to be uploaded and associated information captured, when a file(s) is dragged and dropped onto a File Display or File Gallery component. the table to be used. |
| Table | The name of the table associated with on the datasourcedatabase. |
| Datasource | emote Database Tables can be backed by a Datasource and then any save actions / grids that view them will update / read from / insert into the database that the backing datasource is connected to. | Read Only | Tick to signify that the file table's attributes cannot be amendedThe name of the datasource connected to the remote database. |
| Description | Enter a description to explain the purpose of this item. |
Attributes
After mappings in the column names from the remote table, they will appear here as attributes.
The attribute's column name (as it appears on the database) can be seen by double-clicking the attribute to see the Column Name field.
To display the Mappings window, hover over the
tableFiletableFiles have a set of predefined attributes that cannot be changed, deleted or added to. These attributes are: menu and choose | Insert excerpt |
|---|
| _map_attributes |
|---|
| _map_attributes |
|---|
| nopanel | true |
|---|
|
.See All Sections
| Expand |
|---|
| title | Click here to see details of all sections... |
|---|
|
| Insert excerpt |
|---|
| Table |
|---|
| Table |
|---|
| name | Views |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Table |
|---|
| Table |
|---|
| name | SortOrders |
|---|
| nopanel | true |
|---|
|
Errors | Insert excerpt |
|---|
| _validate |
|---|
| _validate |
|---|
| name | error |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Table |
|---|
| Table |
|---|
| name | ERDs |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Table |
|---|
| Table |
|---|
| name | Relations |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Table |
|---|
| Table |
|---|
| name | Filters |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Table |
|---|
| Table |
|---|
| name | DataRetentionSettings |
|---|
| nopanel | true |
|---|
| | Insert excerpt |
|---|
| _model_prop | _model_prop | | nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Table |
|---|
| Table |
|---|
| name | Advanced |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _access |
|---|
| _access |
|---|
| nopanel | true |
|---|
|
|