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

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


Debra Waybright

Recommended Posts

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!

Link to comment
Share on other sites

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

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...