gpayne
(Greg Payne)
June 30, 2023, 9:26pm
4
You should be able to use @jgiese.wci ’s code from here to search on something from the email that could find it. I find myself using these at least once a week now.
I search the database directly especially if I’m dealing with tech debt.
Find code in EFX
SELECT
EfxFunction.LibraryID,
EfxFunction.FunctionID,
EfxFunction.Description,
CONVERT (nvarchar(MAX), Body, 0) AS MyText
FROM
Ecf.EfxFunction
WHERE
CONVERT (nvarchar(MAX), Body, 0) LIKE '%Ice.Diag%'
ORDER BY
EfxFunction.LibraryID ASC,
EfxFunction.FunctionID ASC
Find code in Method, Data, UBAQ directives
SELECT
BpDirective.DirectiveID,
BpDirective.Source,
BpDirective.DirectiveType,
BpDirect…