Vishal, Doug is correct 'field' LIKE "%[^a-z A-Z0-9]%" will allow users to search for a string with a space character.
You are restricting a lot more than just wildcards If your intent is to only allow ALPHA NUMERIC (and spaces) in your searches then that will do it. Keep in mind though, you're blocking searches on commonly used special characters like @':.,#- Searches for "Its" won't find "It's" and ' isn't one of your allowed characters. Greg Givens (Contractor) Network Applications Support Navy Personnel Command -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mueller, Doug Sent: Thursday, November 08, 2012 11:05 AM To: [email protected] Subject: Re: How to restrict wild card searches ** Vishal, I am curious why you use the syntax you are using 'field' LIKE "%[^a-zA-Z0-9]%" This will error on space or any special character or any number of other conditions. If you want to just disallow wildcards, there are only a couple of them. I assume the things you are worried is really the % character. Why not 'field' LIKE "%[%]%" Note that the % sign should not be a wildcard as it is within the [] construct which says to treat things inside it as characters. This says to match when there is a % in the value. Now, you could add other specific characters as well within the test if you cared to (like match any single character or even the [ in case someone wanted to try a set of characters] but is that really necessary? Isn't it just the % that is the issue? Now, if you wanted to keep what you have and just allow space in addition, just add a space in the set of characters. 'field' LIKE "%[^a-z A-Z0-9]%" Notice that I put a space between the a-z and A-Z. That should include space as a character in your set of characters. NOTE: Both of these comments are how this should work and how I expect it to work. I unfortunately am not at a place where I can test things at the moment, but this is the way things are supposed to work. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vishal Navale Sent: Thursday, November 08, 2012 7:47 AM To: [email protected] Subject: Re: How to restrict wild card searches ** Hi Greg, For restricting the wild card character on field level we had created the Active link which will fire on search mode . The qualification is : ((('Description' LIKE "%[^a-zA-Z0-9]%") OR ('Resolution' LIKE "%[^a-zA-Z0-9]%")) OR ('Detailed Decription' LIKE "%[^a-zA-Z0-9]%")) OR ('Incident Number' LIKE "%[^a-zA-Z0-9]%") If we are giving wild card character for searching on fields (Notes , summary , resolution and Incident ID) , it will throw an error . However this Active link is also firing when we are giving space on fields like (Notes , summary , resolution and Incident ID). We don't want to fire this active link when any user will give space . Do you know how to a resolve this? Vishal On Fri, Oct 26, 2012 at 2:51 PM, Vishal Navale <[email protected]> wrote: Thanks Greg, Fantansticts, It works. Regards, Vishal On Thu, Oct 25, 2012 at 2:56 PM, Givens, Gregory CTR NPC, Pers 54 <[email protected]> wrote: Vishal, If it's a problem with wild cards being used in specific field(s), you could change the QBE Match for the field(s) to "Equal" However, doing just that will not stop wild cards in the advanced search bar. To stop that from being allowed you will need to add a character field to the form and give it a field ID of 1005 Then create a Active link with Execution Options - Search Run If Qual - ('1005' LIKE (("%" + "[%]") + "%")) OR ('1005' LIKE (("%" + "[_]") + "%")) If action is an Error message Greg Givens (Contractor) Network Applications Support Navy Personnel Command -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vishal Navale Sent: Thursday, October 25, 2012 6:12 AM To: [email protected] Subject: How to restrict wild card searches Hi, Is there any way to restrict wild card searches on the ARServer 7.5 p4? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> attend wwrug12 www.wwrug12.com <http://www.wwrug12.com/> ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> attend wwrug12 www.wwrug12.com <http://www.wwrug12.com/> ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature
