Microsoft Dynamics NAV (Archived)

Flowfield + flowfilter + UserID

(0) Share

Report

Posted on by Community Member

Hello All

Hope someone can give me some pointer's
I'm fairly new to Nav and learning all the time.

Trying to create a new tile on the role centre.

This tile is to show the number of approval's the current logged in user has currently.

the Calcfield is as follows.

Count("Approval Entry" WHERE (Document Type=CONST(Order),Status=CONST(Open),Approver ID=FIELD(UserIDFilter)))

Trying to get UserIDFilter to be the current logged in user.

My Code to get the current user is as follows for

GetUserID := USERID;
IF GetUserID <> '' THEN BEGIN
SETRANGE(UserIDFilter,GetUserID); 
END;

Doesn't seem to want to show my current approval count. Just can't see what I'm missing.

Cheers

Rizzo25

*This post is locked for comments

All responses (4)

Answers (1)

Community Member on at

Like (0)

Report

RE: Flowfield + flowfilter + UserID

Hello Suresh

You are correct I didn't put the code in open page, got caught up with trying to see the result of the flow field directly in the table.(Still wondering though if it is possible to see results directly in the table rather than the page but that is for another time).

Anyway

Many Thanks

Rizzo25
Verified answer

Suresh Kulla 47,789 on at

Like (0)

Report

RE: Flowfield + flowfilter + UserID

Where did you add the above code, i hope you added that in the open page

Also change the above calcformulae as below

Count("Approval Entry" WHERE (Document Type=FILTER(Order),Status=FILTER(Open),Approver ID=FILTER(UserIDFilter)))

Change everything to FILTER.
Community Member on at

Like (0)

Report

RE: Flowfield + flowfilter + UserID

Hello Jonathan

Thanks for your reply, I have been checking out those table but could see anything to assist, I will go and take another look though.

Many thanks

Rizzo25
Suggested answer

keoma 32,727 on at

Like (0)

Report

RE: Flowfield + flowfilter + UserID

best you check the cue tables: table no. >= 9050

and the role centers: page no. >= 9000

especially check table 9150 MyCustomer (used e.g. in page 9006)