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

How to determine if a user is deleted in the database
How to determine if a login is deleted in the database
Good afternoon. In an SDK extension that is being developed, the database of users and logins is queried by using a person's login name. This works by a login result being obtained by using the login name, and then the User Id in the login result is used to get the User. An issue that we have found is that it is possible to retrieve logins and/or users that have been deleted in Q2 Central at the User and Login level. We do not these results to be possible to be obtained in our algorithm. How can we tell if Users in our search results are deleted? Is it possible to use UserStatusId to do so? Thank you, Ethan
Good afternoon. In an SDK extension that is being developed, the database of users and logins is queried by using a person's login name. This works by a login result being obtained by using the login name, and then the User Id in the login result is used to get the User. An issue that we have found is that it is possible to retrieve logins and/or users that have been deleted in Q2 Central at the User and Login level. We do not these results to be possible to be obtained in our algorithm. How can we tell if logins in our search results are deleted? Thank you, Ethan
#
#
2 years ago
How to determine if a login is deleted in the database

Good afternoon. In an SDK extension that is being developed, the database of users and logins is queried by using a person's login name. This works by a login result being obtained by using the login name, and then the User Id in the login result is used to get the User. An issue that we have found is that it is possible to retrieve logins and/or users that have been deleted in Q2 Central at the User and Login level. We do not these results to be possible to be obtained in our algorithm. How can we tell if logins in our search results are deleted? Thank you, Ethan
#