Why the following object function doesn't work when called in a trigger?

Dec 16, 2024 8:00PM

Hi,

When I am fetching deal records to update status:

166 count of records fetched when -> object function script is pasted inside trigger

0 count of records fetched when -> function is called inside trigger, ex. ObjFunction()

***************************************************************************************************************

Script:
def vo = newView('DealVO')
def criteria = vo.createViewCriteria();
def criteriaRow = criteria.createRow();

def criteriaItem1 =criteriaRow.ensureCriteriaItem('StatusCode');
criteriaItem1.setOperator('=');
criteriaItem1.setValue('ORA_DRAFT');

criteria.insertRow(criteriaRow);
vo.appendViewCriteria(criteria);

vo.executeQuery();
def count= vo.getEstimatedRowCount()

println("count: " + count)

***************************************************************************************************************

Thanks,

Anuj