Rita Silva
Rank: #14420
12Views
3Comments
Solved
Problems when comparing email
Question
SQL
Beginner
Database
OutSystems 11
Development

Hi,

I'm having trouble comparing the email to see if there are candidates with similar email.

If it exists, a popup will open where I will select which one I want to replace.

However, my filter doesn't seem to be working.

Right now, I'm using String_Split and then assign the result to variaInInput to just compare the variable before @ but it doesn't seem to work.


Any idea what might be happening? Is there a problem with my filter?


Var1= True and ((Candidates.Email like "%" + Candidate.Email + "%" and Candidates.Email <> "") or (Candidates.Phone like "%" + Candidate.Phone + "%" and Candidates. Phone <> ""))



PS. If I remove the parentheses, all the existing results will appear, only filter correctly when I fill in the phone number input

0
0
on 2020-10-27
Copy link to comment
Raphael Ranieri
Rank: #172
Solution

Hi Rita,
I think there are some problems there.

The first part of your filter where you put Var1 = True would be some way to bypass the filter for example if the string from Candidate vars are empty?


Maybe tou should try to put these rules in different filter inside your aggregate.

For example:

1 - 

Candidate.Email = "" or Candidates.Email like '%'+Candidate.Email+'%'

2 - 

Candidate.Phone = "" or Candidates.Phone like '%'+Candidate.Phone+'%'

1
0
on 2020-10-27
Copy link to comment
Mahesh Manchala
Rank: #259

Hi,

Is there any issue with case. If yes, please try to convert either lower case or upper case conversion also.

For eg: 

context.Email1.value.toLowerCase() === context.Email2.value.toLowerCase();


0
0
on 2020-10-27
Copy link to comment