APEX Training

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:

Michael Smith 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

John B 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