Creating Column Filter on a VBCS Table using ListDataProvider(LDP)

 In this blog we will create filter functionality for a table using ListDataProvider (LDP).

  • Create an ADP based Table in VBCS based on any Data Source
    • For this example, I will use a JSON file as Data Source and create an ADP based table for the same

  • Create textboxes on top of columns which will act as filters for the columns
    • Create 5 textboxes on top of each column to act as filters

    • Create searchObject variable and map all filter text values to it

  • Convert the ADP to ListDataProviderView
    • Create function to convert ADP to ListDataProviderView

    • Call custom function getListViewProvider , it takes a custom ADP and filter Criteria as parameters, on Page all data are shown hence filter criteria passed will be null
    • Call on vb-Enter event and assign the same to oj-table data



  • Assign a single value change event for all the filter fields
  • Call custom function getFilterCriterion to get filter criteria for ListDataProviderView


  • Filter the ListDataProviderView based on the filter criteria

  • Run the Ui to see if Filter search is working for all fields or not

Comments

Post a Comment

Popular posts from this blog

Mavenize an Oracle ADF Application

Image
To Mavenize an Oracle ADF Application first step would be to Setup Maven in Jdeveloper after this we Mavenize Oracle ADF Application . Follow below steps to Setup Maven in Jdeveloper 1.> Navigate to Tools > Preferences > Maven > Settings 2.> Get user settings file path - For me it is : C:\Users\username\.m2\settings.xml 3.> Navigate to path and modify settings file server tag as below  <servers>     <server>     <id>maven.oracle.com</id>     <username>OracleUserName</username>     <password>OraclePwd</password>     <configuration>       <basicAuthScope>         <host>ANY</host>         <port>ANY</port>         <realm>OAM 11g</realm>       </basicAuthScope>       <httpConfiguration>       ...
Read more

Using Custom Colors in Sunburst Chart

Image
 In  Previous blogs we have created Sunburst Chart, now we will try to add custom color to the same Create VBCS App with Sunburst Chart Create a Global array and provide it custom rgb color palette values. Now create a custom function which will return an array value randomly or based on any custom logic, for this example i will be passing the color based on the node’s id value. Replace the old function with the newly created one Now you can see custom colors as per our logic and also these colors will remain static and will not change every time the ui is opened.
Read more