Finders

Lists finder names along with associated attributes for specific views in the system.

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')


Name	Type	Description
ViewName	String	The name of the database view for which a finder function needs to be located. This name enables structured data retrieval based on predefined search criteria.
FinderName	String	The name of the finder function. This name serves as a predefined search method to efficiently filter and retrieve specific records from the associated view.
AttributeFinderColumn	String	The name of the attribute used within the finder function. This name defines the specific column that serves as a filtering criterion when executing searches.
Type	String	The data type of the finder attribute. This data type ensures proper data handling, indexing, and query optimization when performing searches within the database view.