Hey Marcio,

You mentioned that

"You put the condition to see if there is the same mobile and if returns -1 that's because it's unique among users. And you do the same thing for the other fields.

You can do it with aggregates, but you don't need to go server-side to do that query."

Of course that you need to go into the database to get this data.

Your solution can work... but only if you have the FULL list of users loaded from a query, what happens when you have 1 million users?

Not even mentioning that you are recommending using multiple ListIndexOf to get the uniqueness of the user.

Cheers,

Luís Almeida

I just was trying to avoid calling the server-side. But when you talk about millions of users I understand. If so, I will say that the best thing to do is Advance SQL in cases of performance too...

I think the author of this question wants to check the uniqueness of each field for email and mobile. Let me know if I am wrong! :)

Thank you for your reply

Kind Regards,

Márcio

Even if the database has 10 records, you don't want to fetch the list of users from the database THEN  run multiple ListIndexOf to find the uniqueness of the data.

I believe the OP wants to know if an email and mobile phone number are unique, they can either to what I recommended and that way they will find users with the same email and mobile phone number or they can do
User.Email = Email OR User.MobilePhone =PhoneNumber , in order to find any user that have either the same Email or the same PhoneNumber

And Outside of performance this would raise some eyebrows at the GDRP department

Thanks, guys, I really appreciate the explanation and the support.

Sowparnika saravanan I support the answer of @Luis Almeida.

hi

what should have datatype of Id, Email, Phone Number in that case???

UserIdentifier,vEmail, Phone Number

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Data/Data_Types/Available_Data_Types