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 Custom Images1 Customer1 Data Aggregation2 Database5 Date Conversion1 DB Adapter2 Decryption1 Development1 EBS5 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 OCI13 OCI Billing1 OCI Compute6 OCI Cost Management1 OCI Events Service1 OCI Free Tier3 oci networking1 OCI Notifification Service1 OCI Security3 OIC4 OIC Mapper2 Oracle26 Oracle ADF17 Oracle APEX1 Oracle Apps60 Oracle Apps R127 Oracle ATP1 Oracle BIP8 Oracle Cloud13 Oracle Cloud Free Tier1 Oracle cloud Infrastructure10 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB4 oracle ebs6 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 OracleCloudTutorial1 Others10 Payables2 Payables Import1 Programs1 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 vcn1 Virtual Machine2 Virtual Machines1 XML1 XSLT1
Show more