Can a Capture Database Lookup Perform a Search for Values Between two Values? (Doc ID 1385134.1)

Last updated on JUNE 30, 2016

Applies to:

Oracle WebCenter Capture 10g - Version 10.1.3.3.0 and later
Oracle WebCenter Distributed Capture - Version 10.1.3.3.0 and later
Information in this document applies to any platform.

Goal

Is it possible in WebCenter Capture (formerly Oracle Document Capture) to have a database lookup perform a search using multiple search fields (e.g. SELECT * FROM Vendors WHERE VendorID = '12345' and SiteID = '6789')?  If a value was supplied in the VendorID field as well as the SiteID field in Capture, the database lookup would perform the query listed on both the VendorID and SiteID fields.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms