Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Can you have a document cue total based on temporary table?
Linkam
Member Posts: 2
I'm trying to create a document cue on a role-centre that displays a filtered list of warehouse shipments.
I needed to merge data from couple of tables so that ideally all the columns could be sorted/filtered on. I've created a query that pulls in the warehouse shipment data and a page that displays it also has a function to populate the temporary table with some additional sales header data. All that side of things is working great.
The problem is although the document cue when clicked on correctly opens the list, the count of records on the role-centre itself always displays zero even though that isn't correct (it should be 22 for example). I'm wondering if this is because it's reading the permanent version of the table and obviously finding zero entries.
Is there any way to get the document cue to correctly count the number of records in the temporary table instead?
Any help greatly appreciated.
I needed to merge data from couple of tables so that ideally all the columns could be sorted/filtered on. I've created a query that pulls in the warehouse shipment data and a page that displays it also has a function to populate the temporary table with some additional sales header data. All that side of things is working great.
The problem is although the document cue when clicked on correctly opens the list, the count of records on the role-centre itself always displays zero even though that isn't correct (it should be 22 for example). I'm wondering if this is because it's reading the permanent version of the table and obviously finding zero entries.
Is there any way to get the document cue to correctly count the number of records in the temporary table instead?
Any help greatly appreciated.
0
Answers
For an example take a look at page 1310 Mini Activities, there are both Normal and FlowField fields in there.
I'm using a flowfield on T9053 (Sales Cue) which is already calculating other fields correctly of course, I tried a few things but couldn't get it to work. I think because of the catch 22 of not having the data available until the point you actually display the page there's no way of calculating the number of records beforehand on my temporary table.
However it dawned on me a way around is that because essentially I was just working with the warehouse shipment header (T7320) with some filters so I just changed the flowfield to point to T7320 with the same filters. Then in the drilldown trigger I called the page I'd created that properly collates all the info I need.
Thanks for your help anyway.