Hey Guys, Is there a possibility of getting all the FEX file...

[VisuaLizeFOCUS .]

Hey Guys,

Is there a possibility of getting all the FEX files that are Using a master file

Like suppose we have a master file : CAR and we have created a dashboard out of it and I wan a list for all the procedures that are using the CAR master file in any REQUEST.

I checked but seems like we can only get in WF Server but only for that directory

Can it be available on WF Repository Any Ideas

[Martin Yergeau]

Here is code to query the Repos from a SQL DB

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'

FROM dbo.WF_CONTENT_REVS T1

INNER JOIN dbo.WF_REPOSOBJ T2

ON T1.OBJ_HANDLE = T2.HANDLE

/* To also have the title per language */

--INNER JOIN dbo.WF_NLSOBJ T3

-- ON T1.OBJ_HANDLE = T3.OBJ_HANDLE

 

WHERE UPPER(CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))) LIKE '%YourSearchCriteria%'

--and T2.OBJNAME like '%htm'

/* To filter title per language */

--and T3.[WF_LNG] = 'en_US'

ORDER BY 1, 2, 3

[VisuaLizeFOCUS .]

MartinY:

 

%YourSearchCriteria%

 

 

Hi MartinY,

Can you please tell me %YourSearchCriteria% here I need to add Master File Name.

[Martin Yergeau]

Put what ever you need.

E.g. if you search for GGSALES file, put : %GGSALES%

Could be anything, a columns name, a variables name, a string of code, another fexs name that may be -INCLUDE in a parent fex, etc

It is equivalent of a text search

[Debra Waybright]

We use that basic query to do all our Impact Analysis in the Repository - field names, table names, etc. I add field LASTACCESSBY to get an idea of whos been using it and LASTACCESSON to see how recently it has been edited.

[VisuaLizeFOCUS .]

Okay thank guys will try this query and will update you.

[VisuaLizeFOCUS .]

Hey MartinY I ran this code but 0 rows were there any idea why

[Martin Yergeau]

Are you connected to the proper DB

Does your repository under SQL tables

Which filter have you applied

Which code have you ran

From where are you running it From SSSMS

[VisuaLizeFOCUS .]

Hi MartinY,

Ran your code with the MASTER FILE name it gave me 0 records.

I Ran directly on Repository DB.

Yes running it from SSMS.

[Martin Yergeau]

From now its going to be difficult to help.

The code is working and used be also others

Can you share the whole code used

[Martin Yergeau]

Try with only a top 10 without the WHERE clause