Upper and/lower queriable values jdeveloper

I have a query form in a jspx file and i'm trying to define some of the values as case sensitive, meaning that i want to be able to find, for example, a name with all letters upper case and/or lower case and obtain the values that i would obtain if i've inserted the name correctly. Can someone indicate me where can i find something to accomplish that?

Thanks in advance

--------Update

Code from my jspx file

<af:query id="qryId1" headerText="Search" disclosed="true" 
          value="#bindings.ImplicitViewCriteriaQuery.queryDescriptor}"
          model="#bindings.ImplicitViewCriteriaQuery.queryModel}"
          queryListener="#bindings.ImplicitViewCriteriaQuery.processQuery}"
          queryOperationListener="#{bindings.ImplicitViewCriteriaQuery.processQueryOperation}"
          resultComponentId="::resId1"
          binding="#{backingBeanScope.backing_SearchCustomer.qryId1}"
          maxColumns="3" rows="2" fieldWidth="30%"
          displayMode="compact" saveResultsLayout="never"
          saveQueryMode="hidden" modeChangeVisible="false"/>

Answers


In a view criteria, for each criteria item there is a check box Ignore Case. Uncheck it if you want to make that search field case sensitive.

If you are using All Queriable Attributes to create your search then you can set it in queryListner method of the query component. Here are the steps:

Create a queryListener method for your query component

<af:query id="qryId1" headerText="Search" disclosed="true" value="#{bindings.ImplicitViewCriteriaQuery.queryDescriptor}" model="#{bindings.ImplicitViewCriteriaQuery.queryModel}" queryListener="#{backingBeanScope.searchBean.queryListener}" queryOperationListener="#{bindings.ImplicitViewCriteriaQuery.processQueryOperation}" resultComponentId="::resId1"/>

Make query attributes case insensitive in queryListener method

  public void queryListener(QueryEvent queryEvent)
  {
    QueryDescriptor qdesc = (QueryDescriptor) queryEvent.getDescriptor();
    ConjunctionCriterion conCrit = qdesc.getConjunctionCriterion();
    //access the list of search fields
    List<Criterion> criterionList = conCrit.getCriterionList();
    for (Criterion criterion: criterionList)
    {
      ((AttributeCriterion) criterion).setMatchCase(false);
    }
    invokeMethodExpression( "#{bindings.ImplicitViewCriteriaQuery.processQuery}", queryEvent);
  }

  private void invokeMethodExpression(String expr, QueryEvent queryEvent)
  {
    FacesContext fctx = FacesContext.getCurrentInstance();
    ELContext elContext = fctx.getELContext();
    ExpressionFactory eFactory =
      fctx.getApplication().getExpressionFactory();
    MethodExpression mexpr =
      eFactory.createMethodExpression(elContext, expr, Object.class,
                                      new Class[]
        { QueryEvent.class });
    mexpr.invoke(elContext, new Object[]
        { queryEvent });
  } 

Need Your Help

How to check if AdView is visible?

android admob visible adview

I want to check if AdView did load ads and is visible and therefore requires space on the display or if did not load an ad for example if internet connection is not available.

Ubuntu Lucid, cgi-bin, and MathTex

apache ubuntu lamp cgi-bin ubuntu-server

So I have several dedicated servers out there running Ubuntu Lucid server. They primarily run WordPress sites - LAMP. However, one of my original sites is a controls engineering site that uses Ma...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.