Finders

Lists finder names and their attributes for easier query generation and 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')


Name	Type	Description
ViewName	String	The name of the database view for which a finder needs to be identified. This view acts as a virtual table that represents a predefined query, often used for reporting or providing structured access to underlying data.
FinderName	String	The name of the finder, which is a predefined query or search mechanism associated with the view. Finders are used to retrieve specific subsets of data based on filtering criteria, improving efficiency in data retrieval operations.
AttributeFinderColumn	String	The name of the attribute within the finder that is used for searching or filtering data. This column defines which field is used as a lookup parameter when executing the finder query.
Type	String	The data type of the attribute within the finder. This data type specifies how the attribute is stored and processed, ensuring correct comparisons and query performance when filtering data using the finder mechanism.