Folder browser

The folder browser allows the user to navigate a hierarchy of folders, tables, and queries from a given root folder and select any of them to get information such as the path, title, and type of the item.

Path to root folder
The root folder from which to allow browsing.
Label
The text that is displayed preceding the folder browser field.
Width of label
The number of pixels allocated for the text preceding the folder browser field.

If the text of the label is greater than the width specified, the label is truncated.

Width of input
The number of pixels allocated for the folder browser field.

If the values in the input field are greater than the width specified, the values in the field are truncated.

Width of dropdown box
The width (in pixels) of the container in which the folder browser is displayed.
Height of dropdown box
The height (in pixels) of the container in which the folder browser is displayed.
Keep open after selection?
When this option is selected, the folder browser will remain open after an item has been selected from it.
Open in the beginning?
When this option is selected, the folder browser will be displayed when the QuickApp is opened.
Close after selecting?
Show in field
Determines what is displayed in the folder browser field after a selection has been made in the folder browser.
Title
The title of the selected item is displayed in the folder browser field (e.g., "Sales Item Detail").
Path
The path of the selected item is displayed in the folder browser field (e.g., pub.demo.retail.item).
Filter entries to
Determines which items to display in the folder browser.
All
All tables, folders, and queries are displayed in the folder browser.
Tables and folders only
Only tables and folders are displayed in the folder browser. Queries are not displayed.
Tables only
Only tables are displayed in the folder browser. Folders and queries are not displayed.
Real (non-merged) tables only
Only real tables that have not been merged are displayed in the folder browser.
Real tables and folders only
Only real tables and folders are displayed in the folder browser. Queries are not displayed.
Folders only
Only folders are displayed in the folder browser. Tables and queries are not displayed.
Queries only
Only queries are displayed in the folder browser. Folders and tables are not displayed.
Non-parameterized queries only
Only queries that do not take parameters as input are displayed in the folder browser. Folders, tables, and parameterized queries are not displayed.
Accept selection of
Determines which items can be selected from the folder browser.
All
All tables, folders, and queries can be selected from the folder browser.
Tables only
Only tables can be selected from the folder browser. Folders and queries cannot be selected.
Real (non-merged) tables only
Only real tables that have not been merged can be selected from the folder browser.
Folders only
Only folders can be selected from the folder browser. Tables and queries cannot be selected.
Queries only
Only queries can be selected from the folder browser. Folders and tables cannot be selected.
Non-parameterized queries only
Only queries that do not take parameters as input can be selected from the folder browser. Folders, tables, and parameterized queries cannot be selected.
Variable for table path
The variable to hold the value of the path of the selected table, folder, or query.

You may select a variable from the dropdown, or you can create a new variable by clicking New... and entering the name in the field following the @ symbol.

Variable for table title
The variable to hold the value of the title of the selected table, folder, or query.

You may select a variable from the dropdown, or you can create a new variable by clicking New... and entering the name in the field following the @ symbol.

Variable for table type
The variable to hold the value of the type of the selected table, folder, or query.

You may select a variable from the dropdown, or you can create a new variable by clicking New... and entering the name in the field following the @ symbol.

Types can be:
  • dir (folder)
  • real (table)
  • merged (merged table)
  • view (query)
Package variable for table info
The package variable to hold the table information.

You may select a variable from the dropdown, or you can create a new variable by clicking New... and entering the name in the field following the @ symbol.

This variable will store the table information as elements in a package. The elements may be accessed via dot notation. For example, if you specified the variable @selected_table_info in the Package variable for table info field, you can access the ID of the table in the package using the notation {@selected_table_info.id}.

Package keys for the table include:
  • title (title of the item)
  • path (full path of the item)
  • id (internal identification number for the item)
  • type (type of the item)
  • owner (username of the item's owner)
  • update (date and time the item was last updated)
  • users (comma-separated list of users and groups that have access to this item)
  • sdesc (short description of the item)
  • ldesc (long description of the item)
Note: The package should be initialized using [PACKAGE_VARIABLE_NAME]="{pkg(;)}" in the <dynamic> element. For example: selected_table_info="{pkg(;)}"

For more detailed information on working with packages, see the 1010data Reference Manual.

Example

<note type="base">Applied to table: pub.demo.retail.item</note>
<dynamic selected_table_path="" selected_table_title="" selected_table_type="" selected_table_info="{pkg(;)}">
  <widget class_="browser" dropheight_="250" infovalue_="@selected_table_info" 
inputwidth_="250" keepopen_="1" label_="Select a folder:" labelwidth_="150" name="hmadded__1" 
path_="uploads" relpos_="110,89" titlevalue_="@selected_table_title" typevalue_="@selected_table_type" 
value_="@selected_table_path"/>
  <widget class_="text" name="hmadded__2" relpos_="600,100" 
text_="Selected table path: {@selected_table_path}"/>
  <widget class_="text" name="hmadded__3" relpos_="600,160" 
text_="Selected table title: {@selected_table_title}"/>
  <widget class_="text" name="hmadded__4" relpos_="600,220" 
text_="Selected table type: {@selected_table_type}"/>
  <widget class_="text" name="hmadded__5" relpos_="600,280" 
text_="Selected table ID: {@selected_table_info.id}"/>
  <widget class_="text" name="hmadded__6" relpos_="600,340" 
text_="Selected table owner: {@selected_table_info.owner}"/>
  <widget class_="text" name="hmadded__7" relpos_="600,400" 
text_="Selected table users: {@selected_table_info.users}"/>
</dynamic>