foreign Let's Take a Walk on the Wild Side with wild cards hello there I'm Kylie Alexander technical trainer at Glide fast Consulting well if you're ever trying to locate information in your list or tables you know that you can be bombarded with tons of data but sometimes you just want to narrow it down get to the subset that's going to be the most valuable to you at a given time we'll do that with wild card so what the heck are wild cards anyway well wild cards are special characters that can stand in for unknown characters and are handy for locating multiple items with similar but not identical data let me show you what I mean by hopping over into my personal developer instance and if you haven't obtained your own personal developer instance be sure to do so by going to developer.servicenow.com now here we are on the home page we're going to open the filter Navigator I'm going to Max so I'll do that by selecting control option F if you're on a PC you can do the same thing by doing Ctrl F that takes us to the filter Navigator and we're going to open the incident list and we're going to open it in a new tab by typing incident dot list all caps now this is a really cool shortcut filter Navigator feature that opens the instant list in a separate Tab and here we are in the upper left hand corner you can see a magnifying glass icon we're going to select this icon and it will allow us to do a column search the wild card that I'm going to share with you now is the wild card that will allow us to find records that contain a particular search term so we're going to go over to the short description let's say that we want to find all of the records that contain the word email so I'm going to do asterisks email and hit enter so this gave us a really nice subset of Records each of them containing the word email fantastic but what if we want to find all the records that do not contain the word email well that's in Texas exclamation point or bang asterisks and the search term so we'll go back to the short description search place in bang hit enter and now we have a different subset each of the records that do not contain the word email next we'll look for records whose short description start with email so we'll go back to that search area under short description let's zoom in a bit we'll type in the word email followed by the percentage sign will hit enter and as you see let's zoom in as you get a better look each of the short descriptions begin with the word email now what about short descriptions that end with email that would be percentage sign first and then email now keep in mind you can use these wild cards for any of the column searches we're just using the short description for our purposes today and here we are oh this is great so as you see our subset of Records now all end with the word email all right now what's really cool is if you take a look at the breadcrumbs at the very top you see that the bread crumbs are consistent with what we have entered into the column search so right under short description we were searching for records that ended with the word email in the breadcrumbs it's consistent with that I open the filter Navigator here so you can you can also see what I'm talking about short description ends with email let's clear that out select the all and we'll be taken back to the full list okay and now let's go to equals we're going to go over to let's go to the caller field and let's say that we want to find all of the records whose caller is David Liu so that will be equal sign plus the search term and our search term is David Lou and be sure that you do not put a space between the equal sign and the search term now this will render us all the records that has a caller of David Liu in our case it's just one but let me show you this too you really don't need the equal sign to get those same results so I'll go ahead and select the all to give us the full list we're going to go back to the caller search window we'll put in David Liu without the equal sign let's Zoom that in because if your vision is anything like mine this Zoom feature could be quite handy and as you see we still get the same results whether we use the equal sign or not when it does come in handy is when you want to find a subset that does not contain a particular word or phrase so we'll go back to the caller field and put bang equal sign does not equal David Lou and then hit enter fantastic now our subset of data shows all of those records whose caller is not David Liu now again I just want to point out how the breadcrumbs they tell the story too so you have a couple of options of how you can navigate and find a subset of data consistent with the information that you want to obtain isn't that pretty neat hey and until next time stay curious and I'll meet you in the next one let's go foreign [Music]