Finders

Displays search finder names and corresponding attributes for a specific view, helping locate and filter procurement data.

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	The name of the view that the finder should search within.
FinderName	String	The name assigned to the specific finder being used.
AttributeFinderColumn	String	The name of the column in the finder that represents the attribute being searched.
Type	String	The data type of the finder attribute, specifying the kind of data it holds (for example, string or integer).