Filtergroup(6)

anoop

Hi,
I have applied security fileters on Item Ledger Entry. But whenever i try to reset these filters unsing filtergroup(6) it does not work.

If somebody can help me how to use filtergroup(6) i shall be thankful...

Regards
Anoop

afarr

Anoop,
I would use code like this:

FILTERGROUP(6);
// code to set the filters
FILTERGROUP(0);

and

FILTERGROUP(6);
// code to reset the filters
FILTERGROUP(0);

Is this what you are doing? If not, could you give us an example of your code?

Thanks,
Alastair

anoop

Thanks Alastair,
The difference is that i'm setting the filters using permissions in roles, but i'm not able to reset these filters using the following code.

FILTERGROUP(6);
// code to reset the filters
FILTERGROUP(0);

please let me know can we somehow reset the filters set in roles and permissions.


Regards
Anoop

afarr

Sorry Anoop,

I don't know how to do that myself. Maybe someone else on the forum does.

Alastair

DavidB

hi anoop,

i've the same problem!!! Have you find a solution :?:

davidB

wonmo

To reset just use:

CLEAR(Rec);

DavidB

Sorry... that doesn't work. I get following error msg: "You don't have the permission to read the table".

Maybe I make a mistake?!

I've set a security filter in a role for the table "G/L Account". This filter contains "G/L Account: No.=1000..1200" as value. In a report I want to see all G/L Accounts. So i write following code:

G/L Account - OnPreDataItem()
FILTERGROUP(6);
RESET;
FILTERGROUP(0);

i also tried this:

G/L Account - OnPreDataItem()
FILTERGROUP(6);
CLEAR("G/L Account");
FILTERGROUP(0);

Have you any further ideas?

DavidB

I have a solution! \:D/

You have to give the user a further role with indirect permissions on the table you want to use. Afterwards you can set the read-permission in the report and reset the filtergroup 6 on OnPreDataItem().