When I try search a record my on my site using "Search this Site" search bar it seems to not work. Do I have to set it up first or what does the search bar even search?
OK, here's a much better way to implement the search box solution, with very little coding needed. The steps are in SharePoint 2010, because that's what I have, but hopefully they are similar in 2013.
(Optional but recommended) In your new HTML Form Web Part, pull down the web part menu and select Edit Web Part. Under Form Content Editor, click on Source Editor.... A text editor pops up with the following code:
If you wish, change value="Go" to be more descriptive, for example:
and press Save.
In the HTML Form Web Part, pull down the web part menu and select Connections -> Provide Form Values To -> WIP Tracking_22415 (I believe that's your listname, and it's probably the only choice you have anyway).
You get a popup box for "Choose Connection". For Connection Type, choose Get Filter Values From and click Configure. For Provider Field Name, leave it as T1, for the Consumer Field Name, select Legacy AFE.
Click on Stop Editing.
The above should work so that if you enter a search term and click the button, the view will now show any record that has an exact match in the Legacy AFE column.
Check your Library Settings -> Advanced Settings, and make sure that Search: "Allow items from this document library to appear in search results" is set to Yes.
Another possible solution for you, if you want your users to be able to look up records by that column specifically, would be to add a form for filtering the records shown. You could add something like this in a content editor web part (html source or preferably as a file in the Content Link):
I took a guess at what your field name might be -- you might need to change the FilterField1 value. And this assumes you have jQuery somewhere (if not, it's free and will make your life easier, get it). You can of course get fancier with your script -- I stripped off any existing parameters from the URL for simplicity.