Origam generated Incorrect syntax in SQL request

bugs
1 
WHERE EXISTS (SELECT * FROM [Worker] AS [Worker]
	WHERE 
	[Worker].[Id] = [CurrentMonthWork].[refWorkerId]
	 ANDdbo.GetMonthString(@Worker_parCurrentDate, 0) = dbo.GetMonthString([CurrentMonthWork].[FinishDate], 0) AND  (
	 ([Worker].[IsActive] = @Worker_parIsEmployed)));
3
4

What is the situation? Multiple relationship keys?

5

yes , the datastructure has two relationship.

1 Like
6

But this problem seems to be caused by 1 relationship having 2 keys, is this correct?

7

image
image
image

8

A relationship based on two calculated fields! :radioactive:

10

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.