Ranges in Views

Finance and Operations/AX Developer Forum
1

Hi all,
i just created my first view with a range. I want to pass a value to the range from a field of one of the datasources inside the view.

Is this possible?

Frank

2

Hi,

I read it several times and I am still not sure what do you want to achieve with this range setting from another field value. Could you explain it in a bit more details. Setting up a relation between two tables in a query might be the thing you are looking for - but then again, I am not sure if I got your idea right.

Janis

3

Hi Janis,
i want to achieve something like this in SQL:

SELECT TableA.DateFrom, TableA.DateUntil, TableB.ReferenceDate
FROM TableA INNER join TableB ON …
WHERE TableA.DateFrom <= TableB.ReferenceDate and TableA.DateUntil >= TableB.ReferenceDate

Frank