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     [SOLVED] Searching Using Maintain

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Searching Using Maintain
 Login/Join
 
Dev
Gold member
posted
Hi,
I have a maintain requirement where i want to have searchable Field on the screen.i.e, When user enters a value in the textbox,the list of releated values are displayed in grid.Suppose, User enters 'd' in the Editbox then all the values which starts with 'dev' is displayed below that Grid.
Maintain won't allow the like option using WHERE.
Is there any way to do this task in maintain?
Please suggest a approach for this.

Thanks in advance

This message has been edited. Last edited by: Kerry,
 
Posts: 79 | Registered: June 12, 2012Report This Post
Maintain Wizard
Master
posted Hide Post
So if the user enters in D, you want ONLY the values that start with D? Let's say your edit box is attached to a field called val. When the user enters a value and presses search you can use:


case search
compute val2/a50 = val || 'ZZZ';
-* I will use the movies file as an example
Reposition Moviecode
stack clear titlestk
for all next moviecode into titlestk
where title ge val
and title le val2;
Endcase

This example creates an upper and lower bound and returns only the values between them. Let me know if you need something else.

Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Wow, deja vu, Mark. It was 1997-98 and you provided the same solution to the exact same question I had for a Maintain app. But there was no FocalPoint at that time, just your direct line at IBI for any Maintain questions. Mark Rawls gave me your phone number.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Dev
Gold member
posted Hide Post
Thanks a lot Mark.

It's working fine,

Is there any other way to search in between sentences
Ex. i search '%tain', is it possible to get the releated values in the field. o/p: "Maintain"

Warm Regards,
Dev
 
Posts: 79 | Registered: June 12, 2012Report This Post
Maintain Wizard
Master
posted Hide Post
You can try:

for all next moviecode into titlestk
where title contains trip(val);


Mark
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Dev
Gold member
posted Hide Post
[CLOSED]


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Report 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     [SOLVED] Searching Using Maintain

Copyright © 1996-2020 Information Builders