Finders
Lists view finder names along with associated attributes for efficient querying.
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 applied, helping to identify the view related to the search or lookup process. |
FinderName | String | The name of the specific finder being used, which is associated with retrieving or searching data based on the view and its attributes. |
AttributeFinderColumn | String | The name of the column in the finder that represents the attribute being searched, helping to specify which field to search within the view. |
Type | String | The data type of the attribute in the finder column, indicating the kind of data (for example, string, integer) being handled for search purposes. |