Classification: UNCLASSIFIED
Caveats: FOUO

I have SQL routines for this.  Here is an example:


DECLARE @string varchar(30)
SET @string = '%HardcodedText%'

SELECT name "Active Link", queryShort
FROM actlink
WHERE queryShort like @string

SELECT name "Filter", queryShort
FROM filter
WHERE queryShort like @string

SELECT name "Escalation", queryShort
FROM escalation
WHERE queryShort like @string


I used variables so that it would be easy to run while looking for different 
values each time you use it. Replace 'HardcodedText' with the words you are 
looking for.


Mike L.


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Danny Kellett
Sent: Monday, May 24, 2010 11:58 AM
To: [email protected]
Subject: Re: Tool for finding out the workflow with hardcoded values.

:) But then you have the def for when you forget tomorrow after all that beer ;)

-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Jarl Grøneng
Sent: 24 May 2010 18:21
To: [email protected]
Subject: Re: Tool for finding out the workflow with hardcoded values.

2010/5/24 Danny Kellett <[email protected]>:
>
> And these tools are great and have their place BUT for the posters 
> issue,
I
> think a def file opened in a text ed and a search will do the trick 
> plus
it
> doesn't fire a load of API calls to the AR Server.

But exporting the def does fire a load of api calls :-)

--
Jarl

____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: "Where the Answers Are"

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 
www.wwrug.com ARSlist: "Where the Answers Are"
Classification: UNCLASSIFIED
Caveats: FOUO

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Reply via email to