Difference between revisions of "Data"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "''Under Construction. Coming soon in Lianja v5.0'' ==The App Inspector== The '''App Inspector''' display changes based on the current workspace, showing tabs relevant to tha...") |
Yvonne.milne (Talk | contribs) (→Column Names) |
||
| (17 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | =The App Inspector= | |
| − | + | ||
| − | + | ||
The '''App Inspector''' display changes based on the current workspace, showing tabs relevant to that workspace. | The '''App Inspector''' display changes based on the current workspace, showing tabs relevant to that workspace. | ||
| Line 11: | Line 9: | ||
<br clear=all> | <br clear=all> | ||
| − | + | =The Data Tab= | |
| − | The Data Tab contains file lists for the current App's data files. | + | The Data Tab contains file lists for the current App's data files. It appears in the App Inspector when the [[Pages Workspace]] is active. |
| − | + | ==Databases== | |
The Databases tab contains the '''Database Names''' panel with a list of available databases. | The Databases tab contains the '''Database Names''' panel with a list of available databases. | ||
| − | [[{{ns:file}}: | + | [[{{ns:file}}:l5_data1.png|left|link={{filepath:l5_data1.png}}|Data Tab]] |
<br clear=all> | <br clear=all> | ||
| − | Note: opening a database is not available when | + | Note: opening a database is not available when the App already has an associated database. |
<div style="height:80px;margin-bottom:5px;padding:5px;border:0px solid orange;border-left:5px solid orange;background:#fff8dc;vertical-align:middle;position:relative;"> | <div style="height:80px;margin-bottom:5px;padding:5px;border:0px solid orange;border-left:5px solid orange;background:#fff8dc;vertical-align:middle;position:relative;"> | ||
| Line 28: | Line 26: | ||
</div> | </div> | ||
| − | + | ===Instant Search=== | |
| + | From v5.3 the panel includes instant search. Just start typing the text you want to search for: | ||
| + | [[{{ns:file}}:appdatabases_instantsearch1.png|left|link={{filepath:appdatabases_instantsearch1.png}}|Instant Search]] | ||
| + | <br clear=all> | ||
| + | |||
| + | The display is updated as you type and as well as the mouse, you can also use the cursor keys and the return key to navigate and select: | ||
| + | [[{{ns:file}}:appdatabases_instantsearch2.png|left|link={{filepath:appdatabases_instantsearch2.png}}|Instant Search]] | ||
| + | <br clear=all> | ||
| + | ===Actionbar=== | ||
From the actionbar you can: | From the actionbar you can: | ||
| − | * Create a '''New''' database. This option is not available when | + | * Create a '''New''' database. This option is not available when the App already has an associated database. |
| − | * '''Delete''' the currently selected database. This option is not available when an App is open | + | * '''Delete''' the currently selected database. This option is not available when an App is open. |
* Open the '''MetaData editor''' for the currently selected database. See [[MetaData Editor]] for information. | * Open the '''MetaData editor''' for the currently selected database. See [[MetaData Editor]] for information. | ||
* Access '''Additional Commands''' by clicking the cog button. | * Access '''Additional Commands''' by clicking the cog button. | ||
| − | [[{{ns:file}}: | + | [[{{ns:file}}:l5_data2.png|left|link={{filepath:l5_data2.png}}|Actionbar]] |
<br clear=all> | <br clear=all> | ||
| − | + | ===Additional Commands=== | |
| − | + | [[{{ns:file}}:l5_data3.png|left|link={{filepath:l5_data3.png}}|Additional Commands]] | |
| − | [[{{ns:file}}: | + | |
<br clear=all> | <br clear=all> | ||
| Line 47: | Line 52: | ||
!width="25%"|Menu Option | !width="25%"|Menu Option | ||
!width="75%"|More Information | !width="75%"|More Information | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|valign="top"|Refresh | |valign="top"|Refresh | ||
| Line 80: | Line 58: | ||
|} | |} | ||
| − | ''' | + | ==Tables== |
| + | Click on a table name in the '''Tables''' panel to select it and display its columns and their attributes in the lower panels. | ||
| − | + | ===Table Names=== | |
| − | [[{{ns:file}}: | + | Hover the mouse over a table name row to display information about the table: |
| + | [[{{ns:file}}:l5_data4.png|left|link={{filepath:l5_data4.png}}|Tables]] | ||
<br clear=all> | <br clear=all> | ||
| − | + | ====Instant Search==== | |
| − | + | From v5.3 the panel includes instant search. Just start typing the text you want to search for: | |
| − | + | [[{{ns:file}}:appdatatables_instantsearch1.png|left|link={{filepath:appdatatables_instantsearch1.png}}|Instant Search]] | |
| − | + | <br clear=all> | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | | | + | |
| − | | | + | |
| − | | | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | The display is updated as you type and as well as the mouse, you can also use the cursor keys and the return key to navigate and select: | |
| − | The | + | [[{{ns:file}}:appdatatables_instantsearch2.png|left|link={{filepath:appdatatables_instantsearch2.png}}|Instant Search]] |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | [[{{ns:file}}: | + | |
<br clear=all> | <br clear=all> | ||
| − | + | ====Actionbar==== | |
| − | + | ||
From the actionbar you can: | From the actionbar you can: | ||
* Create a '''New''' table. This will open the [[Creating_a_database_and_its_tables#Create_a_Table|CREATE A TABLE dialog]]. | * Create a '''New''' table. This will open the [[Creating_a_database_and_its_tables#Create_a_Table|CREATE A TABLE dialog]]. | ||
* '''Delete''' the currently selected table. You will be prompted to confirm the operation. | * '''Delete''' the currently selected table. You will be prompted to confirm the operation. | ||
| − | |||
* Access '''Additional Commands''' by clicking the cog button. | * Access '''Additional Commands''' by clicking the cog button. | ||
| − | [[{{ns:file}}: | + | [[{{ns:file}}:l5_data5.png|left|link={{filepath:l5_data5.png}}|Actionbar]] |
<br clear=all> | <br clear=all> | ||
| − | + | ====Additional Commands==== | |
| − | + | [[{{ns:file}}:l5_data6.png|left|link={{filepath:l5_data6.png}}|Additional Commands]] | |
| − | [[{{ns:file}}: | + | |
<br clear=all> | <br clear=all> | ||
| Line 168: | Line 91: | ||
!width="25%"|Menu Option | !width="25%"|Menu Option | ||
!width="75%"|More Information | !width="75%"|More Information | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
|valign="top"|Refresh | |valign="top"|Refresh | ||
| Line 205: | Line 97: | ||
|} | |} | ||
| − | ''' | + | ===Column Names=== |
| + | The middle panel in the '''Names''' tab displays the columns from the currently selected table. Double-click on a column name to open it in the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|Table Designer]] ('Modify a Column' dialog prior to v6.3) so you can modify its definition and/or attributes. | ||
| − | [[{{ns:file}}: | + | Hover the mouse over a column name row to display information about the column: |
| + | [[{{ns:file}}:l5_data7.png|left|link={{filepath:l5_data7.png}}|Column Names]] | ||
<br clear=all> | <br clear=all> | ||
| − | + | ====Instant Search==== | |
| − | + | From v5.3 the panel includes instant search. Just start typing the text you want to search for: | |
| − | + | [[{{ns:file}}:appdatacolumns_instantsearch1.png|left|link={{filepath:appdatacolumns_instantsearch1.png}}|Instant Search]] | |
| − | + | <br clear=all> | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | | | + | |
| − | | | + | |
| − | | | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | The display is updated as you type and as well as the mouse, you can also use the cursor keys and the return key to navigate and select: | |
| − | + | [[{{ns:file}}:appdatacolumns_instantsearch2.png|left|link={{filepath:appdatacolumns_instantsearch2.png}}|Instant Search]] | |
| − | The | + | |
| − | + | ||
| − | + | ||
| − | [[{{ns:file}}: | + | |
<br clear=all> | <br clear=all> | ||
| − | + | ====Actionbar==== | |
| − | + | ||
From the actionbar you can: | From the actionbar you can: | ||
| − | * Create a '''New''' column. This opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns| | + | * Create a '''New''' column. This opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|Table Designer]] ('Create a Column' dialog prior to v6.3). |
| + | * '''Edit''' the currently selected column. This opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|Table Designer]] ('Modify a Column' dialog prior to v6.3). | ||
* '''Delete''' the currently selected column. You will be prompted to confirm the operation. | * '''Delete''' the currently selected column. You will be prompted to confirm the operation. | ||
| − | |||
* Open the '''MetaData editor''' for the currently selected column. See [[MetaData Editor]] for information. | * Open the '''MetaData editor''' for the currently selected column. See [[MetaData Editor]] for information. | ||
* Access '''Additional Commands''' by clicking the cog button. | * Access '''Additional Commands''' by clicking the cog button. | ||
| − | [[{{ns:file}}: | + | [[{{ns:file}}:l5_data8.png|left|link={{filepath:l5_data8.png}}|Actionbar]] |
<br clear=all> | <br clear=all> | ||
| − | + | ====Additional Commands==== | |
| − | + | [[{{ns:file}}:l5_data9.png|left|link={{filepath:l5_data9.png}}|Additional Commands]] | |
| − | [[{{ns:file}}: | + | |
<br clear=all> | <br clear=all> | ||
| Line 298: | Line 133: | ||
|- | |- | ||
|valign="top"|Modify | |valign="top"|Modify | ||
| − | |valign="top"|Opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns| | + | |valign="top"|Opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|Table Designer]] ('Modify a Column' dialog prior to v6.3) for the currently selected column. |
|- | |- | ||
|valign="top"|MetaData editor... | |valign="top"|MetaData editor... | ||
| Line 308: | Line 143: | ||
|} | |} | ||
| − | + | ===Column Attributes=== | |
| − | + | ||
The bottom panel in the '''Names''' tab displays the definition and optional attributes for the currently selected column. | The bottom panel in the '''Names''' tab displays the definition and optional attributes for the currently selected column. | ||
| − | [[{{ns:file}}: | + | [[{{ns:file}}:l5_data10.png|left|link={{filepath:l5_data10.png}}|Data Files Tab: Column Attributes]] |
<br clear=all> | <br clear=all> | ||
| − | + | ====Actionbar==== | |
| − | + | ||
From the actionbar you can: | From the actionbar you can: | ||
| − | * Create a '''New''' column. This opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns| | + | * Create a '''New''' column. This opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|Table Designer]] ('Create a Column' dialog prior to v6.3). |
| − | * '''Edit''' the currently selected column. This opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns| | + | * '''Edit''' the currently selected column. This opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|Table Designer]] ('Modify a Column' dialog prior to v6.3). |
* '''Delete''' the currently selected column. You will be prompted to confirm the operation. | * '''Delete''' the currently selected column. You will be prompted to confirm the operation. | ||
* Navigate between the columns. | * Navigate between the columns. | ||
* Access '''Additional Commands''' by clicking the cog button. | * Access '''Additional Commands''' by clicking the cog button. | ||
| − | [[{{ns:file}}: | + | [[{{ns:file}}:l5_data11.png|left|link={{filepath:l5_data11.png}}|Actionbar]] |
<br clear=all> | <br clear=all> | ||
| − | + | ====Additional Commands==== | |
| − | + | [[{{ns:file}}:l5_data12.png|left|link={{filepath:l5_data12.png}}|Additional Commands]] | |
| − | [[{{ns:file}}: | + | |
<br clear=all> | <br clear=all> | ||
| Line 336: | Line 168: | ||
|- | |- | ||
|valign="top"|Modify | |valign="top"|Modify | ||
| − | |valign="top"|Opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns| | + | |valign="top"|Opens the [[Creating_a_database_and_its_tables#Create_and_Modify_Columns|Table Designer]] ('Modify a Column' dialog prior to v6.3) for the currently selected column. |
|- | |- | ||
|valign="top"|Refresh | |valign="top"|Refresh | ||
| Line 342: | Line 174: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==See Also== | ==See Also== | ||
Latest revision as of 05:46, 7 December 2021
The App Inspector
The App Inspector display changes based on the current workspace, showing tabs relevant to that workspace.
Clicking the small icon on the far right of the App Inspector title bar will detach it into its own floating window.
Double clicking the window title bar when it is floating will attach it back into place.
The Data Tab
The Data Tab contains file lists for the current App's data files. It appears in the App Inspector when the Pages Workspace is active.
Databases
The Databases tab contains the Database Names panel with a list of available databases.
Note: opening a database is not available when the App already has an associated database.
Pro Tip
If you have a project open you will only see the databases that have been added to that project.
Instant Search
From v5.3 the panel includes instant search. Just start typing the text you want to search for:
The display is updated as you type and as well as the mouse, you can also use the cursor keys and the return key to navigate and select:
Actionbar
From the actionbar you can:
- Create a New database. This option is not available when the App already has an associated database.
- Delete the currently selected database. This option is not available when an App is open.
- Open the MetaData editor for the currently selected database. See MetaData Editor for information.
- Access Additional Commands by clicking the cog button.
Additional Commands
| Menu Option | More Information |
|---|---|
| Refresh | Refreshes the database panel. |
Tables
Click on a table name in the Tables panel to select it and display its columns and their attributes in the lower panels.
Table Names
Hover the mouse over a table name row to display information about the table:
Instant Search
From v5.3 the panel includes instant search. Just start typing the text you want to search for:
The display is updated as you type and as well as the mouse, you can also use the cursor keys and the return key to navigate and select:
Actionbar
From the actionbar you can:
- Create a New table. This will open the CREATE A TABLE dialog.
- Delete the currently selected table. You will be prompted to confirm the operation.
- Access Additional Commands by clicking the cog button.
Additional Commands
| Menu Option | More Information |
|---|---|
| Refresh | Refreshes the Table Names panel. |
Column Names
The middle panel in the Names tab displays the columns from the currently selected table. Double-click on a column name to open it in the Table Designer ('Modify a Column' dialog prior to v6.3) so you can modify its definition and/or attributes.
Hover the mouse over a column name row to display information about the column:
Instant Search
From v5.3 the panel includes instant search. Just start typing the text you want to search for:
The display is updated as you type and as well as the mouse, you can also use the cursor keys and the return key to navigate and select:
Actionbar
From the actionbar you can:
- Create a New column. This opens the Table Designer ('Create a Column' dialog prior to v6.3).
- Edit the currently selected column. This opens the Table Designer ('Modify a Column' dialog prior to v6.3).
- Delete the currently selected column. You will be prompted to confirm the operation.
- Open the MetaData editor for the currently selected column. See MetaData Editor for information.
- Access Additional Commands by clicking the cog button.
Additional Commands
| Menu Option | More Information |
|---|---|
| Modify | Opens the Table Designer ('Modify a Column' dialog prior to v6.3) for the currently selected column. |
| MetaData editor... | Opens the MetaData editor for the currently selected column. See MetaData Editor for information. |
| Refresh | Refreshes the Column Names panel. |
Column Attributes
The bottom panel in the Names tab displays the definition and optional attributes for the currently selected column.
Actionbar
From the actionbar you can:
- Create a New column. This opens the Table Designer ('Create a Column' dialog prior to v6.3).
- Edit the currently selected column. This opens the Table Designer ('Modify a Column' dialog prior to v6.3).
- Delete the currently selected column. You will be prompted to confirm the operation.
- Navigate between the columns.
- Access Additional Commands by clicking the cog button.
Additional Commands
| Menu Option | More Information |
|---|---|
| Modify | Opens the Table Designer ('Modify a Column' dialog prior to v6.3) for the currently selected column. |
| Refresh | Refreshes the Column Attributes panel. |
