On August 11, 2023, Cisco announced that Cisco SecureX will go end-of-life on July 31, 2024. The content in this Github repository will not be actively maintained following this announcement.

Select from Table

Category: Table

This activity allows you to select rows from a table. To use this activity, you need to provide:

  1. An input table to select rows from.
  2. Criteria for selecting rows.
  3. Which columns you want to select.
  4. How many rows to select.
  5. (Optional) Sorting options.

In the Select section of the activity’s properties, you configure all of these items. We’ll cover this section in two parts. This sample shows selecting rows from a table where their id equals 3. For each matching row, all columns are being selected.

The next section is where we define how many rows to select and provide sorting options. In this sample, we’re selecting up to 5 rows and sorting by the id column in ascending order:


Writing a Where Clause

See the Where Clauses page.


Hints

  • If this activity isn’t letting you select the table you want, check that the activity creating the table has Persist Table checked on its properties.

Sample Workflows

The following sample workflows are available in our repository’s workflows folder to help you get familiar with this activity. These can be imported using the instructions here or you can view the workflow in GitHub by clicking on it.