#1318 Suganthi/Yekkanti Modified the logic for order by to include translations