I need some help with link queries because i cant get it to return the results im expecting/hoping for,
my current query looks like:
.contains("surname", search, Case.INSENSITIVE)
.or().contains("firstname", search, Case.INSENSITIVE)
.or().contains("payrollNumber", search, Case.INSENSITIVE)
and i was expecting it to return a list of people who are in a team led by me, with the team being of a type with properties of CMS true,
however what its returning are people who are in a team led by me, but who also happen to be in a different team with a property of CMS(true or false) with another property which is set to true, as well as the expected results,
is there anyway i can change the query to make it return the results i expect, or is this just how link queries work?