Adding Child element in Navigaton using Cues on Role Center

Johannes_Nielsen
Member Posts: 206
Hi all
I'm trying to add some Child elements to the Navigation.
This is done by creating Cues on the rolecenter, using the same source table and having the DrilldownFormID property set to the same list page as the (parent) menu item. In this case "Sales Order List".
Then the Child items are added automatically (see attached )
The source Cue table is based on flowfields and I need to filter the Sales Order List by the current userID.
Like:
But I cannot seem to fetch the UserID (like USERID function) to use in the CalcFormula
I tried doing a second Flowfield to lookup My Session in Session table, but this produces "domain\user" format, not "user"
Any help would be appreciated
(I would like these to be default for the users of this Role center, that why I'm not just adding/saving views on every single user).
There are no other ways to add child element in navigation - to my knowledge!
I'm trying to add some Child elements to the Navigation.
This is done by creating Cues on the rolecenter, using the same source table and having the DrilldownFormID property set to the same list page as the (parent) menu item. In this case "Sales Order List".
Then the Child items are added automatically (see attached )
The source Cue table is based on flowfields and I need to filter the Sales Order List by the current userID.
Like:
Count("Sales Header" WHERE (Document Type=FILTER(Order),Status=FILTER(Open),Created by=FIELD(Userfield)))
But I cannot seem to fetch the UserID (like USERID function) to use in the CalcFormula
I tried doing a second Flowfield to lookup My Session in Session table, but this produces "domain\user" format, not "user"

Any help would be appreciated

(I would like these to be default for the users of this Role center, that why I'm not just adding/saving views on every single user).
There are no other ways to add child element in navigation - to my knowledge!

Best regards / Venlig hilsen
Johannes Sebastian
MB7-840,MB7-841
Johannes Sebastian
MB7-840,MB7-841
0
Answers
-
deV.ch wrote:What about adding a flowfilter field on the cue table and use SETFILTER Function together with the USERID Function to set the flowfilter to the users id?
That did the trick :thumbsup:
Thanks
For anyone else searching for something like this.
Adding a flowfield on the "Sales Cue" table, filtering it from "SO Processor Activities" OnOpenPage.
Heres more on child items in RTC navigation pane:
http://msdn.microsoft.com/en-us/library/ff477106.aspxBest regards / Venlig hilsen
Johannes Sebastian
MB7-840,MB7-8410
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions