Can anyone give us some advise for filtering records in a CSIDE dbs, when we want to restrict some users on reading a few items. Do we need to filter in all forms and reports, or is there somehow a possibility to build something on table-level (like SQL-security filters)?
0
Comments
Depending how you want this applied using the standard method should do.
Depending upon your version the strengthing security guide should be enough to help
Form example:
record.FILTERGROUP(2);
record.SETRANGE(...);
record.SETRANGE(...);
...
record.FILTERGROUP(0);
The filters between the two FILTERGROUP commands will not be removed by the user...
1 Remark : best use filtergroup 10 and up. filtergroups 1 to 6 are reserved. Best leave some extra for the future and start from filtergroup 10.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
But the conclusion is that we need to build groupfilters in every form and report where the item-table is used (there is not some possibility for filtering on table-level)
I recommend creating a function in the table that puts the filters. This way you can just call the function in each object. And if you need to change some code, just do it in the function and everywhere you use it, it is ok.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!