Worksheet Page,. Datasource is a union, Export using XML port

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