Auto List

The Auto List control in the Pane Designer inserts a list box where the end-user can enter a value to filter the list. An Auto List control displays a list when the end-user clicks on the arrow to the right in the control, but the user can also enter a value directly in the list control to directly filter the values in the list. When the Auto List control is selected in the ribbon, it is inserted below the actual pane area. The user can then drag the list to the desired place in the pane.

There are two differences between the List control and the Auto List control:

1. The List control has a multi-select option. Only one value can be returned in the Auto List control.
2. In the List control, the end-user can only select values from a list. In the Auto List control, the user can enter a value to directly filter the values in the list or to enter the correct value directly without having to select anything from the list.

The following properties can be changed for the Auto List control: (these sections can be found in the Art Board to the right in the Pane Designer)

• Brushes

• Layout

• Common Properties

• Text

Brushes

Change the color of the auto list box by using the brush in the art board. Changing color can be done in two ways:

• Dragging the marker in the brush area to the desired color.
• Entering a specific # color code in defined area.

Layout

• Width: Can be changed in the art board or by dragging the bottom-right corner of the control to the right width.

• Height: Can be changed in the art board or by dragging the bottom-right corner of the control to the right height.

• Enabled : Should the control be enabled or disabled?

• Opacity

• Hidden: Should the control be visible for end-users?

You can also view the position of the box in the Layout section. View the X and Y position by dragging the control to desired position. When positioning many controls in a pane, it is a good idea to view the X position of the controls to make sure that they are positioned straight under each other.

Use the "Snap to Grid" feature for the pane to allow more precision when positioning the controls.

Common Properties

Control Tag

The controls in the pane for which values should be sent into the generated document need to be named with a control tag. The control tag ID will then be matched to the tags defined in the Pane worksheet in the template. In column B and C for the matched control tag, the selected value from the selection pane will be inserted in the Pane worksheet.

Tooltip

Enter a tooltip that will display for the end-user when hovering over the Auto List control in the selection pane:

Mandatory

Check the box if a selection/value in the Auto List is mandatory.

Get Latest Value

Check the box if you want the control to always automatically return the latest selected value. If the control also has a default procedure connected, the auto_get_latest setting will override the default value for the particular control.

Dropdown Height

Enter a specific dropdown height. Default height is 130. In other words, how large should the list be when clicking on the list (how many rows should be visible without a scroll bar being created)?

Below is an example of a list with the default dropdown height of 130 (6 rows will be visible):

Below is an example of a list with the dropdown height of 250:

Filter Mode

Select which filter mode should be applied for the Auto List. Filter mode defines how the list should be filtered when an end-user starts entering a value in the list box.

Begins with:

The values in the list begins with the value(s) entered by the end-user in the list.

Example: 10 is entered by the end-user and the list will be filtered with values starting with 10:

Contains

The values in the list contains the value(s) entered by the end-user in the list.

Example: G is entered by the end-user and the list will be filtered with values containing the letter g:

Script

The Auto List must be connected to a script. Some standard script are included in the Bizview application. For example, p_pane_objlist (object values) and p_pane_timelist (time values). Additionally, there is a possibility to write your own scripts (SQL queries) that can be connected to the list. Custom scripts should be written in DB Sharp Studio or SQL manager and saved with a name starting with s_pane_<xxxx> (scripts) or p_pane_<xxxx> (procedures in SQL manager). If the script/procedure is saved with a name starting with s_pane_ or p_pane_, then it will be visible in the Scripts list in Pane Designer:

When a script is selected, then a new section for any necessary input parameters displays:

For more information about the input parameters in dat.p_pane_objlist and how to setup dependent list boxes, see p_pane_objlist.

Default Value

In addition to connecting the list to a script, there is also a possibility to connect it to a script that defines default values for the list. If any parameters are necessary to define, then these will be visible below the "Default value(s)" list box:

For more information about this feature, see Default Values in Pane.

Text  

• Font: The default font is Verdana. To change the font, select one from the list.

• Size: The default size is 11. To change the size, enter another size in the text box.

• Bold

• Italic

• Underline