Finders

Displays available finder functions and their queryable attributes for different views, aiding in data retrieval and analysis.

ViewName is required to get the mapping FinderName and finder parameter column.

The ViewName column supports = and IN operators

SELECT * FROM Finders WHERE viewname = 'Invoices'
SELECT * FROM Finders WHERE viewname IN ('Invoices','InvoicesinvoiceLines')

Columns


Name	Type	Description
ViewName	String	Name of the view for which the finder is used, specifying the data context in which the finder operation is performed.
FinderName	String	Name of the finder, used to identify and reference a specific search function or query operation within the system.
AttributeFinderColumn	String	Name of the specific attribute within the finder, used to identify which column or data point the search function is applied to.
Type	String	Datatype of the finder attribute, specifying the data type (for example, string, integer, date) for the attribute being searched in the view.