Finders
Lists finder names and their attributes for specific views, aiding in view management.
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 view from which the finder is being queried. This helps identify the specific database view in which the finder functionality is applied. |
FinderName | String | The name of the finder being used or referenced. This typically refers to a specific search or lookup tool associated with the view. |
AttributeFinderColumn | String | The name of the attribute within the finder that is being used to filter or search for specific data. This column is key to identifying what is being searched. |
Type | String | The datatype of the finder attribute, indicating the kind of data (for example, string, integer, date) that the attribute represents. This ensures the proper handling and comparison of data types during searches. |