OTN Discussion Forums : Creating Advanced Search

Reply to this Thread

Search Forum

Back to Thread List

Replies: 6 - Pages: 1 - Last Post: Mar 9, 2007 12:04 AM Last Post By: DominionSpy

Karthik

Posts: 65
Registered: 08/12/05

Creating Advanced Search - Call for ideas
Posted: Feb 21, 2007 8:53 AM

Hello everyone!

Forgive me if this is a little long..

I am trying to get an advanced search (10-12 fields) designed for our JSF-ADF BC application. Instead of laying out all the fields in a Panel, is there any samples out there that you can refer to?

For eg: http://forums.oracle.com/forums/thread.jspa?threadID=474045 uses a simple search with a selectOneChoice and I have posted asking if that can be extended.

One other challenge I am facing is how to do a 'between', 'greater than', 'lesser than' search for some of the fields (number/date).

I will really appreciate your ideas, pointers, references. I have searched the usual places but haven't been lucky.

Thanks for your time.

Karthik

Posts: 65
Registered: 08/12/05

Re: Creating Advanced Search - Call for ideas
Posted: Feb 22, 2007 5:35 AM

in response to: Karthik

any ideas?

DominionSpy

Posts: 154
Registered: 03/13/06

Re: Creating Advanced Search - Call for ideas
Posted: Feb 26, 2007 5:26 AM

in response to: Karthik

Hi Karthik,

Thanks for posting this question, because it inspired me to find a customisable solution to your problem, which is useful for the project I'm working on at the moment.

I've written a blog about what I've done here and I've also uploaded a sample application with it, which you can get there or from this link.

I hope this is helpful for you.

Regards,
DominionSpy

Karthik

Posts: 65
Registered: 08/12/05

Re: Creating Advanced Search - Call for ideas
Posted: Feb 26, 2007 6:17 AM

in response to: DominionSpy

DominionSpy!

Wow.. is all I can say!! I haven't delved into your full article yet but on the surface it looks exactly what I was looking for!! I just couldn't wait to thank you for the effort.. I will get back to you after going through the complete example.

Thanks a lot again..

Karthik

DominionSpy

Posts: 154
Registered: 03/13/06

Re: Creating Advanced Search - Call for ideas
Posted: Mar 1, 2007 1:20 AM

in response to: Karthik

Have you had a chance to try this out?
If there are any problems with it, I'd like to know so I can fix them.

Karthik

Posts: 65
Registered: 08/12/05

Re: Creating Advanced Search - Call for ideas
Posted: Mar 8, 2007 5:43 AM

in response to: DominionSpy

It works great! Thank you..

This gives me a great starting point to work with and I haven't found any problems with it. It just works great. I am working to achieve a little bit of a different flavor and this is the reason.

I have an application written by someone else in UIX and I am trying to rewrite that in JSF which uses a search bean. Also it uses PPR with uix components to have an ajaxy effect. Users are already using this app so I am trying to keep it as close as to the old app! Few features are..

When you first select a field in the selectOneChoice, if the chosen field is a String you get 'relevant options' and if its a number, and you choose 'is between' you get 2 input fields instead of one, etc.. Also some of these fields when chosen are geared to have a LOV flashlight appear to choose from a LOV popup.

I can send you the uix & search bean files if you would like to look at it.. Right now I am trying to figure out how to make the JSF components do the PPR like the UIX components did! I am sure I can use the search bean with little bit of plumbing if I can figure this out..

You can email me at karthiik at gmail dot com.

DominionSpy

Posts: 154
Registered: 03/13/06

Re: Creating Advanced Search - Call for ideas
Posted: Mar 9, 2007 12:04 AM

in response to: Karthik

That sounds really fascinating. I had thought about changing the input field depending on the type of data the selected attribute holds, but I couldn't think of a way to do it.

I would be interested to see those files - I'll email you over the weekend some time.

DominionSpy

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)