Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


VisuaLizeFOCUS .

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...