IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    [SOLVED] Autoprompt for arbitrary WHERE combinations
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Gold member
Posted
I know this is a long shot...

Is there any way to set up ampers so that I can get an autoprompt (not have to build my own HTML UI) so that users can provide an arbitrary number and arbitrary set for a known group of ampers?

For example -
The possible variables in FILE CAR might be SEATS, COUNTRY, and SALES and the users might want to say
WHERE COUNTRY EQ 'ENGLAND' and SALES EQ 10000 AND SEATS EQ 2 OR COUNTRY EQ 'ENGLAND' AND SALES GT 25000 AND SEATS EQ 4 OR COUNTRY EQ 'JAPAN' AND SALES GT 15000 AND SEATS NE 2 etc. etc. - I realize I can build a UI where they'd pick all three variables any number of times and string together a WHERE statement for them. I'm just wondering if there'd be any way to set up the FEX so that the autoprompt could do this.

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


Release: WebFOCUS 7.6.5
OS: Windows
Output formats: HTML, PDF, Excel, csv
 
Posts: 72 | Registered: July 21, 2008Reply With QuoteEdit or Delete MessageReport This Post
Master
Posted Hide Post
Channy,

Autoprompt will give you only data entry boxes and/or listboxes depending on the options you specifiy with an amper variable.
It will not allow you to give your users the possibilities that you envision.
You could set things up so that autoprompt will present a fixed number of possibilities.

If you need more than that, then you're going to have to build your own UI, with or without the HTML layout painter.


GamP

- Using 764 on WinXP (sp2) - IE7.
- Also available are versions from 534 up to 766 on Windows (XP/2000/2003EE)
 
Posts: 518 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteEdit or Delete MessageReport This Post
Gold member
Posted Hide Post
GamP -

Thanks for responding - I pretty much thought that would be the answer but I wanted to check before building a whole UI in case WebFocus could do it for me.


Release: WebFOCUS 7.6.5
OS: Windows
Output formats: HTML, PDF, Excel, csv
 
Posts: 72 | Registered: July 21, 2008Reply With QuoteEdit or Delete MessageReport This Post
Master
Posted Hide Post
Channy

Ironically you could do this in 71 but they took the feature away from us in 76.

IBI'ers

Any explanation please?



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 848 | Location: Airstrip One | Registered: October 06, 2006Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    [SOLVED] Autoprompt for arbitrary WHERE combinations

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