Searching in a node
I have to perform a search in a table:
1. It has Date(java.sql.Date) - display format has to be dd/mm/yyyy, but the format stored in the node is yyyy-dd-mm
2. It has a description field with entry like: "Dual Objective Case to be discussed"
3. other fields.
My issues are:
1. When I try to search for a date, and enter the string "10/10/2005" in the search fireld and click Search button, even though there are entries, it cannot find it. Mainly because of differences in the date format. How do I solve this problem?
2. When I give my search term as "Objective", i have to find the entry/entries in which the term "Objective" appears - irrespective of the position of the word in the description sentence. How can I achieve this?