Focal Point
[SOLVED]how to set limits on the number of records retrieve?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9777080496

August 06, 2020, 05:02 AM
nox
[SOLVED]how to set limits on the number of records retrieve?
Hi,

My objective is to limit number of records that user can retrieve from DB in report. Reason for doing this is to avoid user try to retrieve huge amount of record from DB without set any filter.

I read about this following page:
https://infocenter.information...ce%2FRECORDLIMIT.htm

and by using
 WHERE READLIMIT EQ n  
did the trick, but some user may not want to coding in their .fex. Therefore, is there a way to set limitation and force only certain amount of records can be retrieve? or better if to have this limitation setting apply for certain user as well?

*User mention is the one on WebFOCUS user.

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


WebFOCUS v8.2.06 , Windows
August 06, 2020, 08:38 AM
MartinY
If I remember well DBA security setting in master file will allow you that


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
August 07, 2020, 05:53 AM
Danny-SRL
See: Describing Data With WebFOCUS Language Manual
Chapter on Data Source Security


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

August 07, 2020, 06:07 AM
nox
I read up about DBA, but what I understand in DBA section can set limitation base on a field or column value to print the result, but what I looking for is more like set only MAX of 1,000 records can be retrieve without base on any column. Or is it there a way can be done in DBA section? if yes, then please provide some coding or where I should look into?


WebFOCUS v8.2.06 , Windows
August 07, 2020, 09:35 PM
sh98110
this is the poor man's Resource Governor solution:

DBA=STEVE, $
USER=TOM,ACCESS=R, $
USER=SWIFT,ACCESS=R,RESTRICT=VALUE,NAME=SYSTEM,VALUE=RECORDLIMIT EQ 10, $

SET USER=TOM will print everything; SET USER=SWIFT will only print the first ten records.

-* NOTE!! - READLIMIT and RECORDLIMIT work differently depending on whether you are using RELATIONAL or FOCUS files.


WebFOCUS 8
Windows, All Outputs
August 10, 2020, 09:43 PM
nox
Hi sh98110,

your solution may be poor man's resource governor, but it get the job done, thank you all for your support.


WebFOCUS v8.2.06 , Windows