Hi Sarah, You didn't mention which db version you are using. I am not familiar with Customer Support but it sounds like you are searching on a diary field. It also sounds like you are using a QBE search. Try an advanced search with a LIKE statement instead of QBE (i.e. 'Interaction' LIKE "%" + "MEM" + "%").
If your db is (or was) an older Oracle version you may not be able to perform this search on a field that allows more then a certain number of characters (a VARCHAR allows 4k bytes I think). After building a brand new database from scratch to upgrade our old version 4 apps to ITSM 6 I was pleasantly surprised that we could now perform wildcard searches on our diary fields because they were a new datatype that had been introduced over the years since the initial build (just one of the many benefits to building a new db instead of upgrading). -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Lake Sent: Monday, January 29, 2007 10:43 AM To: [email protected] Subject: Field Search Hi This is very unique situation I don't know how to deal with it. Will love to hear from you all. SPRT:Interaction form in Customer support module Version 5.6. My user need to search in field Interaction Notes ( keep in mind interaction note can be worknote, phone, email)eg: Types %MEM% and clicks search button all notes with %MEM% shows up Interaction field is not searchable. This is overcome for time being by copying a data in searchable field. Still I can't search any thing in the new searchable field. Tried to search in SQL plus no Luck. What is correct way to do this? ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
