CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

Finders

Lists finder names and their attributes for specific views, aiding in view management.

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 view from which the finder is being queried. This helps identify the specific database view in which the finder functionality is applied.
FinderName String The name of the finder being used or referenced. This typically refers to a specific search or lookup tool associated with the view.
AttributeFinderColumn String The name of the attribute within the finder that is being used to filter or search for specific data. This column is key to identifying what is being searched.
Type String The datatype of the finder attribute, indicating the kind of data (for example, string, integer, date) that the attribute represents. This ensures the proper handling and comparison of data types during searches.

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