Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# Table Iterator

A table iterator is used when you have created a table object and you have to iterate over all the rows or a specific subset of the rows in the table.

You can create a table iterator to query the contents of the table and then iterate over the query results. Using a NULL filter string when creating the table iterator returns all the rows of the table. Providing a non-NULL filter string when creating a table iterator controls the rows of a table that are included in the query results for the iterator.

The filter string format follows the syntax of the WHERE clause of a SQL SELECT statement excluding the WHERE keyword as shown in the following example:

    column_name > 100

When applied to a row of the table, the filter string results in a boolean value indicating whether a row must be included in the results of a query. See The WHERE Clause.

The results of a query using a table iterator contain all columns of a table rather than a subset of specific columns. That is, all queries using a table iterator implicitly begin with `SELECT * FROM table_name WHERE`. Nonetheless, the programs do not specify this string. They only specify the filter that would follow the WHERE keyword.

Application programs cannot influence the order of the results.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.