Implement contains/endswith behavior in model based autoSuggest Lov (Input list and combo box)

Hello All

Hope Everyone knows about list of values and autoSuggest beahvior of ADF Framework,
For those who are new to framework can look at this post
ADF Basics : Implementing auto suggest behavior in ADF Faces lov (list of values)

ADF Basics: Tip for not showing record in dependent lov

Hello All

Recently I have seen a question on OTN forum - Question on cascading LOV

It was about cascading lovs in ADF
Suppose we have 2 dependent LOVs and requirement is that 2nd lov should not show any data until first one is selected , this is very simple and common use case but for beginners it's a tedious task

So I thought to write it here to help others

ADF Basics: Use transient attribute to show description of selected value in case of input and combo Lov

In ADF often We apply LOV on a ID attribute to show it's Description to user, This works good in case of choice list (selectOneChoice) but if we use Input Text with List of Values (<af:inputListOfValues>) or Combo Box with List of Values (<af:inputComboboxListOfValues>) then after selection ID appears on page instead of  Description like this

So to avoid this we apply LOV on a transient attribute that shows Description and sets ID value DB attribute, See how to implement this

ADF Basics: Set multiple LOV's on attribute and conditionally switch using LOV Switcher

This post is about a very basic and common use case
Suppose we have to show different values in our List depending on some condition but all values must be stored in same attribute so for this type of requirement ADF BC framework provides concept of LOV Switcher
Framework allows us to define multiple LOV on same attribute, I hope you all know about defining LOV(List of Values) so move ahead and see how to use lov switcher

 See the implementation part-

• Created a Fusion Web Application and a viewObject to show LOV on viewport (Used dual to create view object for this example , you can use use your own)








• Created 2 more viewObject to apply LOV on first viewObject's attribute, One ViewObject is for Departments and other one is for Employees






• Open dual viewObject select LovAppl attribute and goto ListOfValues tab and add both LOV
  For Department - DepartmentId is List Attribute and DepartmentName will be shown on UI




For Employees- EmployeeId is List Attribute and FirstName,LastName will be shown on UI






• Now click on green plus icon of List Of Values Switcher and add a transient attribute , this will be further used to switch lov on base of some condition





• So created LovSwitcher attribute , and remember this switcher attribute value should be one of the LOV Name that are applied on attribute.
  Here i am using a condition - if LovType attribute of Dual viewObject is 'D' the LovAppl should show Departments Lov and if it is 'E' then LovAppl should show Employees Lov
  For this i have written expression for lov switcher attribute
  LovType=='D' ? 'LOV_LovAppl' : LovType=='E' ? 'LOV_LovAppl1' : null





• Now run Application Module and check it

Thanks , Happy Learning :)

ADF Basics : Implementing auto suggest behavior in ADF Faces lov (list of values)

Auto Suggest behavior is best understand by Google Instant, as in google when we type something and it starts showing suggestion instantly.

 This effect can be implemented in ADF using autoSuggestBehaviour
To use the auto-suggest functionality in a declarative way you need to define a model-driven list of values on your model project, which will be the base for the suggestedItems list. Select the Department Name attribute from the Department VO and create a List of Values. here i am using HR schema and predefined table Department to implement this

• Create a Fusion Web Application
• Now create EO and VO of Department table.(Business Components)





• Now create List of values(LOVs)on DepartmentName





• Create page in ViewController and drag the DepartmentName on page as ADF Lov ChoiceList or Lov Input
  


• Now go to Component Palette and select Auto Suggest Behaviour and drop it inside DepartmentName Lov
  
  
  
  


• Now select af:autoSuggestBehavior from Page structure and go to PropertyInspector and Open Expression Builder at SuggestedItems and select from bindings #{bindings.DepartmentName.suggestedItems} if you are using different tables and Lov select according to that








• Now run your page and enjoy autosuggest behavior (ADF Instant) 

Cheers :-) Happy Learning

Read Next Post in Series- Implement contains/endswith behavior in model based autoSuggest Lov (Input list and combo box)

Creating new object in list (af:inputListOfValues) using 'createPopupId' feature- ADF 11g & 12c

Hello All ,
This post is about a good feature provided with inputListOfValues in ADF .
inputListOfValues is used where large and complex data is populated in list, this component supports search in list values
Suppose on opening list values you want to add one more value in list generally to do that you will  close the list and add a value in source table then again open list but this feature provide instant creation of list values

this functionality can be achieved in Combo Box with List of Values using customActions facet, i have posted about it
Create new look up data using List of Values (LOVs) in Oracle ADF

so this time it is about  inputListOfValues, see the steps to do

• Created a fusion web application and business components  using Departments and Employees table of HR Schema

• now i have created list of values on DepartmentId of Employees ViewObject referenced from Department ViewObject, display type is Input Text with List of Values

•  drop Employees VO on page and run, it looks like this

• Now i have dropped a popup on page and to create new value in list, i have dropped form of Departments ViewObject and a link to create it on dialog inside popup
   
  


• select list of values component (Employee VO) in structure window and go to property inspector and set popUp id in a property called 'createPopupId'

• After setting 'createPopupId' ,on running a commandToolbarButton appears in the LOV popup dialog box with a icon, this button's action triggers custom popUp (i have added before)

        on clicking on this icon-

•  on create link i have just called createInsert for Departments ViewObject and on dialogListener , Execute



