appendViewCriteria giving error

Oct 13, 2020 2:11PM

Summary

Trying to set filter condition in appendViewCriteria but it gives error

I have Cascade_c as a NUMBER field in account object and tried to filter the records in groovy based on that attribute. Below is my code

def OrgView = newView('OrganizationProfile')
OrgView.appendViewCriteria("Cascade_c = 1")

OrgView.executeQuery()

But it gives an error as oracle.jbo.expr.JIMultipleSyntaxErrors Failed to build ViewCriteria from expression "Cascade_c = 1"

Any idea what went wrong in this script?