Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Searching in a node

Hi

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?

Thanks

Manoj

Not what you were looking for? View more on this topic or Ask a question