Is there a way yet to search the Content Repository (ie the DB structure which stores content code)

All our presentation logic is stored in the content area..and we are not able to search all that focus code for fields etc when looking things from a change impact. (ie..if we need to change a title of a field from "titla A" to "title B"..

We cannot find the entire population of fexes we would have to change.

if I knew the RDBMS table it was stored in, then I could make a Focus (or SQL ) call to look at the code.

Any thoughts/considerations would be greatly appreciated.

This message has been edited. Last edited by: FP Mod Chuck,

I should have mentioned this is 8.1.05

Here's a potential starting point. I'd love to hear how you crack this one. I may need it some day.

http://localhost:8080/ibi_apps/rs?IBIRS_action=TEST

William

What RDBMS is your repository stored in? There was a presentation called Reporting From the WebFOCUS Repository: Utilities You Can Use Now at summit last year by Barry Austin where he shared some code that does exactly what you are looking for.

Doesn't the Repository export come out in plain text these days?

Make a full export => copy onto your workstation => 'search in files' with Notepad++

And you'll get a code backup made at the same time...

thanks everyone

does anyone know where I can find this doc
"WebFOCUS Repository: Utilities You Can Use "

or any documentation on how to export the repository..

thanks in advance.

wm

Export documentation comes under "Change Management", for when you do code promotion. The folders will be under WebFOCUS80\cm\export on the client box.

Good morning,
Our WebFocus repository is on SQL Server, and I use the following query to search fex code:

 SELECT HANDLE, OBJNAME, PRT_PATH 
FROM WF_REPOSOBJ
WHERE HANDLE IN (SELECT OBJ_HANDLE FROM WF_CONTENT_REVS WHERE CAST(CAST(BCONTENT AS varbinary(MAX))AS varchar(MAX)) LIKE '%CAR%');
 

Have a great day,
Emily

quote:

Utilities You Can Use Now

this was a great set of tools to introspect the repository. It was created by Barry Austin at IBI.

Where may I find "Reporting From the WebFOCUS Repository: Utilities You Can Use Now"?

Hey all,

Here's the SQL scripts that work this magic if you're using SQL Server (as far as I've used such, it works in 8.1.05+):

-- Find file names in the repo:

SELECT
T2.PRT_PATH + '/' + T2.OBJNAME AS WFCPATH,
T2.OBJNAME,
T2.PRT_PATH,
T1.OBJ_HANDLE
FROM dbo.WF_CONTENT_REVS T1 
    INNER JOIN dbo.WF_REPOSOBJ T2 ON T1.OBJ_HANDLE = T2.HANDLE
WHERE LOWER(T2.OBJNAME) IN(
	'fexName1.fex',
	'fexName1.fex',
	'fexName3.fex')

-- Find any content and where it's referenced in the repository (not the file names, actual content (in the code)):

SELECT
T2.PRT_PATH + '/' + T2.OBJNAME AS WFCPATH,
T2.OBJNAME,
T2.PRT_PATH,
T1.OBJ_HANDLE,
CAST(CAST(BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX)) AS CODE
FROM dbo.WF_CONTENT_REVS T1
    INNER JOIN dbo.WF_REPOSOBJ T2 ON T1.OBJ_HANDLE = T2.HANDLE
WHERE CAST(CAST(BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX)) LIKE '%anything you want to find%'

Happy early Christmas!

P.S. Francis...you can't.

This message has been edited. Last edited by: CoolGuy,

Ah, yes. I recognize this code. I spent some time improving on this, one thing I have not been able to figure out is how to determine if a resource is published.

Don't quote me on this, but I think there's an "ACTIVE" field somewhere. Maybe I'm crossing my streams Ghostbusters-style... Something that would be good to add for sure.

No field. If a value does NOT exist in some table then it's published. But this is complicated by the status of one or all the parent folders... Could not deconstruct this.

And, the original code uncovered a secret in WF v8.0.08 - a blob is added to the table every time you save a resource, and I save often, so, for some resources I might have 50 versions saved in the table. This tremendously slows down opening folders where lots of saving has occurred.