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.
--------------------------------------------------------------------------------------------
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
