Finders

Lists finder names and attributes for manufacturing views to streamline 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 the finder functionality is defined.
FinderName	String	The name of the finder, representing the search or query functionality within the view.
AttributeFinderColumn	String	The name of the column in the view that is used as a searchable attribute by the finder.
Type	String	The data type of the finder attribute, such as 'string', 'integer', or 'decimal'.