Filter derived table based on the id associated with the user entered value

[jbernal]

We have a derived table that I would like to filter based on user's input on the front end explore. The main goal is for the filter to improve the number of records scanned and thus performance. However, the improved performance only happens if the user is filtering in the front end by an indexed field like id but our users don't know ids. They work with user facing identifiers like integer codes or string names.

Is there anyway to grab the user entered code/name, cross reference to that value's id, and then pass *that* into the derived table as a filter instead of the raw code/name value? That would achieve the goal of filtering the derived query by an indexed field which improves performance.