refinements to convert.input to query required info from database