Hi All
Still relatively new to Nav/AL extension development. Trying to figure out how to approach this extension
We have items we need to label (the labels will be generated by exporting a CSV file for LoftWare labelling app).
I need to show a list of records based on a few parameters (mainly start and end date)
The problem is I need to get a list of items that either come from Production Order Routing Lines or expected PO Line receipts that fall within the date range
For example
Prod Order1 : Item A, Due 2/1
Prod Order2 : Item B, Due 2/14
Prod Order3 : Item C, Due 3/1
PO Line 1 : Item D, Due 2/5
PO Line 2 : Item E, Due 2/17
PO Line 3 : Item F, Due 3/11
So if user sets start date of 2/1 to 2/28 the worksheet should show the following with a few other fields from the item card
Item A, Due 2/1
Item B, Due 2/14
Item D, Due 2/5
Item E, Due 2/17
I then want the user to be able to sort, filter and (either delete rows or mark rows), to control which records will get exported
If I were doing in SQL, my data source would be a query that contains a Union.
In AL, I'm figuring this would be a Page of PageType Worksheet, but not sure what my source table would be. I'm guessing SourceTemporary would be true
Could someone point me in the right direction?
Thanks
Mark
0
Answers
Then on some action in this page run process that will find out related records based on your filters and insert them to the temp table.
Don't care about the number of fields in the table, in the temp table it has almost no performance impact on the app server. Just choose the table that suits your needs.