Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Groovy Query using DCL field — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Groovy Query using DCL field

Received Response
13
Views
2
Comments
edited Feb 18, 2021 3:58PM in Sales 2 comments

Content

I'm trying to query a record and pull the value of a field from another object using DCL field on ensureCriteriaItem. The DCL is the only field that I can use to find the correct record. I was able to query/find the record successfully but the performance is very slow. I added getEstimatedRowCount and println to show the number of records found in the query and got surprise because the count is more than 2000 records. Is it because I'm using a DCL field on my query?

 

vci = vcr.ensureCriteriaItem('DCL Field');
vci.setOperator('=');
vci.setValue(Record Number);

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!