Share
Report
132Hi All,
I'm struggling with this requirement I got. This is a simplified version of what I need to do:
Button: When the user clicks this button, this should happen:
First of all, the job should (preferably mandatory) run in Batch.
I have 2 Simple Queries in the AOT. The user should be able to add filters etc. to both Queries.
Next, the Batch job should run, execute these two Queries and save the results to a table.
For this scenario, assume the first simple Query to contain the custTable. The second one contains the vendTable.
After the user modified the filters on the Batch Job Dialog, the batch job should export the data from these two Queries to the table 'TotalTable', Holding the Customer/Vendor Account and the Customer/Vendor Name
First of all, the job should (preferably mandatory) run in Batch.
I have 2 Simple Queries in the AOT. The user should be able to add filters etc. to both Queries.
Next, the Batch job should run, execute these two Queries and save the results to a table.
For this scenario, assume the first simple Query to contain the custTable. The second one contains the vendTable.
After the user modified the filters on the Batch Job Dialog, the batch job should export the data from these two Queries to the table 'TotalTable', Holding the Customer/Vendor Account and the Customer/Vendor Name
Normally I could use something like the "Records to include" on the Batch Dialog, but as I have two Queries I do not really have a clue on how to get this to work. Is this possible ?
Or should I create a normal form or class, giving the user the option to add filters etc. to the Query and then pass these Queries to a class that creates a Batch job with these two Queries ?
Any thoughts or someone that might have encountered a similar requirement before ?
FYI: I will be away until Wednesday, so I cannot respond before then.
Thanks !
Gerard
Categories:
I have the same question (0)
All responses (
Answers (
