web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) How to filter the Acco...

Microsoft Dynamics NAV (Archived)

How to filter the Account Schedule page 103

(0) Share

Report

Report

Posted on by Mosaheb

952

The requirement is to restrict access to account schedule whereby users will be granted access to specific account schedule.

Hence, a new table (Acc Shedule By User) was designed with the following fields

Now, we want to filter the Page 103 - Account Schedule Names so that only the list where the user have accessed is displayed.

We have put the following code on both onOpenPage and OnAfterGetrecord but unfortunately no filtering is being done:

IF AccSchedulebyUser."Acc. Schedule Name" <>'' THEN

AccSchedulebyUser.SETRANGE(AccSchedulebyUser."User ID",USERID);
SETRANGE(Name, AccSchedulebyUser."Acc. Schedule Name")

Would you please inform how the filtering can be done? Thanks for you input

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Nareshwar Raju Vane... 5,596 on at

Like (2)

Report
Hi Mosaheb,

I rewrote the code and this will help. Please note that this isn't the full implementation, but a skeleton.

OnAfterGetRecord -- ()
CLEAR(filter); AccUserSched.SETRANGE(AccUserSched."User ID", USERID); IF AccUserSched.FINDSET THEN BEGIN REPEAT IF filter = '' THEN filter := AccUserSched."Acc. Sched. Name" ELSE filter += '|' + AccUserSched."Acc. Sched. Name"; UNTIL AccUserSched.NEXT = 0 END; SETFILTER(Name, filter);

filter is a Text variable in here.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

You need to write the code in Page 103 > OnOpenPage. Also, use FilterGroups to have correct security.

OnOpenPage()

CLEAR(AccSchfilter);

AccSchedulebyUser.SETRANGE(AccUserSched."User ID", USERID);

IF AccSchedulebyUser.FINDSET THEN

BEGIN

REPEAT

IF AccSchfilter = '' THEN

AccSchfilter := AccSchedulebyUser."Acc. Sched. Name"

ELSE

AccSchfilter += '|' + AccSchedulebyUser."Acc. Sched. Name";

UNTIL AccSchedulebyUser.NEXT = 0

END;

FILTERGROUP(2);

SETFILTER(Name, AccSchfilter);

FILTERGROUP(0);

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans