Skip to main content

ADF 11g: toggle operators in query component

When you use view criteria to be exposed in an <af:query/> component, it is sometimes weird that ADF allows you to change query operators. In this use case I define a view criteria using a BETWEEN clause on two dates.



When you create an <af:query/> component based on this criteria, you will see that it is rendered with operation 'between' as the selected operator. You do however have the possibility to change the operators. This actually makes no sense because you only need between.



You can change this behavior on the UI-hints tab of the view criteria editor.



When you run the application again, no operators are shown, but you can still insert two dates, still making it clear to the user that the search will be from - to.



This is a design-time solution. You can also manipulate this at run-time.

Run-time manipulation

For this you need to create the view object implementation class. In this class you then create a method that will show or hide the operators. By setting the "displayOperators" property of the view criteria, you can toggle between the show "InAdvancedMode" and show "never" mode. 
1:   public void toggleShowOperators(){  
2:    for (ViewCriteria vc:getAllViewCriterias()){  
3:       System.out.println(vc.getName());  
4:       System.out.println("displayOperators before change " + vc.getProperties().get("displayOperators"));  
5:     if (vc.getProperties().get("displayOperators")=="InAdvancedMode"){  
6:       vc.setProperty("displayOperators", "never");    
7:     }else  
8:     {  
9:      vc.setProperty("displayOperators", "InAdvancedMode");    
10:     }   
11:      System.out.println("displayOperators after change  " + vc.getProperties().get("displayOperators"));  
12:    }    
13:   }


You publish this method to the client and drop it as an <af:commandToolbarButton/> on your page. Last thing is to set partialSubmit attribute of the button and the partialtriggers attribute of the corresponding <af:query/> component.

1:  <af:toolbar id="t1">  
2:    <af:commandToolbarButton text="toggleShowOperators"   
3:                 id="ctb1"  
4:                 actionListener="#{bindings.toggleShowOperators.execute}"  
5:                 disabled="#{!bindings.toggleShowOperators.enabled}"  
6:                 partialSubmit="true"  
7:                 />  
8:    </af:toolbar>  
9:    <af:panelHeader text="Employees" id="ph1">  
10:     <af:query id="qryId1" headerText="Search" disclosed="true"  
11:          value="#{bindings.EmployeesHireDateCriteriaQuery.queryDescriptor}"  
12:          model="#{bindings.EmployeesHireDateCriteriaQuery.queryModel}"  
13:          queryListener="#{bindings.EmployeesHireDateCriteriaQuery.processQuery}"  
14:          modeChangeVisible="false"  
15:          queryOperationListener="#{bindings.EmployeesHireDateCriteriaQuery.processQueryOperation}"  
16:          resultComponentId="::resId1"   
17:          partialTriggers="::ctb1"/>  
18:    </af:panelHeader>


Now you can toggle between the show operators by pushing the button.

Labels:

Comments

Capil Verma said…
can you provide the above implementation in a sample application.
i am stuck in same problem statement.
7:34 PM
Post a Comment

Popular posts from this blog

ADF 12.1.3 : Implementing Default Table Filter Values

In one of my projects I ran into a requirement where the end user needs to be presented with default values in the table filters. This sounds like it is a common requirement, which is easy to implement. However it proved to be not so common, as it is not in the documentation nor are there any Blogpost to be found that talk about this feature. In this blogpost I describe how to implement this. The Use Case Explained Users of the application would typically enter today's date in a table filter in order to get all data that is valid for today. They do this each and every time. In order to facilitate them I want to have the table filter pre-filled with today's date (at the moment of writing July 31st 2015). So whenever the page is displayed, it should display 'today' in the table filter and execute the query accordingly. The problem is to get the value in the filter without the user typing it. Lets first take a look at how the ADF Search and Filters are implemented by...
6 comments
Read more

ADF 11g popup and panelwindow: Open wikipedia in a modal popup.

This post was more or less inspired by the noteWindow example on Oracles tag demo site. When hovering the highlighted text in this example the user gets extra information about the subject. I wanted to give the end user the opportunity to get even more information, for instance by invoking a wikipedia page about the subject. The catch here is that I wanted this information to be shown in a modal popup, and one that is not prohibited by popup blockers. Luckily ADF 11g provides javascript popups that can also be made modal, so the user has to close the popup before returning to the application. This post describes how I used an in a to open the correct wikipedia in a modal popup. Step 1: Create the plain text that invokes the noteWindow. This is taken directly from the mentioned Oracle example. <p style="margin-left:30px;width:500px;margin-right:30px;line-height:16px"> Vultures are scavenging birds, feeding mostly on the carcasses of dead animals...
7 comments
Read more

ADF 11g Quicky 3 : Adding Error, Info and Warning messages

How can we add a message programatically ? Last week I got this question for the second time in a months time. I decided to write a short blogpost on how this works. Adding messages is very easy, you just need to know how it works. You can add a message to your faces context by creating a new FacesMessage. Set the severity (ERROR, WARNING, INFO or FATAL ), set the message text, and if nessecary a message detail. The fragment below shows the code for an ERROR message. 1: public void setMessagesErr(ActionEvent actionEvent) { 2: String msg = "This is a message"; 3: AdfFacesContext adfFacesContext = null; 4: adfFacesContext = AdfFacesContext.getCurrentInstance(); 5: FacesContext ctx = FacesContext.getCurrentInstance(); 6: FacesMessage fm = 7: new FacesMessage(FacesMessage.SEVERITY_ERROR, msg, ""); 8: ctx.addMessage(null, fm); 9: } I created a simple page with a couple of buttons to show the result of setting the message. When the but...
2 comments
Read more