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
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?