/build/static/layout/Breadcrumb_cap_w.png

wildcards in k1000 searches

Maybe this is old news, but you can use mysql wildcards in the k100 interface when running searches. Ex. If I had a ticket/user lookup for a Donald MacSomething or McSomething that I cant recall, I can search for DM%@mydomain.edu and return the users with that combo. It looks like the % wildcard at the beginning and end of the term is implied. The single wildcard '_' (no quotes) also works. % wildcard for multiple characters, _ wilcard for single character.

Posted 10 years ago 5561 views

Comments

  • also you can separate terms with wildcards to get better results. I.e. a search for "jsmith gwashington" is going to look for exactly that string, whereas a search for "jsmith%gwashington" is going to look for those terms more generally. - tholmes 10 years ago
This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