import oracle.adf.model.BindingContext;
import oracle.binding.BindingContainer;
import oracle.binding.OperationBinding;



    /**Method to get Bindings of current page
     * @return
     */
    public BindingContainer getBindings(){
        return BindingContext.getCurrent().getCurrentBindingsEntry();
    }

    /**Method to execute OperationBinding
     * @param operation
     * @return
     */
    public OperationBinding executeOperation(String operation){
        return getBindings().getOperationBinding(operation);
    }

    /**Method to create new Department
     * @param actionEvent
     */
    public void createDeptAction(ActionEvent actionEvent) {
       executeOperation("CreateInsert").execute();
    }



• now created a new department using 'create' link and you can see value is appeared in list values

 Cheers :-)

Using Multiple Selection (selectManyListbox & selectManyCheckbox component) in ADF

Hello All ,
This tutorial is based on use of selectManyListbox & selectManyCheckbox component in ADF to enable multiple selection.
Both component are same in functionality only somewhat different in look-feel.



Follow steps to use these component -

• Create a fusion web application and create business components for Departments table of HR Schema

• Now create a page and drop Departments Vo from data control on page as multiple selection (checkbox or listbox) 

• Now binding for this component is created in page-bindings, add a button on page to get total selected values
  
  
  
  
  
  

• See how to get selected values in managed bean, JUCtrlListBinding is used to get selected values



import javax.faces.event.ActionEvent;

import oracle.adf.model.BindingContext;

import oracle.binding.BindingContainer;

import oracle.jbo.uicli.binding.JUCtrlListBinding;   

 public BindingContainer getBindings() {
        return BindingContext.getCurrent().getCurrentBindingsEntry();
    }

    public void getSelectedValue(ActionEvent actionEvent) {

        JUCtrlListBinding listBindings = (JUCtrlListBinding)getBindings().get("DepartmentsView1");
        Object str[] = listBindings.getSelectedValues();
        for (int i = 0; i < str.length; i++) {
            System.out.println(str[i]);
        }
    }



• this method works for both listbox and checkbox, i have added all selected departments in a FacesMessage and displayed on page

 Select All-

 

And Check-box component look like this-

Complete code written on 'Get Selected Values' button-

    /**Method to get BindingContainer of page
     * @return
     */
    public BindingContainer getBindings() {
        return BindingContext.getCurrent().getCurrentBindingsEntry();
    }

    /**Method to get Selected Values
     * @param actionEvent
     */
    public void getSelectedValue(ActionEvent actionEvent) {

        JUCtrlListBinding listBindings = (JUCtrlListBinding)getBindings().get("DepartmentsView1");
        Object str[] = listBindings.getSelectedValues();
        StringBuilder saveMsg =
            new StringBuilder("<html><body><b><p style='color:red'>Selected Departments are-</p></b>");

        saveMsg.append("<ul>");
        for (int i = 0; i < str.length; i++) {
            System.out.println(str[i]);
            saveMsg.append("<li> <b>" + str[i].toString() + "</b></li>");
        }

        saveMsg.append("</ul><br>");
        saveMsg.append("</body></html>");
        FacesMessage msg = new FacesMessage(saveMsg.toString());
        FacesContext.getCurrentInstance().addMessage(null, msg);

    }

Cheers- Download Sample

Dynamically enable or disable items of ADF bound List (af:selectOneChoice) -Oracle ADF

Hello All,
This tutorial is about a requirement of conditionally enabling/disabling items (values) of adf bound List (af:selectOneChoice) component
here i am taking reference of default HR Schema (Departments and Location table )

See the steps-

• Create a Fusion Web Application and business components using both tables

•  Now create List of Values (Lov) on locationId of departments VO from Location VO

• Set List Attribute to LocationId and for UI city will be shown

• Now Drag Departments VO from Data Control on page as a form

•  Select LocationId list field and delete f:selectItems from it, now drag af:selectItem as child of af:selectOneChoice and surround it with af:forEach 

• Add tree binding of Location ViewObject to page bindings in order to populate list items using forEach

•  Now select af:forEach and set its property and variable name, as we have to iterate through Location VO for list items

•  Again select af:selectItem and set its value and label property using forEach variable's  

• Now run your application, and see that list box is ready with values

• Now we have to disable its values as a condition basis, i have written an Expression on af:selectItem's disabled property
  
  
  
  


• I have written condition for DepartmentId 100 and 110, see in source of page



<af:selectOneChoice value="#{bindings.LocationId.inputValue}" label="#{bindings.LocationId.label}"
                                        required="#{bindings.LocationId.hints.mandatory}"
                                        shortDesc="#{bindings.LocationId.hints.tooltip}" id="soc1"
                                        contentStyle="width:150px;color:red;">
                        <af:forEach items="#{bindings.Locations1.rangeSet}" var="list">
                            <af:selectItem label="#{list.City}" id="si1" value="#{list.LocationId}"
                                           disabled="#{ (bindings.DepartmentId.inputValue==100 and (list.LocationId==1000 || list.LocationId==1300)) || (bindings.DepartmentId.inputValue==110 and (list.LocationId==1500 || list.LocationId==1600 || list.LocationId==1700 || list.LocationId==1800 || list.LocationId==1900))}"/>
                        </af:forEach>
                    </af:selectOneChoice>



• Now value given in Expression for Location Id will be disabled for given Department
• Run your page and select DepartmentId 100 and 110 to see disabled list items

 Download Sample App Cheers :-)