As most of you are aware, the Name field is missing in 8207 ...

[Debra Waybright]

As most of you are aware, the Name field is missing in 8207 web client which can make it difficult to find things.

I have this SQL query against the repository tables:

SELECT

T2.PRT_PATH

, T2.OBJNAME

, OBJTYPE

FROM WFRep2_Prd2.dbo.WF_CONTENT_REVS T1

INNER JOIN WFRep2_Prd2.dbo.WF_REPOSOBJ T2 ON T1.OBJ_HANDLE=T2.HANDLE

WHERE (CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))) LIKE %SearchValue%

But it gives the Name values, not the Title. Anyone know where the Title is hiding in these tables

We are in the process of also updating our SQL database, so it is really helpful to find reports that are using outdated tables or fields, so I can ask the user if the report is also obsolete or not.

But if the query returns the Path as /WFC/Repository/Sales/~user1/Jeff when the Title of that folder isnt Jeff, its Southern Region, it can be time consuming to find exactly which folder Im looking for, especially since the search in 8207 doesnt look in subfolders, so I cant just go to user1s folder and search for the report, which could have an OBJName of Jeff_Report but a Title of Southern Region List! Argh!

[Martin Yergeau]

Seems that you need to join with [WF_NLSOBJ] such as

SELECT

T2.PRT_PATH AS 'Location',

T2.OBJNAME AS 'Object Name',

'IBFS:' + T2.PRT_PATH + '/' + T2.OBJNAME AS 'Full IBFS path'

,[WF_LNG] AS 'Lang'

,[OBJDESC] AS 'Title'

FROM dbo.WF_CONTENT_REVS T1

INNER JOIN dbo.WF_REPOSOBJ T2

ON T1.OBJ_HANDLE = T2.HANDLE

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 '%SearchValue%'

--AND WF_LNG = 'en_US'

ORDER BY 1, 2, 3, 4

Pay attention that you will have as many repeated lines as you have translations.

Either you add a WHERE clause or you display them

[Debra Waybright]

@MartinY Thank you! That is so helpful!

[Rene Nunnington 2]

Hi Debra

You can still see the name of the procedure. You may need to switch from the default mode of tiles to grid mode first by clicking on the list icon on the bar. Once there, click on the gear icon on the title bar and then pick to display the name of the procedure.

[Debra Waybright]

@rene.nunnington Not in 8207.28. It isnt in the list to be selected.

[Rene Nunnington 2]

Please open a case Debra as this works in my version of 8207.28 and in 9.0. There may be a hotfix available for your environment.

[Debra Waybright]

I reopened my case for the Name column. Hopefully we can get that. Thanks!

[Debra Waybright]

@rene.nunnington I reopened my case but have heard nothing. Do you know which hotfix that is in