Advanced Config question user update rule

[Robbe_Cronos]

Hello,

We have a use case where a user is in joiner flow when:

Users.customproperty1 is not yet in the Users.customproperty1 column && 
Users.email is not null &&
Users.status = 1

How would we do this first condition in a custom database query? We thought about doing something like this:

(select COUNT(*) from users where users.customproperty1 = users.customproperty1) = 0

But we don't know how we can specify that the first users.customproperty1 is the column name and the second users.customproperty1 is the value that is added into that column of the new user added.

Any help would be appreciated!

[prasannta]

Hi @Robbe_Cronos 

Can you clarify if you are trying to compare 2 user records to form your query? Or are you trying to check if a specific users custom property 1 is set with a specific value?

Thanks

[Robbe_Cronos]

We are trying to check if any value in the customproperty1 column of the users table is the same value as customproperty1 of a user newly imported.