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] filter in dropdown list
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] filter in dropdown list
 Login/Join
 
Silver Member
posted
we create the report and have the WHERE parameters, If I use HTML composer to reference the procedure and config the parameter as dropdown list.
now, I have several users to use the procedure and HTML, users have diffrent values from dropdown list.
My question is : how can i create the procedure and config the system to do it?

for example:

TABLE FILE CAR
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
WHERE ( CAR.ORIGIN.COUNTRY EQ '&COUNTRY.(FIND COUNTRY,CAR.ORIGIN.COUNTRY IN car).COUNTRY.' ) AND ( CAR.COMP.CAR EQ '&CAR.(FIND CAR,CAR.COMP.CAR IN car).CAR.' );
ON TABLE NOTOTAL
END

If user1 only have the permission to access the data of ENGLAND and user2 only have the permission to access the date JAPAN,how can i create the HTML and config the system to do it?

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


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
That would require a totally secure system. So, the user has to log on to the system, then either with explicit or implicit (sso option) logon he/she registers witht he webserver, which in turn will notify webfocus clitne and server of who is logged on. The server will then take the users id-ticket and use that to read from the database, which also has to be secure to be able to distinguish between the users.
If this is all in place, then there is nothing to worry about any more, since the system will take of things based on the user's id.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
Hi, Gamp
It sounds like very complex,so can you give me some more suggestion or some reference website?


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
WebFOCUS security and administration manual would do just fine, I think. You can find it on IB's web site.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] filter in dropdown list

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