I have a custom profile table with StateID integer field in it. Now I am working on search, I have Indexed the required fields in the table and have retrieved the result using smart search result webpart.
My requirement is, user should be able to search the records using states too, but I have just the stateID in the table, how can I achieve it?
You need to include state name into your search index. You can retrieve it from database having its ID. This will require some custom coding. Please see an example in the documentation.
Please, sign in to be able to submit a new answer.