Hi, I would suggest to create a View-Form. The underlying database view should look something like this. create view xxxx as select request_id, assignee_group, upper(your_search_field),your_search_field, what_else_fields_you_need,.... from your_schema Your Set-Fields Action must use this View-Form for searching. Make sure that the assignee_group field in your View-Form has id 112! HTH Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von Vijayalakshmi Paulraj Gesendet: Mittwoch, 26. November 2008 08:55 An: arslist@ARSLIST.ORG Betreff: Set Field comparison ** Hi All, Our Users are expecting a Case Insensitive (using enter key) search functionality on one of the character fields. We used to display him the list of values using the Active Link Set Fields - SQL action and we will compare the values using UPPER Function; say UPPER('Category') = UPPER($Category$) We have also introduced Assignee Group field in our data source form in order to restrict certain data to certain users. So wherever we use the Set Fields -SQL action, we are now converting it to the direct Form search query, only then the Assignee Group data restriction will work. I got a problem now that on the Set Field action - direct form search, I don't have options to use the UPPER functionality :-( Remedy function option is not available. How do I do the Case Insensitive search? Has anybody come across this scenario?? Please share your thoughts. Thanks & Regards, Vijayalakshmi Paulraj ------------------------------------------------------------------------ -------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ------------------------------------------------------------------------ -------------------- __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"