Tuesday 10 April 2007

Custom Search Form


Many questions in the ApEx Forum are related to the way of creating custom search forms and implementation of different page elements in query filtering. I created an example a while ago and had to point to it several times since. I think, this is worth of posting once again. You will find the mentioned example here. It shows how to implement a filtering functionality using four different page elements:

- text field
- drop-down list
- date picker and
- a checkbox


3 comments:

Anonymous said...

Denes, why not use oracle text searching (contains) on string and substring searches? It scales much better than like searches.

Mike

Denes Kubicek said...

You may be right. However, this hardly depends on what exactly you want to search and how you want to search upon. I will consider your comment for the future. Thank you.

Denes Kubicek

Anonymous said...

Denes,

Just wanted to say thanks. I am constantly on your site (http://htmldb.oracle.com/pls/otn/f?p=31517:1) and I appreciate you sharing your work.

John