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!