Im trying to find contacts/persons based on an email address, and then I need to check if an extra fields has a value or not. The code below works for all cases except when the x_personid = null, then I get 0 rows, even if there is an email match. I am assuming that this is because there is an inner join somewhere in the backend. Is there a way to change this into a left join? Or do i need to first find the person and then fetch the extra field values?
var columns = new[] { "personId", "personExtra/x_personid"};
ArchiveListItem[] results = await archiveAgent.GetArchiveListByColumnsAsync(
"person",
columns,
[
new ArchiveOrderByInfo()
{
Name = "personId",
Direction = OrderBySortType.ASC
}
],
[
new ArchiveRestrictionInfo()
{
Name = "email/emailAddress",
Operator = "=",
Values = [email],
IsActive = true
}
],
["person","personExtra"],
0,
int.MaxValue);
All Replies (1)
Never mind this. I found that i got confused by the fact that the search field in the frontend accepts dots in the email address that the api doesnt. ie per.ulv@acme.com = perulv@acme.com.