Groovy Query using DCL field
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);
Tagged:
0