How to find the index of a record read from a StreamBase Query Table
book
Article ID: KB0076147
calendar_today
Updated On:
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
Feedback
thumb_up
Yes
thumb_down
No