14
At the moment defining a DataItem Link on 2 object is limited by setting the filters outside of the query. Adding a BETWEEN would make it possible to set the filter based on the parent object field values.
Would this be possible?
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;
SELECT * FROM Orders
WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-31';
SELECT
cal.Date,
pr.[Resource No_],
pr.[Project No_],
pr.[Start Date],
pr.[Project End Date]
FROM dbo.ProjectResource AS pr
INNER JOIN dbo.WebCalendar cal
ON wcr.Date BETWEEN pr.[Start Date] AND pr.[Project End Date]
Would this be possible?
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;
SELECT * FROM Orders
WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-31';
SELECT
cal.Date,
pr.[Resource No_],
pr.[Project No_],
pr.[Start Date],
pr.[Project End Date]
FROM dbo.ProjectResource AS pr
INNER JOIN dbo.WebCalendar cal
ON wcr.Date BETWEEN pr.[Start Date] AND pr.[Project End Date]
STATUS DETAILS
Needs Votes
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team