Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Search for strings in all folders in an environment
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Search for strings in all folders in an environment
 Login/Join
 
Member
posted
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,


version: 1805m
OS: windows 7
 
Posts: 1 | Registered: March 14, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1508 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
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;


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 403 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
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
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 403 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
@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


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2114 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
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...

😒


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 403 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
Ok, I'll keep this game going Wink -

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 Wink


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5583 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1508 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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] Razzer


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5583 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Good One


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1508 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
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] Razzer


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


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 403 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Search for strings in all folders in an environment

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.