Focal Point
[CLOSED] Filter on field which is private

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/8407048496

November 16, 2020, 02:28 AM
Jan999
[CLOSED] Filter on field which is private
I have created a business view for a user with a filter which select a subset for the accounts based on the accountnumber. However, the accountnummer is a private field and the user has no rights to view that field (FOC 32447). But the user has no wishes to view the account number, I only need the accountnumber in the filter.

How can I solve this?

This message has been edited. Last edited by: FP Mod Chuck,
November 16, 2020, 10:05 AM
FP Mod Chuck
Jan

FOC32447 is a warning message and doesn't prevent access. I am not sure what a 'private field' is and how you are preventing the user from using it. Is it a rule in the actual database? What is the field name in the master file?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 17, 2020, 04:55 AM
Jan999
I have entered the field in the DBA-pane as access-limited read. It is correct that this particular user may not view the field. But I need the field to filter the correct records, and that seems to be not possible. I have tried to use the limited field as a define, but that also doesnot work.
Gr,Jan
November 18, 2020, 12:26 PM
FP Mod Chuck
Jan

Please post your master file with the DBA included.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats