To me these two queries are similar:
Query 1:
from i0 in HaiData.Infection,
right_join: i1 in HaiData.InfectionCriteria,
on: i1.infection_id == i0.id and i0.infection_category_id in ^[8816],
right_join: u2 in HaiData.UserFacilityPermission,
on: u2.facility_id == i0.facility_id and u2.reporting == true and u2.user_id == ^13446 and u2.facility_id in
^[11411]
Query 2
from i0 in HaiData.Infection,
right_join: i1 in "infection_criteria", on: i0.id == i1.infection_id,
right_join: u2 in HaiData.UserFacilityPermission,
on: u2.facility_id == i0.facility_id and u2.reporting == true and u2.user_id == ^13447 and
u2.facility_id in ^[11413],
where: i0.infection_category_id in ^[8817] and ^true
They should produce the same result but i got 1 result
returned from Query 2 and 0
results from Query 1.
I want Query 2
to be equivalent of Query 1
.
Any help will be much appreciated
Thanks