E9.2 Simple Set User Selection - From Date To Date - DEMO

[Carlos Ross]

Hello, I would like to make a simple data selection through two OPs. I would like to; "Take the invoices between these dates".


I created the Data Structure and created two variables jdDateInvoiceFrom and jdDateInvoiceTo.
In the initialization section I wrote:

Set Selection Append Flag (<Yes>)
Set User Selection (BC Date - Invoice (F42119) (IVD), <Greater Than or Equal To>, PO jdDateInvoiceFrom, <And>)
Set User Selection (BC Date - Invoice (F42119) (IVD), <Less Than or Equal To>, PO jdDateInvoiceTo, <And>)

I tried various combinations between AND, OR and NONE but the result is always the same:
No Data Selected

 

[mohit.jde]

buddy,
would you please check if there are any existing selections getting applied along with the PO selections,. possibly that would be making a no data selection with the PO date range.

 

[BOster]

Run with debug logging turned on and you should get the generated SQL which may give you some clues.

 

[Mike Mackinnon]

You can also check in submitted jobs (Execution Detail) to see the SQL that gets generated for your UBE. This depends upon what JDE installation you are on (plug for including your system information in your signature!).

 

[JohnDanter2]

Could be this
Set Selection Append Flag (<Yes>)

As thats allowing the UBe to generate SQL in 3 brackets ( external stuff in your version) AND ( what you've coded) AND ( and BSVW joins)

Take that out (Set Selection Append Flag (<Yes>)) and it will just be ( what you've coded) AND ( and BSVW joins)