Programmatically sorting the data of View Object in Oracle ADF


To Programmatically sort the data of View Object in Oracle ADF, use the following steps:


  • Open the Java Section of your View Object and Generate the View Object class by checking the below check boxes.


  • Above steps will create a Java File for your view object (Employees_VOImpl in our case)
  • Checking the option "Include bind variable accessors" will create getter & setter methods for each attribute of your view object
  • Now go to this java file and write the below code in the constructor of the class

package model.BussinessComponents.ViewObjects;

import oracle.jbo.SortCriteriaImpl;
import oracle.jbo.ViewObject;
import oracle.jbo.server.ViewObjectImpl;

public class Employees_VOImpl extends ViewObjectImpl {
    /**
     * This is the default constructor (do not remove).
     */
    public Employees_VOImpl() {
    
        this.setProperty(ViewObject.PROP_ALWAYS_USE_SORT, "true");
        SortCriteriaImpl[] sortCriteria =new SortCriteriaImpl[] 
                                        { new SortCriteriaImpl("FirstName",false) };
                 this.setSortCriteria(sortCriteria);

    }
}
  • Here we have used the below constructor of the SortCriteriaImpl class:

      public SortCriteriaImpl(java.lang.String attribute_name, boolean is_sort_desc)


So, new SortCriteriaImpl("FirstName",false) means that we are sorting the view object with Attribute "FirstName" and in Ascending order (since, is_sort_desc is false). Attribute name is case sensitive, so be careful.



That's it!
Now your view object will be sorted according to FirstName attribute in ascending order.

Comments

All Categories

Call Fusion BIP Report2 Change Password1 Code Combinations2 Compute Instance2 CTE1 Customer1 Data Aggregation2 Database5 Date Conversion1 DB Adapter2 Decryption1 Development1 EBS4 Encryption1 ESS Jobs3 Examine1 FBDI3 Fusion APIs1 Fusion BIP7 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 Legal Entity1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 Networking1 NVL2 NVL in OIC2 OCI11 OCI Billing1 OCI Compute5 OCI Cost Management1 OCI Events Service1 OCI Free Tier3 OCI Notifification Service1 OCI Security3 OIC4 OIC Mapper2 Oracle26 Oracle ADF17 Oracle APEX1 Oracle Apps59 Oracle Apps R126 Oracle ATP1 Oracle BIP8 Oracle Cloud12 Oracle Cloud Free Tier1 Oracle cloud Infrastructure9 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB4 oracle ebs5 Oracle ERP4 Oracle ERP Adapter2 Oracle ERP Cloud7 Oracle financials2 Oracle Forms1 Oracle Fusion57 Oracle Fusion BIP4 Oracle Fusion ERP17 Oracle Fusion Financials18 Oracle Integration Cloud3 Oracle OAF17 Oracle OCI14 Oracle OIC22 Oracle SOA 12c10 Oracle SQL17 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Payables2 Payables Import1 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST4 Security List1 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL16 SQL Functions3 SQL Queries14 SQL Query8 SQL Tips3 SSH1 TCA1 Value Sets1 VBCS1 Virtual Machine2 Virtual Machines1 XML1 XSLT1
Show more