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


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.