How to find the index of a record read from a StreamBase Query Table

How to find the index of a record read from a StreamBase Query Table

book

Article ID: KB0076147

calendar_today

Updated On:

Products Versions
TIBCO Streaming -

Description

When reading from a StreamBase Query Table by specifying a Primary Key, is there a way to find the index of the returned tuple in the table?

Issue/Introduction

How to find the index of a record read from a StreamBase Query Table

Resolution

StreamBase Tables do not have a meaningful index value for what row-of-the-table the tuple came from. The result set of the query is sorted, so there is a position within-the-result-set which can be reported along with the row data using the metadata.rowNumber expression. The metadata qualifier is documented in the Help under StreamBase Documentation > Authoring Guide > Using StreamBase Operators > Using the Query Operator > The metadata Qualifier