ADF : Filter View Object Rows

In this post I explain how to filter rows in ViewObject and RowSetIterator.
Primarily, filter the rows means return a set of rows from ViewObject or RowSetterator according specific criteria which is filtered in memory only.

1- Filter ViewObject

     //Get ViewObjectImpl object  
     ViewObjectImpl vo = getDeptVO();  
       
     //Filter using specific attribute value  
     Row[] filteredRows = vo.getFilteredRows("AttributeName", "AttributeValue");  
   
     //Filter using RowQualifier Class  
     //Use RowQualifier if you have more than one condition in filtering rows  
     RowQualifier rowQualifier = new RowQualifier(vo);  
     rowQualifier.setWhereClause("AttributeName=AttributeValue");  
     filteredRows = vo.getFilteredRows(rowQualifier);

2- Filter RowSetIterator

     //Get ViewObjectImpl object  
     ViewObjectImpl vo = getAllAdvisorView();  
          
     //Get RowSetIteratorImpl object  
     RowSetIterator rsIterator=vo.createRowSetIterator(null);  
       
     //Filter using specific attribute value  
     Row[] filteredRowsRSI = rsIterator.getFilteredRows("AttributeName", "AttributeValue");

Thanks

Popular posts from this blog

ADF : Get Current Logged User Name

Sometime we need getting current authenticated user name in ADF application.
To get user name we can do it using three ways

1- Using Groovy  We can set default expression in view object attribute as below
adf.context.securityContext.getUserPrincipal().getName()  or adf.context.securityContext.getUserName() 

2- Java Code You can get User Name in Java code also using the following code.

ADFContext adfCtx = ADFContext.getCurrent(); SecurityContext secCntx = adfCtx.getSecurityContext(); String user = secCntx.getUserPrincipal().getName(); String _user = secCntx.getUserName();
3-Expression Lnagugae You can bind ADF Faces componenets with the following EL to get logged User Name.

#{securityContext.userName}
Thanks
Read Entire Post <<<<< Click Here >>>>>

OAF : Get Current Row in Table

Sometimes you want to get current row in table. To apply this you can use the following code in controller and write it inside processFormRequest method.

    public void processFormRequest(OAPageContext pageContext,                                    OAWebBean webBean) {         super.processFormRequest(pageContext, webBean);         //Get application Module         OAApplicationModule am = pageContext.getApplicationModule(webBean);                 //Get Row Refrence         String rowReference =             pageContext.getParameter(EVENT_SOURCE_ROW_REFERENCE);                     //Get current Row using Row Reference            OARow currRow = (OARow)am.findRowByRef(rowReference);                 //Get attribute value from current row         String attrValue = (String)currRow.getAttribute("AttrName");     }

Thanks
Read Entire Post <<<<< Click Here >>>>>

ADF : Working with ViewCriteria

Image
View Criteria's are additional where clause added at runtime to base View Object Query.


 Programmer can create view criteria declaratively or programatically.

1. Create View Criteria DeclarativelyOpen View Object in Edit and in "Query" tab you can click "+" add pencil to create new view criteria


2. Control View Criteria Programatically.

a- Get View Criteria from View Criteria manager within View Object and then apply it
ViewCriteria applyVC = myViewObject.getViewCriteria("MyViewCriteriaName");
myViewObject.applyViewCriteria(applyVC);
myViewObject.executeQuery();
b- Applying Multiple view Criteria's

When multiple view criteria's are applied to the view object, the view criterias gets appended or replaced depending upon the way you use applyViewCriteria API
Replacing Existing view criteria's :

myViewObject.applyViewCriteria(applyVC) or
myViewObject.applyViewCriteria(applyVC,false)
will erase all previously applied view criterias and apply the cur…
Read Entire Post <<<<< Click Here >>>>>