Odata entity date range to filter records (datasource join) issue

(0) Share

Report

Posted on by Suren_G

252

Hi All,

We have a requirement to expose an odata entity which will expose the Purchase Orders with Invoiced and Received status. And if the purchase order is in Invoiced status, it should expose the records that are invoiced after -10 days from the current date.

Created a data entity with PurchTable as a datasource and added range for the PurchStatus field with (Invoiced OR Received) values.

Added VendInvoiceJour as child datasource and added range for the InvoiceDate field with (GreaterThanDate(-10)) value.

The issue is when we use the join type as 'Inner Join', it exposes the Invoiced purchase orders with proper date range but it ignores the 'Received' purchase orders. And if the join type is 'Outer join', it ignores the date range and exposes all the invoiced and received purchase orders.

Could anyone share info on how this can be handled.

Thanks!

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 239,118 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Why do you want to create a new entity instead of using the existing one and merely filtering the records? It seems to be that you'd spend time developing something (and keep maintaining it for the whole lifetime of the system) that you don't really need.

The status is already there; you would just have to add the invoice date.

Noe that your current design ignores the fact that there may be more invoices for a single purchase order.

Was this reply helpful? Yes No