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