Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
← Back to post

Revisions 2

Accidentally overwriting user data row?
Accidentally overwriting user data row?
Isn't userID not unique? As told in this [question](https://community.q2developer.com/question/1579198571771596800/is-user-id-not-sufficient-for-the-unique-customer-identifier-when-using-the-aggregator). So if userID is not unique, does that mean in the picture below the currency preference for one user in a FI can accidentally be overwritten by another user in a different FI? ![Screenshot 2023-07-11 at 8.31.14 PM.png](https://community.q2developer.com/upload/files/1689129177166_Screenshot%202023-07-11%20at%208.31.14%20PM.png)
Isn't userID not unique? As told in this [question](https://community.q2developer.com/question/1579198571771596800/is-user-id-not-sufficient-for-the-unique-customer-identifier-when-using-the-aggregator). So if userID is not unique, does that mean in the picture below the currency preference for one user in a FI can accidentally be overwritten by another user in a different FI? Same goes for say User table delete method only requires user_id? Does it delete all users with that user ID or is userID actually unique? ![Screenshot 2023-07-11 at 8.31.14 PM.png](https://community.q2developer.com/upload/files/1689129177166_Screenshot%202023-07-11%20at%208.31.14%20PM.png)
#
#
Accidentally overwriting user data row?

Isn't userID not unique? As told in this [question](https://community.q2developer.com/question/1579198571771596800/is-user-id-not-sufficient-for-the-unique-customer-identifier-when-using-the-aggregator). So if userID is not unique, does that mean in the picture below the currency preference for one user in a FI can accidentally be overwritten by another user in a different FI? Same goes for say User table delete method only requires user_id? Does it delete all users with that user ID or is userID actually unique? ![Screenshot 2023-07-11 at 8.31.14 PM.png](https://community.q2developer.com/upload/files/1689129177166_Screenshot%202023-07-11%20at%208.31.14%20PM.png)
#