Example: Using the Select Panel Template Tab

This example shows how to use the Select panel Template tab to make selections in various ways.

 

We will work with the Customers table from the ubiquitous Nwind example database.

 

i_tblsd01_01.png

 

Open the Customers table.

 

i_tblsd01_02.png

 

Click the Contents pane tab and then choose the Select panel.   By default it opens with the Template tab active.

 

i_tblsd01_03.png

 

Scroll down through the list of templates and click the Text Contains template command.  We can make it easier to find a template by entering text into the Filter box, so only those templates with the string text (case not significant) are shown.  Combo boxes appear to allow us to choose a field and a value to search for.    

 

i_tblsd01_04.png

 

The Value box pull down menu is loaded with the field names in the Customers table.   Choose the Contact Name field and begin editing the 'abc' initial template in the Search for box by replacing it with 'A'.

 

i_tblsd01_05.png

 

The moment we enter the A character the table immediately begins showing a preview of what would be selected.  It immediately changes the background color to blue preview color for records that would be selected by the criterion that their Contact Name field should contain the letter A.

 

i_tblsd01_06.png

 

We continue to alter the value to search for by adding an n character to make it 'An'.     

 

i_tblsd01_07.png

 

That reduces the number of records the preview shows will be selected.  

 

i_tblsd01_08.png

 

To select those records we press the Replace Selection button at the bottom of the Select dialog.

 

i_tblsd01_09.png

 

The table shows the selected records in red selection color.    The template choice in the Select panel jumps to (no action).

 

i_tblsd01_10.png

 

Next we will once again choose the Text Contains  template.  This time we will amend the selection for which our Text Contains template searches by choosing the Company Name field for the Value box and entering 'Tru' as the value to search for.   

 

i_tblsd01_11.png

 

As before, the resulting selection is previewed in the table.  It appears in a tinted blue color that is a blend of the red selection color and the blue preview color, since the record being previewed was also already selected.

 

i_tblsd01_12.png

To remove previewed records from the selection we first choose Subtract from Selection for the command button.   

 

i_tblsd01_13.png

 

We then click Subtract from Selection.

 

i_tblsd01_14.png

 

The record with Tru in the company name is subtracted from the selection.   The Select panel's template list is reset to (no action).  

The (no action) Template

Templates in the Select panel automatically use blue preview color to show what they do.   To avoid any previews we can choose the (no action) template.

 

i_tblsd01_15.png

 

Suppose we choose the Text Starts with template using a Search for value of 'B' to find all company names that start with B.

 

i_tblsd01_16.png

 

The table automatically shows a preview using blue preview color.

 

i_tblsd01_17.png

 

If we choose the (no action) template we will have no preview.  The (no action) template is available regardless of the Filter box text.

 

i_tblsd01_18.png

 

That will show the table without any previewing in blue preview color.

 

See Also

Selection

 

Contents Pane

 

Contents - Select

 

Example: Using the Select Panel Saved Tab - How to save selections and then use them later.

 

Example: Construct JSON String using Select and Transform - Use the  Select panel and Transform panel to manually construct a JSON string using values from other fields in a table. Shows how we can manipulate text to build desired contents in a field.