Finders
Lists finder names and associated attributes for specific views, aiding in efficient data retrieval.
SELECT
ViewName is required to get the mapping FinderName and finder parameter column.
The ViewName column supports = and IN operators
SELECT * FROM Finders where viewname = 'abc' SELECT * FROM Finders where viewname IN ('abc','pqr')
Columns
Name | Type | Description |
ViewName | String | The name of the database view for which the finder is being identified. |
FinderName | String | The name of the finder used to locate specific records within the view. |
AttributeFinderColumn | String | The name of the attribute used as a search parameter in the finder. |
Type | String | The data type of the finder attribute. |