Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2019Report 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: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Master
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

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Master
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

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report 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.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Master
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

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report 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.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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: 2127 | Location: Customer Support | Registered: April 12, 2005Report 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.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Master
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

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders