**CLOSED global fex search?

[robert fuschetto]

Is there a way to search ****all**** fexes in a given folder for a keyword..like a column name...to see if it was used anywhere.

[Patrick Huebgen]

If you are talking about the repository?

multiple options

1. use the WebFOCUS client adapter and search with it - quite complex as you can only search single fexes.
2. export your repository via change management extract the zip and use a tool like notepad++ ro search
3. create a report on top of repository - did this a while back - challenge is that you need to create a database view that converts a blob field into a readable format.

[Martin Yergeau]

You may have to adapt according to used version, but globally it should work

SELECT distinct T2.PRT_PATH AS 'Location', T2.OBJNAME AS 'Object Name', 'IBFS:' + T2.PRT_PATH + '/' + T2.OBJNAME AS 'Full IBFS path' --,T3.[WF_LNG] AS 'Lang' --,T3.[OBJDESC] AS 'Title' --,T1.OBJ_HANDLE --,CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX)) 'Code' FROM YourRepoName.dbo.WF_CONTENT_REVS T1 INNER JOIN YourRepoName.dbo.WF_REPOSOBJ T2 ON T1.OBJ_HANDLE = T2.HANDLE /* To also have the title per language */ --INNER JOIN [YourRepoName].[dbo].[WF_NLSOBJ] T3 -- ON T1.OBJ_HANDLE = T3.OBJ_HANDLE WHERE UPPER(CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))) LIKE '%YourSearchString%'--and T2.OBJNAME like '%htm'--and T3.[WF_LNG] = 'en_US'ORDER BY 1, 2, 3

[Patrick Huebgen]

It will depend on what you use as your repository - I did it with Oracle and MS SQL - different code needed

Patrick

[Martin Yergeau]

For sure, but the idea is there and repos tables should look similar from one to the other

[robert fuschetto]

thanks all..I will reopen if we get stuck

[Patrick Huebgen]

Agreed - your solution is perfect and from my experience the only change needed based on the DB used would be the cast statement