ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

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

Columns

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175