Posts

Sometimes we need to filter uncommitted records and query based bind variable or setWhereClause method doesn’t do the job in that case as it requeries viewObject and filters committed records only

So for this type of requirement we can use view criteria. View criteria works on basis of it’s query execution mode

By default it is set to Database only and we can change it to Memory (In-Memory filtering only) and both (DB and In-Memory filtering)
Here In-Memory filtering means rows that are not commited yet also get filtered

Here we’ll see how view criteria query execution mode works, I have created a viewCriteria on Departments view object

Dropped Departments viewObject as table and form on page, createInsert operation as button and a button to filter Departments viewObject using this view criteria (viewCriteria is applied on viewObject at AM level)

Now I added a new row in table for Locaion Id 555 , it is not committed and after click on Execute View Critera button we can see that it is appearing with filtered DB rows .
As Query Execution mode is Database so it doesn’t filter uncommitted rows that’s why location id 555 is appearing in record set

Now to filter In-Memory rows too, I have changed query execution mode to both and see the output

So this is how we can use ViewCriteria for In-Memory filtering of rowsSample ADF Application- DownloadCheers 🙂 Happy Learning

Hey Friend! Thanks for visiting our site We have detected that you are using AdBlock and we understand your concern but for keeping up this website we need to show some beautifully placed ads. I hope you understand that and support us by disabling AdBlock on this site. Please disable AdBlock in the browser and reload this page to visit my website.&nbsp&nbsp&nbsp&nbsp

We use cookies on our website to help us offer you best online experience Find out more.