ArchiveAgent and null values in extra fields

lock
push_pin
done
Besvaret
1

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);

8 t, 28 m siden | 09.31 AM

Alle Svar (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.

7 t, 25 m siden | 10.33 AM

Tilføj svar