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
Denes, why not use oracle text searching (contains) on string and substring searches? It scales much better than like searches.
ReplyDeleteMike
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.
ReplyDeleteDenes Kubicek
Denes,
ReplyDeleteJust 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