Forum Stats

  • 3,782,026 Users
  • 2,254,584 Discussions
  • 7,879,894 Comments

Discussions

View Criteria Case Insensitive is not working

3046502
3046502 Member Posts: 234
edited May 25, 2016 11:25AM in JDeveloper and ADF

Hi Support,

My View Criteria Object where clause is (UPPER(NAME) = UPPER(Name)

Control Type is Input list of Values

Trying to filter by name, only exact case is working.

For Example: Field in DB is "Test", i cannot do filter by "test", can do only by camel case

Tagged:

Answers

  • Sameh Nassar
    Sameh Nassar Member Posts: 1,076
    edited May 25, 2016 7:04AM

    Try to do the following:

    1- Open the ViewObject --> Java --> Java Classes --> Generate View Object Class

    2- Open VOImpl class and from main menu --> Source --> Override Methods

    3- Override "getCriteriaItemClause" and write this code:

    public String getCriteriaItemClause(ViewCriteriaItem viewCriteriaItem)
      {
        viewCriteriaItem.setUpperColumns(true);
        return super.getCriteriaItemClause(viewCriteriaItem);
      }
    
    

    4- Try your test again

  • ManishPandey
    ManishPandey Member Posts: 1,722 Silver Trophy
    edited May 25, 2016 7:06AM

    Hi,

    1.select IgnoreCase checkbox in criteria defination.

    2.Edit List Of value UI Hint tab and select Criteria to "Include Search Region" List.

  • 3046502
    3046502 Member Posts: 234
    edited May 25, 2016 11:25AM

    Tried with the below, not working as expected

    public class TestReportVOImpl extends ViewObjectImpl {

        /**

         * This is the default constructor (do not remove).

         */

        public TestReportVOImpl() {

        }

        public String getCriteriaItemClause(ViewCriteriaItem viewCriteriaItem) 

          { 

            viewCriteriaItem.setUpperColumns(true); 

            return super.getCriteriaItemClause(viewCriteriaItem); 

          } 

    }

This discussion has been closed.