FYI, I am fairly new to developing WebFOCUS apps. I have a lot of WebFOCUS objects/reports and I want to be able to parse all the WebFOCUS code in every object at once to find which objects contain the string 'SET SERVER'. Or in other words parse through every report we have in our environment to find which objects contain a specific string. So if I want to find which reports(or fex) are connected to specific environment, Is there a way that I can search for the name of the environment and WebFOCUS will parse through all of the reports(objects in its environment) and show me all of the objects/reports that contain that string? What is the best way to do this: WebFOCUS AppStudio(version 8.1)?

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

rcjammell687

From the web interface if you right mouse click on the Content folder one of the options is Search. You can then enter the string in the Title search field. I don't see the same ability with App Studio.

If your repository is on a SQL Server DB, and you have access to query it in SQL Server Management Studio, you can query the code of each item in the repository for a specific string using LIKE and the appropriate wildcards.

  
SELECT 'IBFS:'+T2.PRT_PATH+'/'+T2.OBJNAME                        'full_IBFS_path'
     , T2.PRT_PATH                                               
     , T2.OBJNAME                                                
     , T1.OBJ_HANDLE
     , CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX)) 'code'
FROM SLCSQLDW2.WF82prod.dbo.WF_CONTENT_REVS T1
     INNER JOIN SLCSQLDW2.WF82prod.dbo.WF_REPOSOBJ T2 ON T1.OBJ_HANDLE=T2.HANDLE
WHERE UPPER(CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))) LIKE '%SET SERVER%'
ORDER BY 1;

I see that you marked this as [CLOSED], and not [SOLVED].

Did you not find a solution to your question? Did these options not help?

🤔

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

@Hallway,

It is Chuck that has changed the status to [CLOSED] (see first post for last updated by)
After a while if there is no more action on a post the moderator change its status to [CLOSED] when no status already there

quote:

Originally posted by MartinY:
@Hallway,

It is Chuck that has changed the status to [CLOSED] (see first post for last updated by)
After a while if there is no more action on a post the moderator change its status to [CLOSED] when no status already there

Interesting. I would think that if a moderator is changing the status of a post, that they should also make a post stating that they are doing so.

IDK, maybe maybe that's just me...

😒

Ok, I'll keep this game going -

quote:

I would think that if a moderator is changing the status of a post, that they should also make a post

It would also be good if the originator confirmed that their issue/question had been answered instead of not following up, but I think that we will wait until a very hot place becomes very cold.

It would also be great if they thanked the person who supplied the answer or, at the very least, acknowledged the solution!

But then, maybe that's just me


T

I wait until there is no activity on a post for 7 days and based on the last post will mark it as closed or solved. I used to send a PM before closing but most times never got a reply. I am open to how best do this.

quote:

I am open to how best do this.

Given the propensity of people not following up on their original question (or your emails), I think that the approach that you’re taking is the better option.

Putting [CLOSED] is better than putting [ORIGINAL_POSTER_HAS_CBA_SYNDROME]


T

quote:

Originally posted by Tony A:

quote:

I am open to how best do this.

Given the propensity of people not following up on their original question (or your emails), I think that the approach that you’re taking is the better option.

Putting [CLOSED] is better than putting [ORIGINAL_POSTER_HAS_CBA_SYNDROME]


T

I'd be alright with [ORIGINAL_POSTER_HAS_CBA_SYNDROME]

🤣

Seriously though, it would be nice to see a post that says something like "This post has been closed due to inactivity."

I can see now, thanks to @MartinY, that there is a small blurb on the OP that says:

quote:

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

However, that is not apparent as to why it was edited, or what exactly was edited. There is an assumption that was the reason.

If you look at most any other forum on the web (Stack Overflow, Reddit, etc.) that is common practice.

Speaking of which, has there been any more discussion on updating the forum to a more modern interface? I see this post from 10 years ago that was never answered:
http://forums.informationbuild...81057331/m/761109361